Data Developer (SQL, SSIS, SSRS)

Zelis is modernizing the healthcare financial experience in the United States (U.This platform serves more than 750 payers, including the top 5 health plans, BCBS insurers, regional health plans, TPAs and self-insured employers, and millions of healthcare providers and consumers in the U.consumers, payers, and providers face significant challenges throughout the healthcare financial journey. Zelis helps streamline the process by offering solutions that improve transparency, efficiency, and communication among all parties involved. By addressing the obstacles that patients face in accessing care, navigating the intricacies of insurance claims, and the logistical challenges healthcare providers encounter with processing payments, Zelis aims to create a more seamless and effective healthcare financial system.

Zelis India plays a crucial role in this mission by supporting various initiatives that enhance the healthcare financial experience. The local team contributes to the development and implementation of innovative solutions, ensuring that technology and processes are optimized for efficiency and effectiveness. Beyond operational expertise, Zelis India cultivates a collaborative work culture, leadership development, and global exposure, creating a dynamic environment for professional growth. With hybrid work flexibility, comprehensive healthcare benefits, financial wellness programs, and cultural celebrations, we foster a holistic workplace experience. 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.

Proficient in Data Lake, Data Warehouse Concepts and Dimensional Data Model.

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, 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.

Proficient in Data Lake, Data Warehouse Concepts and Dimensional Data Model.

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.

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.

3+ Years Microsoft BI Stack (SSIS, SSRS, SSAS)

• 3+ Years data engineering experience to include data analysis.
• 3+ years programming SQL objects (procedures, triggers, views, functions) in SQL Server.
• Experience optimizing SQL queries.
• Experience designing and implementing Data Warehouse.
• Working Knowledge of Azure/AWS Architecture, Data Lake
• Must work under limited supervision. Must demonstrate good analytical skills as it relates to data identification and mapping and excellent oral communication skills.
• Must be flexible and able to multi-task and be able to work within deadlines; Experience working with an ETL tool (DBT preferred)

Working Experience designing and developing Azure/AWS Data Factory Pipelines.

Working understanding of Columnar MPP Cloud data warehouse using Snowflake.

Working knowledge managing data in the Data Lake.

Business analysis experience to analyze data to write code and drive solutions.

Working knowledge of: Git, Azure DevOps, Agile, Jira and Confluence.

Healthcare and/or Payment processing experience.