Senior Data Engineer

one of the leading healthcare technology Product organizations with $1.4 Billion revenue with year-on-year growth of 22% and client retention rate of 120%. we offer wide range of innovative solutions to the healthcare payers, providers, and consumers. Our services include network analytics, payment integrity and optimization, provider credentialing, and provider engagement.

• 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, 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:

• 1+ years working with a cloud-based ETL tool (DBT preferred).
• 3+ years Microsoft ETL experience with SSIS.
• 3+ 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.

Preferred Skills:

• 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.
• Working knowledge of Agile and Confluence.
• Healthcare and/or Payment processing experience.

Independence/ Accountability:

• Must be detail oriented.
• Requires minimal daily supervision.
• Should be team-oriented and be able to collaborate across teams.
• Receives detailed instruction on new assignments and determines next steps with guidance.
• Regularly reviews goals and objectives with supervisor.
• Demonstrates competence in relevant job responsibilities which allows for increasing level of independence.
• Ability to manage and prioritize multiple tasks.
• Ability to work under pressure and meet deadlines.

Problem Solving:

• Must demonstrate good analytical skills as it relates to data identification and mapping and excellent oral communication skills.
• Makes logical suggestions of likely causes of problems and independently suggests solutions.
• Excellent organizational skills are required to prioritize responsibilities, thus completing work in a timely fashion.
• Outstanding ability to multiplex tasks as required.
• Excellent project management and/or business analysis skills.
• Attention to detail and concern for impact is essential.

• Insurance Coverage

• Paid Leaves – including maternity and paternity. 
• Financial assistance for medical crisis

• Customized Mindfulness and Wellness programs 
• Hybrid Work Model

• Certification trainings for technical and soft skills 
• Access to unlimited LinkedIn Learning platform 
• Community networking and idea creation platforms 
• Mentorship programs

• Self-driven career progression tool.