Junior Data Engineer: ETL & Databricks Pipelines

McKesson; Overland Park (KS); On-site; USD 80,300 - 133,900; Full time

Job summary

McKesson is seeking a Data Engineer (ETL / Databricks) to join our Business Operations data engineering team in Overland Park, KS. This junior-level position targets 2-4 years of data engineering/ETL experience, assisting in planning, designing, troubleshooting, and documenting data flows between operational systems and our data warehouse.

Proficiency in Databricks, ETL tools, SQL, and Python is preferred. You will help develop end-to-end ETL processes, review business requirements, and support

Qualifications

• 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
• 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

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

Skills

Databricks

SQL

Python

ETL

Data pipelines

AWS

Git

Agile

Education

Bachelor's degree in Computer Science or related technical field

Tools

Databricks

Talend

Informatica

SSIS

DataStage

Job description

McKesson is seeking a Data Engineer (ETL / Databricks) to join our Business Operations data engineering team in Overland Park, KS. This junior-level position targets 2-4 years of data engineering/ETL experience, assisting in planning, designing, troubleshooting, and documenting data flows between operational systems and our data warehouse.

Proficiency in Databricks, ETL tools, SQL, and Python is preferred. You will help develop end-to-end ETL processes, review business requirements, and support