Senior Data Architect - Analytics Architecture

McKesson•Columbus, OH

About The Position

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 hiring a Senior Data Architect to lead the modernization of our enterprise analytics visualization ecosystem. This role defines the architectural strategy for transitioning from on‑premises BI capabilities to modern, cloud-based solutions that support internal teams and external healthcare partners. The ideal candidate has deep experience in BI/visualization architecture, cloud migration, and enterprise-scale analytics environments—preferably within healthcare.

Requirements

Degree or equivalent and typically requires 7+ years of relevant experience
Bachelor’s degree in Computer Science, Information Systems, or related field.
7+ years of technical experience; 5+ years in analytics or BI architecture with strong focus on visualization and semantic layers.
Proven experience (5+ years) leading BI modernization or cloud migration efforts.
Strong background (5+ years) in dimensional/semantic modeling and BI performance optimization.
Experience with Azure-based analytics ecosystems and Databricks.
Comfortable supporting large-scale environments serving internal and external users.
Deep knowledge of BI security, including RLS and multi-audience access controls.
Ability to translate complex business and technical requirements into scalable architecture.

Nice To Haves

Healthcare industry experience.
Strong communication and influence across technical and business teams.
Experience with customer-facing or embedded analytics.
Background building enterprise BI standards and reusable frameworks.
Familiarity with data catalogs, metadata tools, and governance practices.
Success operating in large, distributed enterprise environments.
Ability to balance long-term strategy with incremental modernization delivery.
Bonus: Cognos experience.

Responsibilities

Evaluate and document the current on‑premises visualization environment, including semantic layers, security, performance, and integrations.
Define the target-state cloud architecture across Azure, Databricks, Tableau, and Power BI.
Build and lead a multi-year roadmap to migrate visualization platforms to cloud-based solutions.
Establish enterprise standards for semantic modeling, certified datasets, naming conventions, and governed business logic.
Develop reusable architectural patterns for: Self-service analytics Embedded/external-facing analytics Multi-tenant and secure access models Performance optimization
Architect row-level, object-level, and role-based security aligned with HIPAA and regulatory requirements.
Partner with data engineering to align upstream transformations with downstream semantic and visualization needs.
Create governance for dashboard certification, promotion workflows, metadata, and lineage visibility.
Lead design reviews to ensure alignment with modernization standards.
Mentor BI developers, analytics engineers, and architects on best practices.