Sr Finance Data Analyst

The Senior Finance Data Analyst of Pharmacy Margin & Unit Economics will serve as the technical analytics partner supporting pharmacy margin reporting, unit economics, reimbursement analysis, and profitability modeling across the infusion pharmacy business. This role will report to the Finance Manager of Pharmacy Margin & Unit Economics and will be responsible for building, maintaining, and validating the backend data logic needed to analyze complex drug-level, payer-level, channel-level, claim-level, and branch-level margin performance.

This is not a traditional Excel-based FP&A role. The data supporting pharmacy margin analysis is highly complex and requires significant manipulation, transformation, validation, and automation outside of Excel. The ideal candidate will have strong SQL coding experience, comfort working with large and complex datasets, and the ability to translate operational, reimbursement, procurement, and financial data into scalable analytics that can be used for executive reporting and business decision-making.

The role will partner closely with Finance, Market Access, Margin Optimization, Pharmacy Procurement, IT/Data teams, and operations to ensure margin reporting is accurate, repeatable, and tied to financial results., Builds, maintains, and enhances SQL-based data models supporting pharmacy margin analytics

Develops backend logic to analyze profitability across drug, payer, channel, therapy, branch, claim, and patient-level dimensions

Manipulates and transforms large, complex datasets outside of Excel using SQL and/or other coding languages

Automates recurring margin reporting processes to reduce manual work and improve scalability

Supports the development of rate, mix, volume, reimbursement, and unit cost bridges explaining gross profit performance

Creates data pipelines, queries, and repeatable reporting logic for margin analytics and executive reporting

Partners with the Finance Manager to translate business questions into structured data queries and analytical outputs

Analyzes impacts from ASP, AWP, WAC, MAC, acquisition cost, reimbursement rate, payer mix, and drug utilization changes

Integrates and validates data from multiple sources, including claims, revenue, COGS, drug cost, procurement, payer, branch, and financial systems

Identifies and resolves data quality issues, mapping inconsistencies, duplicate records, missing values, and logic gaps

Validates margin reporting outputs against financial statements, source system data, and operational reporting

Supports claim-level and drug-level profitability analysis, including reimbursement accuracy and cost-to-claim mapping

Partners with Margin Optimization to assess current claims, margin leakage, under-reimbursement, and payer-specific profitability trends

Partners with Pharmacy Procurement to track drug cost changes, manufacturer rebates, wholesaler discounts, and purchasing trends

Builds reporting datasets and dashboards in Power BI or similar visualization tools

Documents query logic, data definitions, mapping assumptions, and reporting methodology

Maintains strong controls around recurring reporting, including tie-outs, version control, and validation checks

Supports ad hoc executive analysis related to pricing, payer strategy, reimbursement pressure, procurement savings, and margin improvement initiatives

Translates technical findings into clear business insights for Finance and cross-functional partners

High School Diploma/G.E.D., 3-6+ years of experience in data analytics, business intelligence, financial systems, FP&A analytics, healthcare analytics, pharmacy analytics, or related field

Significant SQL coding experience required

Experience manipulating large and complex datasets outside of Excel required

Experience with one or more additional tools/languages preferred: Python, R, Alteryx, Power Query, VBA, DAX, Power BI, Tableau, or similar analytics tools

Healthcare, pharmacy, infusion pharmacy, specialty pharmacy, reimbursement, payer, or provider finance experience strongly preferred

Understanding of pharmacy reimbursement concepts such as ASP, AWP, WAC, MAC, acquisition cost, payer reimbursement, and gross profit preferred

Strong ability to build repeatable, scalable reporting logic and automate manual processes

Experience working with transaction-level, claim-level, patient-level, or drug-level data preferred

Strong data validation skills, including ability to reconcile reporting outputs to source systems and financial statements

Advanced Excel skills required, but role should not be dependent on Excel as the primary data manipulation tool

Experience with Power BI, SQL Server, Snowflake, Databricks, Alteryx, or similar database/reporting environments preferred

Strong attention to detail and ability to identify data inconsistencies or logic errors

Ability to work closely with Finance leaders to turn complex business questions into structured analytics

Strong documentation skills, including query logic, data definitions, and reporting methodology

Self-starter with strong problem-solving skills, intellectual curiosity, and ownership mentality

Strong understanding of pharmacy reimbursement, payer dynamics, and infusion pharmacy margin drivers across PBM and Medical benefit channels

Advanced financial modeling, variance analysis, and rate/mix/volume analytics skills

Knowledge of pharmaceutical pricing methodologies including ASP, AWP, WAC, and MAC

Ability to analyze large, complex datasets and translate findings into actionable business insights

Expert-level SQL knowledge with extensive experience working in SQL Server environments, including relational database design, complex query development, performance tuning, stored procedures, views, functions, and SQL Server Agent jobs. Familiarity with additional database platforms and data warehousing concepts is preferred

Strong experience developing and maintaining automated data pipelines and ETL processes using SQL Server technologies, with the ability to optimize data workflows, troubleshoot failures, and ensure data integrity across enterprise systems

Proficiency in data analysis and root cause investigation, with the ability to analyze large and complex datasets, identify data quality or process issues, and translate findings into actionable business insights

Experience with reporting and data visualization tools such as Power BI or SSRS, including building dashboards, validating metrics, and supporting business users with analytical reporting needs

Strong understanding of data governance, data validation, and reconciliation processes to ensure consistency and accuracy across internal and external data sources

Ability to work collaboratively with business stakeholders, data engineers, and technical teams to gather requirements, document data flows, and support scalable analytical solutions

Driving Position: No

To perform this role will require frequently siting and typing on a keyboard with fingers, and occassionally standing, walking, bending, reaching, climbing (stairs/ladders), kneeling, and stooping, The physical requirements will be the ability to push/pull and lift/carry 1-10 lbs

• Medical, Dental & Vision Benefits plus, HSA & FSA Savings Accounts

• Supplemental Coverage - Accident, Critical Illness and Hospital Indemnity Insurance

• 401(k) Retirement Plan

• Company paid Life and AD&D Insurance, Short-Term and Long-Term Disability

• Employee Discounts

• Tuition Reimbursement

• Paid Time Off & Holidays

Amerita, an affiliate of BrightSpring Health Services, is a specialty infusion company focused on providing complex pharmaceutical products and clinical services to patients outside of the hospital. Committed to excellent service, our vision is to combine the administrative efficiencies of a large organization with the flexibility, responsiveness, and entrepreneurial spirit of a local provider. For more information, please visit www.ameritaiv.com. Follow us on Facebook, LinkedIn, and X.

Res-Care, Inc., dba BrightSpring Health Services (“ResCare”), is an Equal Opportunity Employer. ResCare does not discriminate against any person on the basis of gender, r ace, color, national origin, r eligion, disability, age, veteran status, gender identity or s exual orientation in admission, treatment, or participation in its programs, services and activities, or in employment, or on the basis of gender in its health programs and activities.