Lead Data Modeler

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’ Technology is looking for a Lead Data Modeler 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.  

What You'll Do: 

The Lead Data Modeler will design, develop, and maintain data models that support transactional data management, analytical data warehouses and data marts.  The ideal candidate will have a deep understanding of healthcare data along with expertise in data architecture, database design, and data warehousing, ensuring that data is structured efficiently for high performance and scalability. 

Position Description: 

• Design and implement conceptual, logical, and physical data models for healthcare applications, analytics, and interoperability. 

• Develop and maintain FHIR-based data models and support integration with FHIR servers. 

• Design and manage analytical data models that power dashboards while ensuring cost-efficient data ingress and egress. 

• Collaborate with product engineering, database administrators, data engineers, and business analysts to understand data requirements and optimize data architecture. 

• Support ETL processes and data pipelines to ensure efficient data integration and transformation. 

• Conduct data profiling and quality assessments to ensure accuracy, consistency, and integrity. 

• Document metadata, data lineage, and data dictionaries for healthcare data models. 

• Implement data governance best practices to ensure regulatory compliance 

Candidate must be based in the metropolitan area of our hub city Columbus, OH. Position will primarily allow for remote working, but candidate must reside in the Columbus, OH area and be willing to come into the office from time to time for key meetings and face time. 

We are unable to provide sponsorship now or in the future for this position.  

Minimum Qualifications: 

Degree or equivalent and typically requires 10+ years of relevant experience. Less years required if has relevant Master’s or Doctorate qualifications. 

Education: 

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

Critical Skills: 

• 10+ years of technical and professional experience 

• 5+ years of experience in data modeling and database design, with a focus on healthcare data. 

• 5+ years of experience and e