Specialist, Data Engineering - Transactional Data

About the Role

Key Responsibilities

• Design and develop solutions and commissions of complex data across systems for McKesson/CoverMyMeds internal and external customers.
• Develop Data Ingestion and Integration pipelines from various sources to application data stores.
• Work with databases, files and unstructured data to identify, transport and quality test the data required to drive data synchronization tasks and 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 and end-user reporting.
• Design conceptual data models based on business reporting requirements, interacting with business partners to understand the business logic and end-use of the data.
• Work with application development teams to determine data needs and architect appropriate flows into production systems.

Requirements

• 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.
• Hands-on experience with data warehouse solutions, cloud technology, relational databases, and event streaming tools such as Postgres, SQL Server, Qlik, Databricks, Kafka, etc.
• Experience working with structured and unstructured data and within batch and real-time data streaming environments.
• Support for OLTP Applications, Real-time Analytics, Systems Integration, and Data Governance.
• Demonstrated expertise in database design and modeling for transactional systems.

Nice to Have

• Expert knowledge of cloud data technologies.
• Experience on large-scale implementation programs.
• Experience with business-critical applications.
• Experience with FHIR is a plus.
• Excellent written and verbal communication skills; timely communication with clear expectations.
• Ability to find creative solutions to complex problems.
• Strong sense of urgency and ownership for task/project completion.
• Ability to work collaboratively across multiple business and technical functions.

Qualifications

• Bachelor's degree in Computer Science, Information Systems, or related field.
• 4+ years of relevant experience.

Benefits & Perks

• Competitive compensation package as part of our Total Rewards.
• Pay range of $105,500 - $175,900, aligned with McKesson's pay philosophy.
• Additional compensation such as annual bonus or long-term incentives may be offered.
• Benefits details available via provided link.