Manager of HAP Pharmacy Analytics & Reporting - Fulltime
🔍 Troy, Michigan
GENERAL SUMMARY: The Manager, HAP Pharmacy Analytics & Reporting is responsible for enterprise pharmacy analytics that support Henry Ford Health and HAP across Commercial, Medicare, and Medicaid lines of business. This role leads a small team of analysts, serves as the primary analytics partner to the Pharmacy Value Committee, and converts complex payer and pharmacy datasets into actionable insights that improve financial performance, clinical outcomes, and operational efficiency. Core accountabilities include data stewardship, reproducible reporting, production-grade automation, and stakeholder partnership across CCS, HAP Quality, Finance, and Pharmacy leadership.
EDUCATION/EXPERIENCE REQUIRED: Bachelor's degree in Health Care, Business Administration, Information Systems, Computer Science, or a related field. Five (5) years in healthcare analytics with substantial exposure to payer or PBM data. Five (5) years of professional data analysis with advanced SQL. Demonstrated experience across the SDLC for analytics solutions. Experience working with large pharmacy or payer datasets and delivering production reports. Expert SQL for complex joins, optimization, and performance tracking on very large datasets. Strong analytical and statistical reasoning. Clear written and verbal communication. Proven ability to organize work, manage multiple priorities, and deliver on deadlines in a fast-moving environment. Proficiency with reporting and visualization tools and with documentation and version control practices. Working knowledge of pharmacy benefit and medical benefit data structures, PBM concepts, quality measures, and health plan operations. Preferred Experience: Experience with pharmacy quality programs including STARs. Experience with application reporting tools and dashboarding platforms. Familiarity with Epic data, McKesson EnterpriseRx, and payer data warehouses.
Additional Details
This posting represents the major duties, responsibilities, and authorities of this job, and is not intended to be a complete list of all tasks and functions. It should be understood, therefore, that incumbents may be asked to perform job-related duties beyond those explicitly described above.
Overview
Henry Ford Health partners with millions of people on their health journey, across Michigan and around the world. We offer a full continuum of services – from primary and preventative care to complex and specialty care, health insurance, a full suite of home health offerings, virtual care, pharmacy, eye care and other health care retail. With former Ascension southeast Michigan and Flint region locations now part of our team, Henry Ford’s care is available in 13 hospitals and hundreds of ambulatory care locations. Based in Detroit, Henry Ford is one of the nation’s most respected academic medical centers and is leading the Future of Health: Detroit, a $3 billion investment anchored by a reimagined Henry Ford academic healthcare campus. Learn more at henryford.com/careers.
Benefits
The health and overall well-being of our team members is our priority. That’s why we offer support in the various components of our team’s well-being: physical, emotional, social, financial and spiritual. Our Total Rewards program includes competitive health plan options, with three consumer-driven health plans (CDHPs), a PPO plan and an HMO plan. Our team members enjoy a number of additional benefits, ranging from dental and eye care coverage to tuition assistance, family forming benefits, discounts to dozens of businesses and more. Employees classified as contingent status are not eligible for benefits.
Equal Employment Opportunity/Affirmative Action Employer
Equal Employment Opportunity / Affirmative Action Employer Henry Ford Health is
committed to the hiring, advancement and fair treatment of all individuals without regard to
race, color, creed, religion, age, sex, national origin, disability, veteran status, size, height,
weight, marital status, family status, gender identity, sexual orientation, and genetic information,
or any other protected status in accordance with applicable federal and state laws.