This list contains only the countries for which job offers have been published in the selected language (e.g., in the French version, only job offers written in French are displayed, and in the English version, only those in English).
Zelis is modernizing the healthcare financial experience in the United States (U.S.) across payers, providers, and healthcare consumers. The Sr Engineer - Data Engineering will design, develop and implement scalable data pipelines and data models, maintaining and supporting database environments.
Job Responsibility:
Design, develop and implement scalable batch/real time data pipelines (ETLs) to integrate data from a variety of sources into Data Warehouse and Data Lake
Design and implement data model changes that align with warehouse dimensional modeling standards
Responsible for maintenance and support of all database environments, design and develop data pipelines, workflow, ETL solutions on both on-prem and cloud-based environments
Design and develop SQL stored procedures, functions, views, and triggers
Design, code, test, document and troubleshoot deliverables
Collaborate with others to test and resolve issues with deliverables
Maintain awareness of and ensure adherence to Zelis standards regarding privacy
Create and maintain design documents, source to target mappings, unit test cases, data seeding
Ability to perform data analysis and data quality tests and create audit for the ETLs
Perform continuous integration and deployment using Azure DevOps and Git.
Requirements:
2+ years working with a cloud-based ETL tool (DBT preferred)
5+ years Microsoft ETL experience with SSIS
5+ Years data engineering experience to include data analysis
3+ years programming SQL objects (procedures, triggers, views, functions) in SQL Server
3+ years of experience optimizing SQL queries
Advanced understanding of T-SQL, indexes, stored procedures, triggers, functions, views, etc.
3+ Years designing and implementing dimensional Data Warehouse
Working Knowledge of Azure/AWS Architecture, Data Lake
2+ Years of experience using source control software, such as, Git and Azure DevOps, etc.
2+ years of experience working with a reporting software, such as, SSRS, Power BI, etc.
Nice to have:
1+ years designing and developing Azure Data Factory Pipelines
1+ years of Cloud data warehouse experience using Snowflake
2+ Years of experience working with a ticketing system, such as Jira
Business analysis experience to analyze data to write code and drive solutions