← Back to jobsJob ID col-cmv8hf6lj08r0oz01d8kty262

Expion HealthPosted 30+ days ago

Data Analyst, Pharmacy Analytics

Full-time
Remote
2+ years
Competitive
Posted 30+ days ago

Expion Health is building pharmacy economics solutions that align cost, clinical decisions, and performance. The Data Analyst, Pharmacy Analytics will pull and validate pharmacy claims data, maintain reports and dashboards, monitor pharmacy trends, support ad hoc analyses, and improve data-quality and operational processes.

Posted
30+ Days Ago
Source
Ethic Leaf recruiter
Sector
Information Technology & AI

No employer link yet — an Ethic Leaf recruiter forwards your application

Responsibilities

  • Pull and validate pharmacy claims and related operational data using Snowflake, SQL, and other analytics platforms
  • Build, maintain, and enhance recurring reports and dashboards, and troubleshoot issues in partnership with technical owners
  • Monitor utilization, cost, rebate yield, share-shift, and drug trend data
  • 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
  • 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
  • Manage recurring operational processes such as Medi-Span reporting and file distribution
  • Handle formulary-related requests outside the primary formulary-management workflow, including one-off analyses, exceptions, and research
  • Clarify scope and turnaround with requestors, and bring client-facing conclusions and unresolved issues to your Manager before release
  • Document the reports, queries, and processes you own, support cross-training and backup coverage, and look for ways to simplify and automate routine work

Qualifications

  • 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

Preferred

  • 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

Required skills

Pharmacy AnalyticsPharmacy Claims DataSQLMicrosoft ExcelSnowflakeDashboard DevelopmentPower BITableauData Quality ControlTrend AnalysisMedi-SpanPharmacy Rebate Analytics

Full job description

Expion Health is building pharmacy economics solutions that align cost, clinical decisions, and performance. The Data Analyst, Pharmacy Analytics will pull and validate pharmacy claims data, maintain reports and dashboards, monitor pharmacy trends, support ad hoc analyses, and improve data-quality and operational processes.

Responsibilities

  • Pull and validate pharmacy claims and related operational data using Snowflake, SQL, and other analytics platforms
  • Build, maintain, and enhance recurring reports and dashboards, and troubleshoot issues in partnership with technical owners
  • Monitor utilization, cost, rebate yield, share-shift, and drug trend data
  • 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
  • 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
  • Manage recurring operational processes such as Medi-Span reporting and file distribution
  • Handle formulary-related requests outside the primary formulary-management workflow, including one-off analyses, exceptions, and research
  • Clarify scope and turnaround with requestors, and bring client-facing conclusions and unresolved issues to your Manager before release
  • Document the reports, queries, and processes you own, support cross-training and backup coverage, and look for ways to simplify and automate routine work

Preferred

  • 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
  • Snowflake
  • BI dashboard development
  • BI reporting
  • Power BI
  • Tableau
  • Trend analysis
  • Medi-Span
  • Drug-reference data
  • Pharmacy rebates
  • Formulary
  • Financial reporting

Benefits

  • 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

Company

  • Prescription drug and medical claims cost management software
  • Gaithersburg, Maryland, USA
  • https://expionhealth.com/
  • Founded in 1990
  • 51-200 employees

Qualifications

  • 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
  • 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
  • 2+ years of experience in analytics within a pharmacy, PBM, or health plan setting.

Required skills

  • Pharmacy Analytics, Pharmacy Claims Data, SQL, Microsoft Excel, Snowflake, Dashboard Development, Power BI, Tableau, Data Quality Control, Trend Analysis, Medi-Span, Pharmacy Rebate Analytics

Preferred skills

  • Snowflake experience, Reporting and trend analysis experience, Experience with Medi-Span or other drug-reference data

Experience

  • 2+ years

Job details

Employment type

Full-time

Seniority level

2+ years

Date posted

Oct 9, 2026

Work mode

Remote

Job source

Ethic Leaf recruiter

Company

Expion Health

Information Technology & AI

Prescription drug and medical claims cost management software

  • Gaithersburg, Maryland, USA
  • Information Technology & AI
  • 51-200 employees
  • Founded 1990
  • expionhealth.com

Similar jobs

Matched on role, skills and location · live jobs only

See more Data Analyst jobs

Consulting

1d ago

New

Senior Data Analyst, Analytics and Insights

Full-timeOn-siteUnited States$85K – $125K/yr

The Phia Group, LLC is hiring a Senior Data Analyst, Analytics & Insights to develop trusted, scalable analytics products that turn enterprise data into actionable insights.

Why similarSame rolePower BISQL

Voya Financial

1d ago

New

Analyst, Securities Referential Data

Full-timeOn-siteAtlanta, GA$95K – $115K/yr

Voya Investment Management is hiring an Analyst to maintain accurate and complete investment security referential data.

Why similarSame roleMicrosoft ExcelPower BI

X-energy

1d ago

New

Supply Chain Data Analytics Analyst

Full-timeOn-siteRockville, MD$97K – $128K/yr

X-energy is hiring a Supply Chain Data Analytics Analyst to improve supply chain performance through data analysis and reporting infrastructure.

Why similarSame rolePower BISQL

Get new Data Analyst jobs by email

Create job alert

Data Analyst, Pharmacy Analytics

Expion Health · Competitive

Apply via Ethic Leaf