Business Intel Dev Sr

For roles that are 100% remote or hybrid, you must have access to a reliable high-speed internet connection to support daily job responsibilities. A minimum bandwidth of 50 Mbps download and 5 Mbps upload is required. Those fully remote associates residing in states where service is required by contract, law, or regulation will be allowed to submit for reimbursement.

Role Overview

The Pharmacy Analytics Senior Consultant role reports into VP Finance Pharmacy and is responsible for leading the development of enterprise pharmacy reporting infrastructure, foundational data assets, and actionable analytical insights across all lines of business. This role is primarily focused on building and scaling reporting layers that do not currently exist, including Medicare Part D datasets derived from PDE (Prescription Drug Event) and MMR (Membership) data sources. The position ensures accurate construction of core metrics (PMPM, scripts, utilization per 1,000, cost per script) through curated, validated datasets. The Consultant/Sr Consultant will analyze pharmacy trends to identify cost drivers and develop actionable savings opportunities while partnering with various matrix partners.

Work Arrangement

• This is a 100% Remote position but we prefer you live in EST or CST time zones

Responsibilities

• Build & Maintain Pharmacy Data Infrastructure:  Design and maintain foundational pharmacy data assets, including PDE and MMR based datasets, enabling accurate and consistent reporting across LOBs.  Develop scalable SQL/Python data pipelines and standardized data models with clear documentation and governance
• Develop Standardized Reporting & KPI Monitoring:  Develop and automate standardized pharmacy reporting and dashboards (e.g., PMPM, utilization, cost metrics) to support actuarial, finance, and operational stakeholders.  Establish and maintain consistent KPI definitions and scalable reporting solutions using BI tools
• Pharmacy Trend Analysis & Cost Driver Identification:  Analyze pharmacy data to identify key utilization and cost drivers, including mix shifts, unit cost changes, and cohort-level impacts.  Quantify savings opportunities and translate insights into actionable recommendations for business and clinical stakeholders
• Cross-Functional Support & Strategic Insights:  Partner with Actuarial, Pricing, and Analytics teams to support forecasting, rate development, and strategic initiatives.  Provide data-driven insights and reporting to guide decision-making and align pharmacy analytics with enterprise objectives
• Data Validation, Governance & Ad Hoc Analysis:  Perform data validation, reconciliation, and quality checks to ensure accuracy and consistency across reporting outputs. Maintain data governance standards and support ad hoc analyses for leadership and cross-functional stakeholders
   

Education and Experience

• Bachelor’s Degree
• At least five (5) years of experience in Medicare/Medicaid pharmacy analytics
• Advanced SQL, Python, Databricks, BI tools
• Strong healthcare claims knowledge, pharmacy preferred
• Power BI/Tableau, Excel
• Experience building reporting layers and pipelines
   

Our Comprehensive Benefits Package

Flexible work solutions including remote options, hybrid work schedules, Competitive pay, Paid time off including holidays and volunteer events, Health insurance coverage for you and your dependents on Day 1, 401(k) Tuition reimbursement and more.

Your career starts now. We’re looking for the next generation of health care leaders.

At AmeriHealth Caritas, we’re passionate about helping people get care, stay well and build healthy communities. As one of the nation's leaders in health care solutions, we offer our associates the opportunity to impact the lives of millions of people through our national footprint of products, services and award-winning programs. AmeriHealth Caritas is seeking talented, passionate individuals to join our team. Together we can build healthier communities. If you want to make a difference, we’d like to hear from you.

Headquartered in Newtown Square, AmeriHealth Caritas is a mission-driven organization with more than 30 years of experience. We deliver comprehensive, outcomes-driven care to those who need it most. We offer integrated managed care products, pharmaceutical benefit management and specialty pharmacy services, behavioral health services, and other administrative services.

Discover more about us at www.amerihealthcaritas.com.