Note: The job is a remote job and is open to candidates in USA. McKesson is hiring a Data Analytics Engineer to design, implement, and own scalable data solutions for US Oncology datasets. The role focuses on improving data quality, reducing technical debt, managing data lifecycles, and building governed, reusable datasets and pipelines for analytics and operational reporting.
Responsibilities
- Design and implement reusable validations for completeness, accuracy, timeliness, consistency, and compliance with business rules; incorporate controls into regular pipeline monitoring and validation
- Identify and resolve high-impact technical debt by standardizing engineering patterns, simplifying data flows, and improving the reliability, scalability, and supportability of existing solutions
- Design, test, document, and implement a governed, auditable purge process that supports retention expectations, reduces unnecessary storage, and protects downstream dependencies
- Design and build trusted, reusable datasets, including consolidated patient, doctor, and employee tables, using agreed business definitions, governance standards, and validation rules
- Develop and maintain scalable star-schema models and supporting technical specifications to improve query performance, simplify data consumption, and enable consistent metric definitions
- Build and optimize data pipelines within a medallion architecture using Databricks, Python, APIs, and cloud services, ensuring secure, reliable, and cost-efficient data flow across systems
- Maintain data quality rules, lineage, technical designs, operating procedures, and support handoff materials to ensure long-term maintainability, compliance readiness, and effective production support
- Partner with data engineers, analysts, business stakeholders, and internal or third-party teams to clarify requirements, align definitions, communicate risks, and deliver measurable improvements while supporting committed project and production needs
Skills
- Degree or equivalent and typically requires 4+ years of relevant experience
- 4+ years of experience in data engineering, analytics engineering, software development, computer science, or a related field, including experience delivering and supporting production data solutions
- 4+ years of experience developing and optimizing data solutions in Databricks or Snowflake
- 4+ years of experience with Python and SQL for data pipeline, validation, automation, and application development
- Hands-on experience implementing data quality controls, monitoring, issue remediation, and reusable validation frameworks
- Experience with dimensional modeling, star schemas, database design, data warehousing, and consolidated enterprise data assets
- Ability to translate business rules into governed technical solutions and communicate complex concepts clearly to non-technical stakeholders
- Strong understanding of data governance, security, quality, lineage, retention, purge controls, and production support best practices
- Applicants must be currently authorized to work in the United States on a fulltime basis without the need for employer support or sponsorship now or in the future. This includes having the legal right to work in the United States without the need for McKesson support or sponsorship for any immigration related employment authorization (e.g., H1B, O1, E3, H1B1, TN, F1 OPT, F1 STEM OPT, F1 CPT, etc.) now or in the future
- Databricks preferred
- Must be comfortable and proficient working with large and/or complex databases
- Working knowledge with project management tools like Jira, Asana
- Strong knowledge of cloud platforms with Azure preferred
- Knowledge of data visualization tools such as Power BI, Tableau, or Looker
Benefits
- 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.
Company Overview