How to Apply
A cover letter is required for consideration and should be attached as the first page of your resume. The cover letter should describe your specific interest in the position and highlight skills and experience that directly relate to this role.
Job Summary
Join the Pharmacy Data Solutions team at Michigan Medicine as a Data Architect Senior, where you will serve as the technical owner of the pharmacy analytics data platform supporting operational, financial, and clinical decision-making across pharmacy services.
This role is responsible for the design, evolution, and modernization of the pharmacy data ecosystem, including data warehouse architecture, dimensional data modeling, pipeline development, and platform performance optimization. The platform supports enterprise dashboards, KPI reporting, and advanced analytics initiatives.
This is a hands-on technical leadership role operating within a small, high-autonomy team. The Data Architect Senior is expected to balance architecture strategy with practical delivery, owning initiatives end-to-end while contributing directly to implementation, QA, and analytics support when needed.
This position reports to the Director of Pharmacy Analytics.
Mission Statement
Michigan Medicine improves the health of patients, populations and communities through excellence in education, patient care, community service, research and technology development, and through leadership activities in Michigan, nationally and internationally. Our mission is guided by our Strategic Principles and has three critical components; patient care, education and research that together enhance our contribution to society.
Why Join Michigan Medicine?
Michigan Medicine is one of the largest health care complexes in the world and has been the site of many groundbreaking medical and technological advancements since the opening of the U-M Medical School in 1850. Michigan Medicine is comprised of over 30,000 employees and our vision is to attract, inspire, and develop outstanding people in medicine, sciences, and healthcare to become one of the world?s most distinguished academic health systems. In some way, great or small, every person here helps to advance this world-class institution. Work at Michigan Medicine and become a victor for the greater good.
What Benefits can you Look Forward to?
- Excellent medical, dental and vision coverage effective on your very first day
- 2:1 Match on retirement savings
Responsibilities*
Data Platform Ownership & Architecture
- Serve as the technical owner of the pharmacy analytics data platform, ensuring long-term scalability, maintainability, and reliability.
- Define and evolve data architecture standards, modeling approaches, and integration patterns.
- Own and continuously improve data models using dbt and modern analytics engineering practices.
- Identify and reduce technical debt through thoughtful model redesign and architectural improvements.
- Drive modernization efforts by evaluating and adopting new tools, patterns, and technologies where appropriate.
Data Integration & Pipeline Engineering
- Design, build, and maintain ETL/ELT pipelines integrating financial, operational, clinical, and other pharmacy data sources.
- Develop data workflows using Python, dbt, and orchestration tools such as Prefect or similar platforms.
- Establish best practices for data ingestion, transformation, archival, recovery, and lifecycle management across multiple database platforms.
- Continuously improve pipeline performance, reliability, and operational efficiency.
Data Governance, Quality & Documentation
- Establish and enforce data standards, naming conventions, and engineering best practices.
- Implement automated testing, validation, and monitoring frameworks to ensure data accuracy and reliability.
- Monitor and resolve data quality issues through root-cause analysis and reconciliation processes.
- Maintain clear and comprehensive documentation covering architecture, data models, lineage, and workflows.
- Ensure compliance with HIPAA and institutional data governance requirements.
End-to-End Delivery & Technical Leadership
- Lead end-to-end data initiatives from architecture and design through implementation, testing, and production deployment.
- Participate directly in development work when needed, including data modeling, pipeline development, QA, and troubleshooting.
- Provide technical leadership across the analytics lifecycle.
- Occasionally support dashboard development, reporting, or visualization efforts (e.g., Tableau) to ensure successful delivery.
- Collaborate closely with analysts, pharmacy leadership, and operational stakeholders to align technical solutions with business needs.
Engineering Excellence & Innovation
- Maintain version-controlled, peer-reviewed code using Git-based workflows and CI/CD pipelines.
- Promote modern development practices, including automation and AI-assisted development tools where appropriate.
- Evaluate emerging technologies and recommend solutions that improve productivity, performance, and sustainability.
- Champion ownership, technical excellence, and continuous improvement.
Required Qualifications*
Education
- Bachelor's degree in Computer Science, Information Systems, Data Science, or a related field.
- Master's degree in a relevant field preferred.
Experience
- 3-5 years of professional experience in data architecture, data engineering, analytics engineering, or enterprise data warehousing.
- Demonstrated experience designing and implementing scalable relational database and data warehouse solutions.
Strong proficiency in:
- SQL across major relational database platforms (SQL Server, PostgreSQL, Oracle, or similar).
- Python for data pipeline development and automation.
- dbt or similar analytics engineering frameworks, including dimensional modeling (star/snowflake schemas); dbt preferred.
- Workflow orchestration tools (Prefect, Dagster, Airflow, or similar); Prefect preferred.
- Git-based version control and CI/CD workflows; GitLab preferred.
Additional requirements:
- Strong analytical and problem-solving skills with the ability to independently drive technical solutions.
- Excellent communication skills with demonstrated ability to translate technical concepts for non-technical stakeholders.
- Enthusiasm for AI-assisted development tools and a drive to leverage them for productivity gains.
Desired Qualifications*
- Epic Clarity data model certification preferred. Candidates without current certification will be expected to obtain it within six months of hire.
- Experience with BI and visualization tools (e.g., Tableau, Power BI).
- Healthcare or pharmacy domain experience, including supply chain, medication utilization, or 340B program data.
- Familiarity with healthcare data standards (HL7, FHIR, RxNorm, NDC, NCPDP).
- Experience with cloud data platforms (Snowflake, Azure Synapse, Databricks, or similar).
- Experience mentoring analysts or engineers and guiding technical direction across projects.
Modes of Work
Positions that are eligible for hybrid or mobile/remote work mode are at the discretion of the hiring department. Work agreements are reviewed annually at a minimum and are subject to change at any time, and for any reason, throughout the course of employment. Learn more about the work modes.
Underfill Statement
This position may be underfilled at a lower classification depending on the qualifications of the selected candidate.
Background Screening
Michigan Medicine conducts background screening and pre-employment drug testing on job candidates upon acceptance of a contingent job offer and may use a third party administrator to conduct background screenings. Background screenings are performed in compliance with the Fair Credit Report Act. Pre-employment drug testing applies to all selected candidates, including new or additional faculty and staff appointments, as well as transfers from other U-M campuses.
Application Deadline
Job openings are posted for a minimum of seven calendar days. The review and selection process may begin as early as the eighth day after posting. This opening may be removed from posting boards and filled anytime after the minimum posting period has ended.
U-M EEO Statement
The University of Michigan is an equal employment opportunity employer.