Sr Associate 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.

CoverMyMeds is looking for a Sr Associate Data Engineer to join a unique team within our Data Engineering organization that focuses on transactional data, helping transform analytics and master data to feed back into production applications. This is a junior-level role that blends data engineering with elements of application development, making it ideal for someone with experience or exposure to relational databases, ETL processes and cloud-native technologies like Azure Data Factory, Databricks and Postgres. You'll collaborate closely with application teams, buildin data models that directly support production traffic, so familiarity or understanding of REST APIs would be a plus.

* Our preferred candidate must reside in the Columbus, OH area. Position allows for primarily working from home, with occasional in-office time.

* At this time, we are not able to offer sponsorship for employment visas. This includes individuals currently on F-1 OPT, STEM OPT, or any other visa status that would require future sponsorship. Candidates must be authorized to work in the United States on a permanent basis without the need for current or future sponsorship.

What You'll Do: 

The Sr Associate Data Engineer will support and expand the data platforms that process, store, and organize the data critical for the production application teams. 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 Sr Associate Data Engineering will work with our Data Systems Analysts and our software engineering partners to solve business problems and deliver solutions. 

Position Description:  

• Under the guidance of a senior engineer, 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 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 productions systems.  

Skills You’ll Need: 

• Bachelor's degree in. Computer Science, Information Systems, or related field, and typically has 2+ years of relative technical and professional experience