Senior Pharmacy Data Analyst

DescriptionSenior Pharmacy Data AnalystAArete 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 RoleWe 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 DoAnalyze pharmacy claims datasets to identify trends, anomalies, and cost driversEvaluate pharmacy benefit utilization, including unit cost and trend drivers, rebate impact, and 340B programsPartner with internal data and analytics teams to develop standardized processes, reusable queries, and data workflowsSupport pharmacy plan, client, and contract configuration activities through analytic review, testing, and validation of claim outcomesValidate data quality, completeness, and reasonableness of resultsHandle pharmacovigilance data management, ensuring alignment with regulatory requirementsMaintain and manage data within EHR (Electronic Health Records) and Pharmacy Information SystemsDesign, develop, and maintain Power BI dashboards and reports to monitor pharmacy operations, claims trends, compliance metrics, and KPIsLead pharmacy analytics workstreams from data intake through insight delivery and stakeholder presentationProvide ongoing regulatory and compliance support, including audits and reportingDrive project timelines, key deliverables, and issue resolution across cross-functional teamsIdentify discrepancies between configured logic and paid claim resultsOther duties as assignedRequirements6+ years of experience in pharmacy data analysis, PBM, payer, or related healthcare rolesStrong knowledge of pharmacy claims management and payer processesAdvanced 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 requirementsAbility to independently analyze data and explain pharmacy KPIs and findingsStrong analytical and problem-solving skills with high attention to detailEffective communication skills to interact with internal teams and stakeholdersFamiliarity 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 sourcesUnderstands claims logic and how to identify final status of claimsStrong working knowledge of pharmacy claims data and concepts such as formularies, benefit designs, networks, and reimbursementMust be legally authorized to work in the United States without the need for employer sponsorshipPreferred RequirementsBased in Chicago, IL, and flexible to work from our Chicago office as neededCompensation & BenefitsFlexible PTO, monthly half-day refuels, volunteer time off, 10 paid holidaysOwn Your Day flexible work policyCompetitive majority employer-paid benefits: Medical, Dental, Vision, 401K MatchGenerous paid parental leave optionsEmployer-paid Life Insurance, Short Term Disability, Long Term DisabilityCharitable contribution matching programNew client commission opportunities and referral bonus programBike share discount programThe 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 workWe'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 cultureWe are an Equal Employment Opportunity EmployerAll 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-DNIRequiredPreferredJob IndustriesOther