Data Engineer

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.

Cover My Meds ’ Data & Analytics is looking for a Specialist, Data Engineering to join our Data Engineering team. Of note, our Data Engineering Team is a highly technical group of results driven Engineers, Analysts and Architects focused on providing our internal and external clients with high quality, repeatable and scalable data solutions. Together with our various business units, the work our Data Engineering team does ultimately helps get more people the medicine they need to live healthier lives.

The Specialist, Data Engineering will support and expand the data platforms that process, store, and organize the data critical for the Data and Analytics team. This role will participate in the technical strategy and execution to provide trusted, stable, reliable, responsive, and secure solutions and proactively inform business partners on Data & Analytics platform and product health, and problem resolution. The Specialist, Data Engineering will work collaboratively with our Data Systems Analysts as well as our Analytics and Technology partners to solve business problems and deliver solutions.

• Design and develop solutions and commissions of complex data across systems for McKesson/Cover My Meds  internal and external customers.

• Develop Data Ingestion and Integration pipelines from various sources to Data Warehouse.

• Work with databases, files and unstructured data to identify, transport and quality test the data required to drive our data synchronization tasks to perform regular and incremental loads of data.

• Write program/code in SQL and/or cloud based tools such as Snowflake or Databricks to cleanse, apply business logic and standardize the data according to business rules, enabling more effective data governance along with clear and efficient end-user reporting.

• Design conceptual data model based on business reporting requirements, interacting with business partners to understand the business logic and end-use of the data.

• Work with the application development teams to determine data flow in the source system and architect an appropriate flow into the data warehouse.

Degree or equivalent and typically requires 4+ years of relevant experience.

• Bachelor's degree in Computer Science, Information Systems, or related field.

• 4+ years of technical and professional experience as a data engineer.

• Strong (4+ years) hands-on experience as a technologist working with data warehouse solutions, cloud technology, relational databases and dashboarding tools such as Databricks, Oracle, MySQL, Qlik, Tableau, SQL Server, etc.

• 4 years' experience working with structured and unstructured data and within batch and real-time streaming environments.

• Experience supporting Reporting and Analytics, Real time Analytics, Systems Integration, and Data Governance.

• Demonstrated expertise in database design and modeling.

• Expert knowledge of cloud data technologies (MS Azure).

• Experience with business-critical applications.

• Experience on large-scale implementation programs.

• Excellent written and verbal communication skills; timely communication with clear expectations. An active listener and clear communicator; can lead by influence.

• Ability to find creative solutions to complex problems.

• Exhibits a strong sense of urgency and ownership for task/project completion.

• Highly adept at working collaboratively across multiple business and technical functions to achieve results.

We are proud to offer a competitive compensation package at McKesson as part…