Azure Data Engineer Specialist

Company: MCKESSON
Location: Richmond
Posted on: May 11, 2025

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.

The Azure Data Engineer will support the migration of critical on-premises MMS applications and databases to Azure. The role involves building scalable, secure data pipelines and developing cloud-native solutions that drive insights and analytics. The engineer will collaborate with the Data & Advanced Analytics team, focusing on ELT modernization, data pipeline orchestration, and compliance with McKesson MMS standards and Madillion architecture. Here's an overview of their responsibilities, required skills, and tools they commonly use:

Key Responsibilities:

Data Ingestion:

• Building pipelines to extract data from multiple sources (on-premises, cloud, or APIs).
• Utilizing tools likeAzure Data Factory,Azure Synapse Pipelines, orDatabricks.
  Data Transformation:
  
  • Experience with traditional ETL tools (such as DataStage, Informatica etc) and ability to translate them to cloud based solutions.
  • Leveraging tools likeAzure Data Factory,Azure Databricks, andSQL Server Integration Services (SSIS).
    Data Storage:
    
    • ---Designing and managing data storage solutions usingAzure Blob Storage,Azure Data Lake,Azure SQL Database,Cosmos DB, orSynapse Analytics.
      Data Security & Compliance:
      
      • Ensuring data is secure by implementing encryption, access controls, and data governance aligned with HIPAA, GDPR and internal policies.
        Big Data & Analytics:
        
        • Implementing big data solutions usingApache Spark,Databricks, andSynapse Analyticsfor advanced analytics.
        • Integrating withAzure Machine Learningor Power BI for insights.
          Real-Time Data Processing:
          
          • Working with tools likeAzure Stream Analytics,Event Hubs, andIoT Hubfor real-time data ingestion and processing.
            Monitoring and Optimization:
            
            • Optimizing pipelines for cost and performance.
            • Monitoring workflows and systems usingAzure MonitororLog Analytics.
              
              Minimum Requirements-Degree or equivalent and typically requires 7+ years of relevant experience.
              
              Critical Skills:
              
              • Proficiency in Python, SQL, and possibly Scala or Java for Spark jobs.
              • Azure Databricks:Apache Spark-based analytics platform.
              • Designing star schemas, snowflake schemas, and other data models.
              • Strong understanding of Azure services like Data Factory, Synapse, Databricks, and more.
              • Familiarity with Snowflake architecture, data sharing and performance tuning.
              • Knowledge of CI/CD pipelines and version control for data workflows.
              • Problem-solving, critical thinking, and collaboration with business stakeholders.
              • 
                Nice to have:
                
                • Microsoft Certified: Azure Data Engineer Associate (DP-203):Covers data storage, processing, security, and integration.
                • Databricks Unity catalog:covers centralized access control, auditing, lineage and data discovery.
                • Azure Data Factory (ADF):Orchestrates data workflows.
                • Azure Synapse Analytics:Unifies data integration, warehousing, and analytics.
                • Azure Data Lake:Stores large-scale data securely.
                • Azure SQL Database:Relational database for structured data.
                • Event Hubs / Stream Analytics:Handles real-time streaming data.
                  
                  Candidate must be authorized to work in the U.S, now or in the future, without the support from McKesson.
                  
                  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
                  
                  $122,900 - $204,800
                  
                  McKesson is an Equal Opportunity Employer
                  
                  McKesson provides equal employment opportunities to applicants and employees and is committed to a diverse and inclusive environment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, protected veteran status, disability, age or genetic information. For additional information on McKesson's full Equal Employment Opportunity policies, visit our Equal Employment Opportunity page.
                  
                  Join us at McKesson!

Keywords: MCKESSON, Newport News , Azure Data Engineer Specialist, Engineering , Richmond, Virginia