Data Warehouse Engineer Jobs in Kansas (NOW HIRING)

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.
Rx Savings Solutions, part of McKesson's CoverMyMeds organization, offers an innovative, patented software system that educates and empowers consumers to make the best healthcare choices at the lowest cost. Founded and operated by a team of pharmacists and software engineers, we support a collaborative, cost-saving solution for purchasing prescription drugs.
We currently have an opportunity for a Sr Associate Data Engineer to join our growing Business Operations data engineering team! This is a junior-level position on our team (ideally looking for 2-4 years of Data Engineering / ETL experience). This assists in planning, designing, troubleshooting, and documenting technical requirements for data flows between disparate operational systems and our data warehouse. Our ideal candidate has hands-on experience building and supporting data pipelines using PySpark, SQL, and Python in a cloud-based data environment. Experience developing ETL processes, troubleshooting production data pipelines, and working with cloud technologies such as AWS, Databricks, Azure, or similar platforms is highly preferred. We are looking for engineers who can clearly articulate their contributions to designing, building, supporting, and optimizing data solutions in production environments.
McKesson complies with all applicable U.S. immigration laws and regulations. The Company does not provide employer support or sponsorship for any immigration related employment benefit for this role.
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.
Responsibilities:

• Build, maintain, and optimize scalable ETL pipelines using PySpark, SQL, and Python
• Troubleshoot and resolve production data pipeline issues, performing root cause analysis and implementing long-term solutions
• Monitor and support data workflows to ensure reliability, performance, and data quality
• Develop and maintain reusable data ingestion and transformation frameworks
• Explore and implement the latest AWS technologies to enhance data capabilities and operational efficiency
• Collaborate across teams to understand business needs and propose innovative data solutions
• Participate in code reviews and contribute to continuous improvement of data engineering practices
• Ensure data quality, integrity, and security across all stages of the pipeline
• Document data flows, technical specifications, and operational procedures
• Support deployment and integration of data solutions into production environments

Requirements:

• Bachelor's degree in Computer Science or related technical degree, or equivalent experience, and 2+ years of experience relative to the above responsibilities
• 2+ years of experience building and supporting data pipelines using PySpark in a cloud-based data platform environment
• 2+ years of hands-on experience developing data transformation logic using PySpark and SQL
• 2+ years of experience Databricks or similar cloud-based data platforms
• 2+ years of hands-on Python development experience supporting ETL processes, automation, data transformation, or data quality initiatives
• Experience troubleshooting, supporting, and resolving issues within production ETL and data pipeline environments
• Knowledge of Structured and Unstructured data
• Possess understanding of BI concepts and be familiar with relational or multi-dimensional modeling concepts
• Understanding of RDBMS best practices and performance tuning techniques
• Experience with cloud technologies such as AWS services such as S3, CloudWatch, EC2, and passion for a role working in a cloud data warehouse.
• Experience with version control systems like Git

It would be nice if you had...

• Experience with Databricks
• Experience with AWS cloud services such as S3, CloudWatch, EC2, Glue, or Lambda
• Experience with ETL platforms such as Talend, Informatica, SSIS, or DataStage
• Experience with Agile and Scrum methodologies
• Knowledge of Java or JavaScript

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, please click here.
Our Base Pay Range for this position
$80,300 - $133,900
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 is committed to being an Equal Employment Opportunity Employer and offers opportunities to all job seekers including job seekers with disabilities. If you need a reasonable accommodation to assist with your job search or application for employment, please contact us by sending an email to (United States) Disability_Accommodation@McKesson.com or (Canada) Accessibility@mckesson.ca. Resumes or CVs submitted to this email box will not be accepted.
Join us at McKesson!