Senior Pharmacy Data Analyst

Senior Pharmacy Data Analyst

AArete is one-of-a-kind when it comes to consulting firm culture.

We're a global, innovative management and technology consulting firm with offices in the U.S., India, and Europe. Our name comes from the Greek word for excellence: "Arete." And excellence is exactly what we strive for.

We're celebrating our fourth year as one of Forbes' World's Best Management Consulting Firms - and our success starts with our people. From robust career development planning to competitive life and wellness benefits, AArete's "Culture of Care" takes a holistic approach to the employee experience.

AAretians (our team members) are leaders at every level. You are encouraged to unlock your full potential by directly contributing to our mission and prioritizing personal development and fulfillment.

The Role

We are looking for a detail-oriented Pharmacy Data Analyst to analyze large-scale pharmacy and claims datasets, generate insights, and support data-driven decision making across pharmacy operations and healthcare programs. The role involves managing pharmacy claims, prescription validation, and healthcare data across EHR/Pharmacy Information Systems, with a strong focus on Power BI-based reporting and dashboarding to enable data-driven insights.

Work You'll Do

• Analyze pharmacy claims datasets to identify trends, anomalies, and cost drivers
• Evaluate pharmacy benefit utilization, including unit cost and trend drivers, rebate impact, and 340B programs
• Partner with internal data and analytics teams to develop standardized processes, reusable queries, and data workflows
• Support pharmacy plan, client, and contract configuration activities through analytic review, testing, and validation of claim outcomes
• Validate data quality, completeness, and reasonableness of results
• Handle pharmacovigilance data management, ensuring alignment with regulatory requirements
• Maintain and manage data within EHR (Electronic Health Records) and Pharmacy Information Systems
• Design, develop, and maintain Power BI dashboards and reports to monitor pharmacy operations, claims trends, compliance metrics, and KPIs
• Lead pharmacy analytics workstreams from data intake through insight delivery and stakeholder presentation
• Provide ongoing regulatory and compliance support, including audits and reporting
• Drive project timelines, key deliverables, and issue resolution across cross-functional teams
• Identify discrepancies between configured logic and paid claim results
• Other duties as assigned

Requirements

• 6 years of experience in pharmacy data analysis, PBM, payer, or related healthcare roles
• Strong knowledge of pharmacy claims management and payer processes
• Advanced proficiency in Power BI, including dashboard creation, DAX, data modeling, and Power BI Service (workspaces, publishing, refresh schedules)
• Understanding of pharmacovigilance data and healthcare regulatory and compliance requirements
• Ability to independently analyze data and explain pharmacy KPIs and findings
• Strong analytical and problem-solving skills with high attention to detail
• Effective communication skills to interact with internal teams and stakeholders
• Familiarity with major drug compendia and reference databases, including NCPDP, Medi-Span, First Databank, CMS ASP and other public-use files, NPPES and other provider reference sources
• Understands claims logic and how to identify final status of claims
• Strong working knowledge of pharmacy claims data and concepts such as formularies, benefit designs, networks, and reimbursement
• Must be legally authorized to work in the United States without the need for employer sponsorship

Preferred Requirements

• Based in Chicago, IL, and flexible to work from our Chicago office as needed

Compensation & Benefits

• Flexible PTO, monthly half-day refuels, volunteer time off, 10 paid holidays
• Own Your Day flexible work policy
• Competitive majority employer-paid benefits: Medical, Dental, Vision, 401K Match
• Generous paid parental leave options
• Employer-paid Life Insurance, Short Term Disability, Long Term Disability
• Charitable contribution matching program
• New client commission opportunities and referral bonus program
• Bike share discount program

The estimated base salary range for this position is $125,000 - $140,000. In addition to this base salary, individuals may be eligible for an annual discretionary bonus. This range is a part of a competitive, total compensation package together with our majority employer-paid benefits and incentive pay for eligible roles. Please note that this range is a guideline, and individual total compensation may vary due to numerous factors, including but not limited to experience level, certifications, and other relevant business considerations.

AArete will accept applications until the position is filled. The job posting will be removed once the role is no longer available.

We put humans at the center of our work

We're a global management and technology consulting firm specializing in strategic profitability improvement, digital transformation, and strategy & change for clients. Our cross-industry solutions are powered by a digital-first mindset, market intelligence, and data-driven approach to deliver purposeful change, actionable insights, and guaranteed results.

But what sets us apart is our people. We are guided by our deeply embedded guiding principles: Excellence, Passion, Loyalty to Clients, Stewardship, Family, Community, Sustainability, and Inclusion.

And we've been recognized as a top firm to work for by companies like Forbes, Top Workplaces Chicago Tribune, and Consulting Magazine.

We've earned a Great Place to Work Certification and been named a World's Best Management Consulting Firm by Forbes, Vault's Top 50 Firms to Work For, Crain's Chicago Business Fast 50, Inc 5000's Fastest Growing Firms, and Consulting Magazine's Fastest Growing Firms.

Learn more about our award-winning culture

We are an Equal Employment Opportunity Employer

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.

#LI-DNI