ETL Developer

Christ Hospital

Full-time - Mid Level

Hospitals

About the position

The ETL Developer position focuses on collaborating with Data & Analytics teams to maintain and support Epic Cogito related systems, including SQL databases and BI reporting. The role involves designing, developing, and optimizing ETL processes to ensure accurate data integration and transformation, while also authoring BI reports as needed.

Responsibilities

• Design, develop, and maintain ETL processes to support data integration and transformation requirements.
• Collaborate with stakeholders to understand business requirements and translate them into technical specifications.
• Implement data mappings, transformations, and data quality rules to ensure accurate and reliable data processing.
• Perform data profiling and analysis to identify data quality issues and improvement opportunities.
• Develop and execute efficient and optimized SQL queries for data extraction and transformation.
• Optimize and enhance existing ETL workflows to improve performance, scalability, and data quality.
• Collaborate with database administrators and data architect to ensure seamless integration with data sources and targets.
• Document ETL processes, data mappings, and configurations for future reference and troubleshooting.
• Conduct thorough testing and debugging of ETL processes to ensure accurate and reliable data processing.
• Stay updated with emerging ETL technologies, industry best practices, and data integration trends.
• Support troubleshooting efforts and provide timely resolution for production issues related to ETL processes.

Requirements

• Bachelors degree, or equivalent combination of education/paid job experience required.
• 3+ years of experience working with Microsoft SQL Server databases, preferably in a healthcare or related field.
• Epic data model certification in Clarity and Caboodle required.
• Advanced SQL knowledge and experience working with relational databases, query authoring (T-SQL).
• Minimum 1 year of ETL experience with Microsoft SSIS.
• Experience with healthcare reporting regulations, certifications, and compliance.
• Experience with SFTP application for automated secure transfer of extract files.
• Experience with SQL Server Administration and security.
• Experience with SQL Server Agent Administration; jobs, schedules, Integrations Services Catalog, alerts & security.
• Experience with dimensional (Star Schema) data modeling.
• Experience with modern BI tools such as Power BI (preferred), Tableau or SAP BusinessObjects.
• Experience with Microsoft suite of database related tools: Azure, Visual Studio, SSIS, SSAS, and SSRS.
• Strong analytic skills related to working with unstructured datasets.
• Experience with or knowledge of Agile Development methodologies.
• Self-starting with strong attention to detail and accuracy, and demonstrated knowledge of data architecture/data modeling.

Nice-to-haves

• Experience with Power BI, Tableau, or SAP BusinessObjects is preferred.