Sr Engineer - Data Engineering
Zelis
About Us
Zelis is modernizing the healthcare financial experience in the United States (U.S.) across payers, providers, and healthcare consumers. We serve more than 750 payers, including the top five national health plans, regional health plans, TPAs and millions of healthcare providers and consumers across our platform of solutions. Zelis sees across the system to identify, optimize, and solve problems holistically with technology built by healthcare experts – driving real, measurable results for clients.
Why We Do What We Do
In the U.S., 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. Additionally, the team plays a vital role in maintaining high standards of service delivery and contributes to Zelis’ award-winning culture.
Position Overview
- 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:
- 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.
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.
Commitment to Diversity, Equity, Inclusion, and Belonging
At Zelis, we champion diversity, equity, inclusion, and belonging in all aspects of our operations. We embrace the power of diversity and create an environment where people can bring their authentic and best selves to work. We know that a sense of belonging is key not only to your success at Zelis, but also to your ability to bring your best each day.
Equal Employment Opportunity
Zelis is proud to be an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.
Accessibility Support
We are dedicated to ensuring our application process is accessible to all candidates. If you are a qualified individual with a disability and require reasonable accommodation with any part of the application and/or interview process, please email talentacquisition@zelis.com.