SmithRx logo
SmithRx

SmithRx is a tech-forward PBM committed to changing the way pharmacy benefits are managed.

Formulary Operations Analyst

Data AnalystData AnalystOtherRemoteMid LevelTeam 51-200Since 2018H1B No SponsorCompany SiteLinkedIn

Location

United States

Posted

3 days ago

Salary

Not specified

Seniority

Mid Level

Job Description

Role Description

The Formulary Operations Specialist is responsible for the technical configuration, maintenance, and quality assurance of drug formularies within our adjudication systems. As a primary steward of data accuracy across multiple platforms, you will ensure information remains synchronized and reliable to support seamless functionality across the entire organization. You will leverage advanced data manipulation skills to translate clinical strategies into flawless operational execution.

What you will do:

  • System Configuration & Coding: Execute complex formulary coding within adjudication systems, ensuring clinical intent is accurately reflected in system logic.
  • Data Management: Utilize Advanced Excel and Google Sheets (VLOOKUP, Index/Match, Pivot Tables, and complex nested formulas) to manipulate large datasets.
  • Adjudication Oversight: Apply deep knowledge of PBM hierarchies and adjudication logic to troubleshoot rejected claims and optimize system performance.
  • Project Leadership: Manage multiple high-priority projects simultaneously, shifting priorities fluidly to meet urgent client needs or business deadlines.

Qualifications

  • Minimum of 2 years of direct experience in a PBM or Managed Care environment.
  • Having an active Pharmacy Technician license or registration is highly preferred.
  • Expert-level capability in Excel and Google Sheets, specifically for data cleaning, transformation, and complex formula building.
  • Proven experience in formulary management systems and a strong grasp of adjudication coding and hierarchy structures.
  • Deep knowledge of Medispan drug information or similar drug database platforms.
  • Exceptional critical thinking skills and the ability to solve complex problems independently.
  • Meticulous attention to detail when managing high-stakes data updates.
  • The ability to thrive and remain composed in a demanding, constantly evolving landscape.
  • Strong organizational skills with the ability to manage timelines and prioritize tasks according to business and client urgency.
  • The ability to look beyond the immediate task to understand how system updates ripple through the entire system.

Benefits

  • Highly competitive wellness benefits including Medical, Pharmacy, Dental, Vision, and Life Insurance and AD&D Insurance.
  • Flexible Spending Benefits.
  • 401(k) Retirement Savings Program.
  • Short-term and long-term disability.
  • Discretionary Paid Time Off.
  • Paid Company Holidays.
  • Wellness Benefits.
  • Commuter Benefits.
  • Paid Parental Leave benefits.
  • Employee Assistance Program (EAP).
  • Well-stocked kitchen in office locations.
  • Professional development and training opportunities.

Job Requirements

  • Minimum of 2 years of direct experience in a PBM or Managed Care environment.
  • Having an active Pharmacy Technician license or registration is highly preferred.
  • Expert-level capability in Excel and Google Sheets, specifically for data cleaning, transformation, and complex formula building.
  • Proven experience in formulary management systems and a strong grasp of adjudication coding and hierarchy structures.
  • Deep knowledge of Medispan drug information or similar drug database platforms.
  • Exceptional critical thinking skills and the ability to solve complex problems independently.
  • Meticulous attention to detail when managing high-stakes data updates.
  • The ability to thrive and remain composed in a demanding, constantly evolving landscape.
  • Strong organizational skills with the ability to manage timelines and prioritize tasks according to business and client urgency.
  • The ability to look beyond the immediate task to understand how system updates ripple through the entire system.

Benefits

  • Highly competitive wellness benefits including Medical, Pharmacy, Dental, Vision, and Life Insurance and AD&D Insurance.
  • Flexible Spending Benefits.
  • 401(k) Retirement Savings Program.
  • Short-term and long-term disability.
  • Discretionary Paid Time Off.
  • Paid Company Holidays.
  • Wellness Benefits.
  • Commuter Benefits.
  • Paid Parental Leave benefits.
  • Employee Assistance Program (EAP).
  • Well-stocked kitchen in office locations.
  • Professional development and training opportunities.

Related Categories

Related Job Pages

More Data Analyst Jobs

OtherRemoteTeam 5,001-10,000

The role involves aggregating, cleansing, and normalizing data from multiple sources, maintaining data pipelines, and troubleshooting integration issues. The analyst will analyze performance metrics, develop KPI dashboards, generate leadership reports, and translate technical findings into actionable insights.

United States
$85K - $135K / year
Radiology Partners logo

Optimization Analyst, National Cash Posting

Radiology Partners

Radiology Partners, through its owned and affiliated practices, is a leading radiology practice in the U.S., serving hospitals and other healthcare facilities across the nation. As a physician-led and physician-owned practice, we advance our bold mission by innovating across clinical value, technology, service and economics, while elevating the role of radiology and radiologists in healthcare.

Data Analyst3 days ago
OtherRemoteTeam 5,001-10,000

This role is focused on optimization within the National Cash Posting function for Company, a leading physician-led and physician-owned radiology practice in the U.S. The analyst will contribute to advancing the mission by innovating across clinical value, technology, service, and economics.

United States
Airbnb logo

Lead, Advanced Analytics, Product

Airbnb

Airbnb is a community based on connection and belonging.

Data Analyst3 days ago
OtherRemoteTeam 5,001-10,000Since 2007H1B Sponsor

This role involves conducting advanced data analysis and statistical modeling to extract actionable insights that inform strategic product decisions, including designing and analyzing experiments to measure feature impact. The individual will also be responsible for designing and building metrics to monitor performance and creating sophisticated reporting tools for stakeholders.

United States
$157K - $185K / year
OtherRemoteTeam 11-50

The EDI Analyst I supports system reporting, revenue cycle analytics, and payer data management, serving as the secondary technical resource and backup to the EDI Analyst II. Daily tasks include modifying SQL queries, analyzing EDI files for trends, assisting with AR analytics, and supporting payer issue investigations.

United States
$51.2K - $76.9K / year