Sr. Associate Data Engineer (ETL / Databricks)

McKesson’s Corporate; Miami, Overland Park (FL, KS); On-site; USD 80,000 - 134,000; Full time

Job summary

McKesson is seeking a junior Data Engineer (ETL/Databricks) to join the Business Operations data engineering team. You will assist in planning, designing, troubleshooting, and documenting data flows between systems and our data warehouse.

The ideal candidate has 2–4 years of Data Engineering/ETL experience, Databricks, SQL, and Python, with a focus on data quality, security, and scalable pipelines in a cloud environment.

Qualifications

• Bachelor’s degree or equivalent experience, with 2+ years in data engineering.
• 2+ years with Databricks and building data pipelines ingesting customer files.
• 2+ years of SQL experience.
• 2+ years Databricks or similar cloud data platforms.
• Experience with Python.
• Knowledge of structured and unstructured data.
• Understanding of BI concepts and data modeling.
• Experience with AWS services (S3, CloudWatch, EC2) and cloud data warehouses.
• Experience with Git and version control.
• Able to work in an Agile, fast-paced environment.

Responsibilities

• Build and maintain scalable data pipelines to ingest and automate customer-provided files using ETL tools.
• Interface with cross-functional technology teams to extract, transform, and load data from diverse sources.
• Explore and implement the latest AWS technologies to enhance data capabilities and efficiency.
• Investigate and resolve data-related issues, providing support and troubleshooting.
• Collaborate across teams to understand business needs and propose 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.
• Stay current with industry trends in data engineering and cloud computing.

Skills

Data engineering

ETL pipelines

Problem solving

Communication

Documentation

Independent

Team collaboration

Education

Bachelor's degree in Computer Science or related technical degree

Tools

Databricks

SQL

Python

AWS

Git

Job description

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 Data Engineer (ETL / Databricks) 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 will have Databricks experience, ETL tool experience (i.e. Talend, Informatica, SSIS or DataStage), experience with SQL, and general-purpose programming languages such as Python or Java for data engineering/ingestion work. This individual will assist in end-to-end development of the ETL processes, data analytics, review business requirement documents, and execute object and data models.

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 and maintain scalable data pipelines to ingest and automate customer-provided files using ETL tools
• Interface with cross-functional technology teams to extract, transform, and load data from diverse sources
• Explore and implement the latest AWS technologies to enhance data capabilities and operational efficiency
• Investigate and resolve data-related issues, providing support and troubleshooting expertise
• 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
• Stay current with industry trends and emerging technologies in data engineering and cloud computing

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 with Databricks and building data pipelines to ingest and automate files provided by customers
• 2+ years of experience with SQL queries, including various SQL commands
• 2+ years of experience Databricks or similar cloud-based data platforms
• Experience with Python
• 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
• Ability to work independently and collaboratively in a fast-paced, Agile environment
• Strong problem-solving skills and attention to detail
• Excellent communication and documentation skills

Nice to have

• Experience with Agile and Scrum methodologies
• Knowledge of Java or JavaScript

Our Base Pay Range for this position $80,300 - $133,900

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) [e-mail] or (Canada) [e-mail]. Resumes or CVs submitted to this email box will not be accepted.