Data Analyst, Pharmacy Analytics

HRGi Holdings Inc; Northern (KY); Hybrid; USD 70,000 - 100,000; Full time

Benefits offered by this job

100% remote

Medical, dental & vision

HSA & FSA options

401(k) with company match

Paid Time Off

Phone & internet allowance

Town halls & executive access

AI initiatives in analytics

Job summary

Expion Health seeks a Data Analyst, Pharmacy Analytics to be the trusted source behind pharmacy data, reports, and dashboards used by Clinical, Client Operations, and Analytics teams. You will pull and validate claims data, maintain recurring reports, and support ad hoc questions.

In this role, you’ll work with Snowflake and SQL, monitor trends, ensure data quality, and collaborate across teams to deliver clear, reliable insights in a fast-paced environment. Fully remote across the US.

Qualifications

• 2+ years of analytics in pharmacy PBM or health plan setting.
• Bachelor's degree in a related field.
• Strong Excel skills with formulas, lookups, and pivots.
• Working knowledge of SQL to read, modify, and troubleshoot queries.
• Ability to perform quality control and validate analytical work.
• Strong problem-solving, written and verbal communication.
• Willingness to learn automation or AI-assisted tools while validating outputs.

Responsibilities

• Pull and validate pharmacy claims and related data using Snowflake and SQL.
• Build, maintain, and enhance recurring reports and dashboards; troubleshoot issues.
• Monitor utilization, cost, rebate yield, and drug trend data.
• QC outputs, reconcile totals, and investigate discrepancies.
• Support ad hoc analyses for clinical, formulary, or business changes.
• Manage routine Medi-Span reporting and file distribution.
• Document reports and processes; communicate findings to requestors.

Skills

Data analysis

Excel

SQL proficiency

Attention to detail

Communication

Education

Bachelor's degree

Tools

Snowflake

Power BI

Tableau

Medi-Span

Job description

Expion Health is building the future of pharmacy economics. As architects of prescription economics, we design how pharmacy value is created, aligning cost, clinical decisions, and performance into one accountable system that moves beyond rebates. We help organizations stay ahead of pharmacy market change with clear insight, bold thinking, and strategies built for what's next, leading the next era of prescription economics.

The Role

We are looking for a Data Analyst, Pharmacy Analytics to be the dependable source behind the pharmacy data, reports, and dashboards our Clinical, Client Operations, and Analytics teams rely on every day. This is a role for someone who takes pride in getting the numbers right, checking the work twice, and tracking down the real reason a result looks off.

Sitting within our Clinical & Analytic Strategy team and reporting to the Rebate & Formulary Analytics Manager, you'll pull and validate pharmacy claims data, maintain recurring reports and dashboards using SQL and Snowflake, and support ad hoc questions from internal teams and clients. You'll work closely with clinical, client operations, and analytics colleagues to turn requests into clear, trustworthy answers.

If you enjoy digging into pharmacy claims data, spotting what doesn't add up, and building processes others can rely on, you'll feel right at home here.

What You'll Own

• Pull the right data. Pull and validate pharmacy claims and related operational data using Snowflake, SQL, and other analytics platforms.
• Keep reporting running. Build, maintain, and enhance recurring reports and dashboards, and troubleshoot issues in partnership with technical owners.
• Track the trends. Monitor utilization, cost, rebate yield, share-shift, and drug trend data.
• Check the work. Perform quality control on everything you produce, reconcile totals and mappings, investigate results that don't look right, and independently validate all outputs, including those from AI-assisted tools.
• Answer the questions. Support data requests and ad hoc analyses from Clinical, Client Operations, and Analytics, including pre- and post-implementation analyses for clinical, formulary, or business changes.
• Run the routine. Manage recurring operational processes such as Medi-Span reporting and file distribution.
• Support formulary work. Handle formulary-related requests outside the primary formulary-management workflow, including one-off analyses, exceptions, and research.
• Communicate clearly. Clarify scope and turnaround with requestors, and bring client-facing conclusions and unresolved issues to your Manager before release.
• Strengthen the team. Document the reports, queries, and processes you own, support cross-training and backup coverage, and look for ways to simplify and automate routine work.

What We're Looking For

• 2+ years of experience in analytics within a pharmacy, PBM, or health plan setting.
• Bachelor's degree in business, analytics, healthcare, information systems, finance, or a related field.
• Strong Excel skills, including formulas, lookups, pivot tables, and working with large datasets.
• Working knowledge of SQL, with the ability to read, modify, and troubleshoot existing queries.
• Demonstrated ability to perform quality control and validate analytical work before it goes out the door.
• Strong problem-solving skills, including the ability to investigate discrepancies and identify root causes.
• Strong communication and organizational skills, with the ability to manage competing priorities and requests.
• Willingness to learn and apply new systems and tools, including approved automation or AI-assisted tools, while independently validating all outputs.
• A high level of discretion and the ability to maintain confidentiality.
• Comfort working in a fast-paced environment with evolving priorities.

Bonus points for:

• Snowflake experience.
• Experience building or maintaining dashboards or BI reporting in Power BI, Tableau, or similar tools.
• Reporting and trend analysis experience.
• Experience with Medi-Span or other drug-reference data.
• Exposure to pharmacy rebate, formulary, or financial reporting.

Why Expion, Why Now

This is a pivotal moment to join Expion. Our data and analytics sit at the center of how we deliver value to clients, and accurate, dependable pharmacy analytics is what makes our insight credible. As a Data Analyst, Pharmacy Analytics, you won't just deliver reports; you'll help set the standard for data quality, documentation, and automation as we grow.

Our values say it best: Build boldly, improve relentlessly. If that resonates with how you want to work, we want to talk.

Benefits & Perks

• 100% remote, work anywhere in the US
• Medical, dental & vision insurance
• HSA & FSA options
• Access to GLP-1 weight loss program
• Short & long-term disability
• Life Insurance and AD&D
• 401(k) with company match
• Paid Time Off
• Phone & internet allowance
• Town halls & direct access to executive leadership
• A company that is genuinely investing in AI, and in you!

Expion Health is an equal opportunity employer, and all qualified applicants will receive consideration for employment without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.