Senior Data Engineer, Healthcare Claims

McKesson is an impact-driven, Fortune 10 company that touches virtually every aspect of healthcare. We are known for delivering insights, products, and services that make quality care more accessible and affordable. Here, we focus on the health, happiness, and well-being of you and those we serve - we care.

What you do at McKesson matters. We foster a culture where you can grow, make an impact, and are empowered to bring new ideas. Together, we thrive as we shape the future of health for patients, our communities, and our people. If you want to be part of tomorrow's health today, we want to hear from you.

This role offers location flexibility and is open to candidates across the United States.

Candidates based in the Dallas-Fort Worth (DFW) area will be hired in a hybrid capacity and are expected to work onsite at our Las Colinas office a minimum of two (2) days per week, with the remaining days worked remotely. Specific in office days may be designated based on team needs and business priorities.

Current Need:

Ontada, LLC is seeking a highly skilled and experienced Senior Data Engineer specializing in claims data. This role is crucial for designing, developing, and maintaining robust data pipelines and infrastructure to support our advanced analytics and reporting initiatives related to healthcare claims. You will play a key role in ensuring data quality, accessibility, and integrity for our claims-focused products and services.

Key Responsibilities:

• Design, develop, and optimize scalable and reliable data pipelines for extracting, transforming, and loading (ETL) large volumes of healthcare claims data from various sources into our Data Platform and other analytical platforms.

• Work closely with data scientists, analysts, and product managers to understand data requirements and translate them into efficient data models and technical solutions.

• Implement and maintain data quality checks, data validation processes, and data governance standards to ensure the accuracy, completeness, and consistency of claims data.

• Develop and manage data schemas, data dictionaries, and documentation for claims-related data assets.

• Monitor and troubleshoot data pipeline performance, identify bottlenecks, and implement optimizations to improve efficiency and reduce processing times.

• Collaborate with engineering teams to integrate data solutions with existing and new applications and platforms.

• Evaluate and recommend new technologies and tools to enhance our data engineering capabilities and improve claims data management.

• Participate in code reviews, mentor junior data engineers, and contribute to best practices for data engineering within Ontada.

• Ensure compliance with healthcare data regulations (e.g., HIPAA) and internal security policies.

Minimum Requirement:

• Degree or equivalent and typically requires 7+ years of relevant experience.

Education:

• Bachelor's degree in Computer Science, Engineering, Information Systems, or a related quantitative field. Master's degree preferred.

Critical Skills:

• 7+ years of professional experience in data engineering, with a significant focus on healthcare claims data.

• Expert proficiency in SQL and experience with various relational and non-relational databases (e.g., Databricks, Postgres).

• Strong programming skills in Python, with experience in data manipulation libraries (e.g., Pandas, NumPy) and scripting for data processing.

• Extensive experience with ETL/ELT tools and platforms (e.g.Azure Databricks, dbt, Apache Spark, Azure Data Factory, Snowflake).

• Demonstrated experience with cloud data platforms (Azure preferred), particularly with services like Azure Data Factory, AKS, GitHub, GitHub Actions

• Solid understanding of healthcare claims data standards (e.g., X12 EDI 837, 835) and common claims data elements.

• Experience with data warehousing concepts, dimensional modeling, and data lake architectures.

• Knowledge of data governance principles, data security best practices, and compliance requirements in healthcare.

• Excellent problem-solving skills, attention to detail, and ability to work independently and collaboratively in a fast-paced environment.

• Strong communication skills, both written and verbal, with the ability to explain complex technical concepts to non-technical stakeholders.

• Travel up to 10%.

We are proud to offer a competitive compensation package at McKesson as part of our Total Rewards. This is determined by several factors, including performance, experience and skills, equity, regular job market evaluations, and geographical markets. The pay range shown below is aligned with McKesson's pay philosophy, and pay will always be compliant with any applicable regulations. In addition to base pay, other compensation, such as an annual bonus or long-term incentive opportunities may be offered. For more information regarding benefits at McKesson, pleaseclick here.

Our Base Pay Range for this position

McKesson has become aware of online recruiting-related scams in which individuals who are not affiliated with or authorized by McKesson are using McKesson's (or affiliated entities, like CoverMyMeds or RxCrossroads) name in fraudulent emails, job postings or social media messages. In light of these scams, please bear the following in mind:

McKesson Talent Advisors will never solicit money or credit card information in connection with a McKesson job application.

McKesson Talent Advisors do not communicate with candidates via online chatrooms or using email accounts such as Gmail or Hotmail. Note that McKesson does rely on a virtual assistant (Gia) for certain recruiting-related communications with candidates.

McKesson job postings are posted on our career site: careers.mckesson.com.

McKesson is an Equal Opportunity Employer

McKesson provides equal employment opportunities to applicants and employees, without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, protected veteran status, disability, age, genetic information, or any other legally protected category. For additional information on McKesson's full Equal Employment Opportunity policies, visit our Equal Employment Opportunity page.

McKesson welcomes and encourages applications from people with disabilities. Accommodations are available on request for candidates taking part in all aspects of the selection process. If you require accommodation please contact us by sending an email to Disability_Accommodation@McKesson.com.

Join us at McKesson!