Job Description
<h3>📋 Description</h3> • Gathers requirements and business process knowledge in order to transform the data in a way that is geared towards the needs of end users.
• Partner with business and data analysts, as well as business power users, to understand needs and create repeatable solutions and insights.
• Architect automated data workflows, database views, and data marts that streamline data processing and reduce manual intervention.
• Propose appropriate design solutions for building impactful data products.
• Use expert knowledge in designing, implementing, and continuously expanding data pipelines by performing extraction, transformation, and loading activities, ensuring that the data architecture is scalable and maintainable.
• Review and revise existing data flows, views, and workflows to improve processing speed, scalability, and performance.
• Collaborate with Data Governance team to ensure that data assets adhere to established data governance standards and align with business definitions for system-approved data assets.
• Sets up appropriate monitoring and notification for potential issues within data pipelines, flows, and processes.
• Expert at investigating, troubleshooting, and resolving issues while communicating with relevant parties.
• Propose and implement processes and structures for thorough testing of data solutions and production processes, following DevOps and DataOps best practices under departmental guidelines.
• Participate in Agile scrum development process to build data products in a fast yet reliable way for iterative delivery to realize immediate business value.
• Train and mentor junior developers on the team, promoting best practices in data modeling, transformation, and automation.
• On an as needed and assigned basis, provides expert maintenance and support of legacy and production processes and products. <h3>🎯 Requirements</h3> • 7 years SQL, Python and related data programming languages as well as ETL methodologies and tools such as Informatica and SSIS.
• 5 years Data warehousing and database modeling/design using industry standard tools and concepts.
• 3 years Experience with cloud data tools/technologies, especially Microsoft Azure and Databricks.
• 5 years Experience with Epic EMR databases (Clarity and Caboodle) and/or Workday ERP Reporting.
• EPIC or Other Application Certification or Accreditation (Cert Exam passed in no more than three attempts) - EPIC Epic Cogito Fundamentals and Epic Clarity and/or Caboodle data model or related certification - if and as required by role.