Welcome page Returning Candidate? Log back in! Sr Finance Data Analyst Job Locations US-KY-LOUISVILLE ID 2026-194665 Line of Business Amerita Position Type Full-Time Pay Min USD $130,000.00/Yr. Pay Max USD $150,000.00/Yr. 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 analyticsDevelops backend logic to analyze profitability across drug, payer, channel, therapy, branch, claim, and patient-level dimensionsManipulates and transforms large, complex datasets outside of Excel using SQL and/or other coding languagesAutomates recurring margin reporting processes to reduce manual work and improve scalabilitySupports the development of rate, mix, volume, reimbursement, and unit cost bridges explaining gross profit performanceCreates data pipelines, queries, and repeatable reporting logic for margin analytics and executive reportingPartners with the Finance Manager to translate business questions into structured data queries and analytical outputsAnalyzes impacts from ASP, AWP, WAC, MAC, acquisition cost, reimbursement rate, payer mix, and drug utilization changesIntegrates and validates data from multiple sources, including claims, revenue, COGS, drug cost, procurement, payer, branch, and financial systemsIdentifies and resolves data quality issues, mapping inconsistencies, duplicate records, missing values, and logic gapsValidates margin reporting outputs against financial statements, source system data, and operational reportingSupports claim-level and drug-level profitability analysis, including reimbursement accuracy and cost-to-claim mappingPartners with Margin Optimization to assess current claims, margin leakage, under-reimbursement, and payer-specific profitability trendsPartners with Pharmacy Procurement to track drug cost changes, manufacturer rebates, wholesaler discounts, and purchasing trendsBuilds reporting datasets and dashboards in Power BI or similar visualization toolsDocuments query logic, data definitions, mapping assumptions, and reporting methodologyMaintains strong controls around recurring reporting, including tie-outs, version control, and validation checksSupports ad hoc executive analysis related to pricing, payer strategy, reimbursement pressure, procurement savings, and margin improvement initiativesTranslates 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 fieldSignificant SQL coding experience requiredExperience manipulating large and complex datasets outside of Excel requiredExperience with one or more additional tools/languages preferred: Python, R, Alteryx, Power Query, VBA, DAX, Power BI, Tableau, or similar analytics toolsHealthcare, pharmacy, infusion pharmacy, specialty pharmacy, reimbursement, payer, or provider finance experience strongly preferredUnderstanding of pharmacy reimbursement concepts such as ASP, AWP, WAC, MAC, acquisition cost, payer reimbursement, and gross profit preferredStrong ability to build repeatable, scalable reporting logic and automate manual processesExperience working with transaction-level, claim-level, patient-level, or drug-level data preferredStrong data validation skills, including ability to reconcile reporting outputs to source systems and financial statementsAdvanced Excel skills required, but role should not be dependent on Excel as the primary data manipulation toolExperience with Power BI, SQL Server, Snowflake, Databricks, Alteryx, or similar database/reporting environments preferredStrong attention to detail and ability to identify data inconsistencies or logic errorsAbility to work closely with Finance leaders to turn complex business questions into structured analyticsStrong documentation skills, including query logic, data definitions, and reporting methodologySelf-starter with strong problem-solving skills, intellectual curiosity, and ownership mentalityStrong understanding of pharmacy reimbursement, payer dynamics, and infusion pharmacy margin drivers across PBM and Medical benefit channelsAdvanced financial modeling, variance analysis, and rate/mix/volume analytics skillsKnowledge of pharmaceutical pricing methodologies including ASP, AWP, WAC, and MACAbility to analyze large, complex datasets and translate findings into actionable business insightsExpert-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 preferredStrong 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 systemsProficiency 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 insightsExperience with reporting and data visualization tools such as Power BI or SSRS, including building dashboards, validating metrics, and supporting business users with analytical reporting needsStrong understanding of data governance, data validation, and reconciliation processes to ensure consistency and accuracy across internal and external data sourcesAbility to work collaboratively with business stakeholders, data engineers, and technical teams to gather requirements, document data flows, and support scalable analytical solutionsDriving 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**
About our Line of Business 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.
Salary Range USD $130,000.00 - $150,000.00 / Year