Pharmacy Benefits Analyst

HealthLinX; Salt Lake City (UT); On-site; USD 95,000 - 125,000; Full time

Job summary

HealthLinX is seeking a Pharmacy Benefits Analyst to support data management, ETL, and analytical work for our data and account services teams. You will ensure reliable data, prepare reporting inputs, and build practical analytical solutions for pharmacy benefit consulting and client decision-making.

The role combines data warehouse management, quality control, BI, and pharmacy benefit analysis. The ideal candidate translates business needs into scalable data solutions and collaborates across

Qualifications

• 3+ years of professional experience in data management.
• Expert-level SQL skills and data warehouse experience.
• Experience with regulatory compliance requirements, including HIPAA.

Responsibilities

• Manage ongoing data storage, validation, preparation, and quality control processes.
• Maintain the data warehouse in SQL and support connected programs and data workflows.
• Develop Power BI reports and dashboards that address business and client needs.
• Run recurring reports for the Account Services team, including plan review reporting.
• Perform investigative analytics and communicate data discrepancies clearly to internal stakeholders.
• Identify and communicate rebate and financial reconciliation discrepancies.
• Complete repricing analyses, rebate projections, service warranty validations, and related financial reconciliations.
• Build models and forecasts to evaluate pricing terms, copays, benefit design changes, and other pharmacy industry developments.
• Interpret PBM contract terms, particularly financial guarantees and reconciliation requirements.
• Partner with the Data Team and Account Services team to understand business needs and deliver accurate, practical solutions.

Skills

SQL

Data warehousing

ETL processes

Power BI

Excel

HIPAA compliance

Education

Bachelor's degree in data science / CS or equivalent

Tools

Python

SQL Server

ETL tools

Job description

About HealthLinX

HealthLinX is a specialized consulting firm focused on optimizing prescription benefit programs. We partner with self-funded employers, health plans, unions (Taft-Hartley), and public sector organizations to improve pharmacy benefit strategies, reduce costs, and increase operational accuracy. Our expertise spans plan recommendations, PBM strategy, audits, plan design, RFP management, and fraud prevention, helping clients make smarter, data-driven decisions.

About the Role

A Pharmacy Benefits Analyst provides data management, ETL, data mining, and analytical support to the HealthLinX Data Team and Account Services team. This role is responsible for maintaining reliable data, preparing information for reporting, identifying discrepancies, and developing analytical solutions that support pharmacy benefit consulting and client decision-making.

The position combines data warehouse management, quality control, business intelligence, and pharmacy benefit analysis. The ideal candidate can translate business needs into practical, accurate, and scalable data solutions.

What You’ll Do

• Manage ongoing data storage, validation, preparation, and quality control processes.
• Maintain the data warehouse in SQL and support connected programs and data workflows.
• Develop Power BI reports and dashboards that address business and client needs.
• Run recurring reports for the Account Services team, including plan review reporting.
• Perform investigative analytics and communicate data discrepancies clearly to internal stakeholders.
• Identify and communicate rebate and financial reconciliation discrepancies.
• Complete repricing analyses, rebate projections, service warranty validations, and related financial reconciliations.
• Build models and forecasts to evaluate pricing terms, copays, benefit design changes, and other pharmacy industry developments.
• Interpret PBM contract terms, particularly financial guarantees and reconciliation requirements.
• Partner with the Data Team and Account Services team to understand business needs and deliver accurate, practical solutions.

What You Bring

• Bachelor's degree in data science, computer science, or a related field, or equivalent relevant work experience.
• Three or more years of professional experience in data management.
• Expert-level SQL skills and experience managing data warehouses.
• Direct experience with data sourcing, key data elements, data quality management, and enterprise data management policies, processes, and procedures.
• Strong understanding of the software development life cycle.
• Ability to solve large-scale, complex problems with clear and practical solutions.
• Ability to understand business needs and design solutions that meet those needs.
• Strong written and verbal communication skills and the ability to work effectively with others.
• Proficiency in Microsoft Excel, PowerPoint, Word, and common online business applications.
• Professional experience with regulatory compliance requirements, including HIPAA.

Preferred Qualifications

• Experience with Power BI, Python, or other data visualization and analytics tools.
• Experience working with pharmacy benefit management data, PBM contracts, audits, rebates, or financial reconciliations.
• Experience with predictive modeling, forecasting, ETL processes, and reporting automation.

Why HealthLinX Prescription Management Consulting?

• High-impact work influencing healthcare costs and outcomes.
• Exposure to complex and strategic consulting engagements.
• Collaborative, growth-oriented team environment.
• Opportunity to shape processes and drive innovation.