Sr Finance Data Analyst

Our Company

Amerita

Overview

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.

 

We Offer:

• 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 

Responsibilities

• 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

Qualifications

• 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 repeatabl