Zelis - Data Engineer - Data Build Tool (5-10 yrs)

ABOUT ZELIS (STANDARD) :

As the leading payments company in healthcare, we price, pay and explain healthcare for payers, providers, and healthcare consumers. Zelis was founded on a belief there is a better way to determine the cost of a healthcare claim, manage payment-related data, and make the payment because more affordable and transparent care is good for all of us. We partner with more than 700 payers, including the top-5 national health plans, Blues plans, regional health plans, TPAs and self-insured employers, 1.5 million providers and millions of members, enabling the healthcare industry to pay for care, with care. Zelis brings adaptive technology, a deeply ingrained service culture, and an integrated pre-payment through payments platform to manage the complete payment process.

Responsibilities :

- Design, develop, and maintain Azure Data Factory Pipelines with at least 5 years of experience, ensuring scalability, reliability, and efficiency.

- Implement and optimize data pipelines in at least one Columnar MPP Cloud data warehouse (e.g., Snowflake, Azure Synapse, Redshift) for over 5 years, focusing on performance and scalability.

- Utilize ETL tools such as Fivetran and DBT for 2 years to streamline data extraction, transformation, and loading processes.

- Set up and manage version control using Git and Azure DevOps, ensuring smooth collaboration and code management.

- Work within Agile methodologies, utilizing tools like Jira and Confluence for project management and documentation.

- Develop and optimize SQL objects (procedures, triggers, views, functions) in SQL Server, with a focus on performance tuning and query optimization.

- Leverage Azure Architecture and Data Lake knowledge to design and implement scalable data solutions.

- Demonstrate a proactive and self-starting approach, capable of understanding and probing for requirements, and generating functional specifications for code migration.

Position Specification :

- This information is for the sole use of the intended recipient and may contain confidential or legally privileged information and is exempt from disclosure under applicable law.

- Any unauthorized review, use, retention, printing, disclosure, or distribution is strictly prohibited.

- Apply hands-on programming skills to optimize performance, handle large data volume transformations (100 GBs monthly), and create tailored solution/data flows to meet business requirements.

- Produce timely documentation including mapping, UTR, and defect/KEDB logs.

- Have expertise in primary technologies : Snowflake, DBT (development & testing), and secondary

technologies : Python, ETL, or any data processing tool.

- Familiarity with Snowflake, including Role-Based Access Control (RBAC), warehouse management,

and administration activities such as performance tuning and database maintenance.

Requirements :

- Bachelor's degree in Computer Science, Engineering, or related field.

- 5-8 years of experience in data engineering roles.

- Familiarity with Azure services and architecture.

- Experience in Healthcare domain is a plus.