Sr Finance Data Analyst

Amerita•Louisville, KY

1d•$130,000 - $150,000

About The Position

The Senior Finance Data Analyst of Pharmacy Margin & Unit Economics serves as the technical analytics partner for pharmacy margin reporting, unit economics, reimbursement analysis, and profitability modeling across the infusion pharmacy business. Reporting to the Finance Manager of Pharmacy Margin & Unit Economics, the role builds, maintains, and validates backend data logic for analyzing drug-, payer-, channel-, claim-, and branch-level margin performance. This is not a traditional Excel-based FP&A role. The position requires substantial manipulation, transformation, validation, and automation of complex data outside Excel, with strong SQL coding skills and comfort working with large datasets. The analyst translates operational, reimbursement, procurement, and financial data into scalable analytics for executive reporting and business decisions. The role partners 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. The candidate must live in the Louisville, Kentucky area.

Requirements

3–6+ years of experience in data analytics, business intelligence, financial systems, FP&A analytics, healthcare analytics, pharmacy analytics, or a related field.
Significant SQL coding experience; the posting also specifies expert-level SQL knowledge and extensive experience in SQL Server environments.
Experience manipulating large and complex datasets outside Excel.
Advanced Excel skills, without relying on Excel as the primary data manipulation tool.
Strong ability to build repeatable, scalable reporting logic and automate manual processes.
Strong data validation skills, including reconciling reporting outputs to source systems and financial statements.
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 documenting query logic, data definitions, and reporting methodology.
Self-starter with strong problem-solving skills, intellectual curiosity, and an ownership mentality.
Advanced financial modeling, variance analysis, and rate/mix/volume analytics skills.
Ability to analyze large, complex datasets and translate findings into actionable business insights.
Experience developing complex SQL queries and working with relational database design, performance tuning, stored procedures, views, functions, and SQL Server Agent jobs.
Experience developing and maintaining automated data pipelines and ETL processes using SQL Server technologies.
Proficiency in data analysis and root-cause investigation, including identifying data-quality or process issues.
Strong understanding of data governance, data validation, and reconciliation processes across internal and external data sources.
Ability to live in the Louisville, Kentucky area.

Nice To Haves

Experience with 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.
Understanding of pharmacy reimbursement concepts such as ASP, AWP, WAC, MAC, acquisition cost, payer reimbursement, and gross profit.
Experience working with transaction-level, claim-level, patient-level, or drug-level data.
Experience with Power BI, SQL Server, Snowflake, Databricks, Alteryx, or similar database/reporting environments.
Familiarity with additional database platforms and data warehousing concepts.
Experience with reporting and data visualization tools such as Power BI or SSRS.
Strong understanding of pharmacy reimbursement, payer dynamics, and infusion pharmacy margin drivers across PBM and Medical benefit channels.
Knowledge of pharmaceutical pricing methodologies including ASP, AWP, WAC, and MAC.

Responsibilities

Build, maintain, and enhance SQL-based data models supporting pharmacy margin analytics.
Develop backend logic to analyze profitability across drug, payer, channel, therapy, branch, claim, and patient-level dimensions.
Manipulate and transform large, complex datasets outside Excel using SQL and/or other coding languages.
Automate recurring margin reporting to reduce manual work and improve scalability.
Support rate, mix, volume, reimbursement, and unit cost bridges explaining gross profit performance.
Create data pipelines, queries, and repeatable reporting logic for margin analytics and executive reporting.
Translate business questions into structured data queries and analytical outputs in partnership with the Finance Manager.
Analyze the effects of ASP, AWP, WAC, MAC, acquisition cost, reimbursement rate, payer mix, and drug utilization changes.
Integrate and validate data from claims, revenue, COGS, drug cost, procurement, payer, branch, and financial systems.
Identify and resolve data-quality issues, mapping inconsistencies, duplicate records, missing values, and logic gaps.
Validate margin reporting against financial statements, source-system data, and operational reporting.
Support claim- and drug-level profitability analysis, including reimbursement accuracy and cost-to-claim mapping.
Partner with Margin Optimization to assess claims, margin leakage, under-reimbursement, and payer-specific profitability trends.
Partner with Pharmacy Procurement to track drug cost changes, manufacturer rebates, wholesaler discounts, and purchasing trends.
Build reporting datasets and dashboards in Power BI or similar visualization tools.
Document query logic, data definitions, mapping assumptions, and reporting methodology.
Maintain controls for recurring reporting, including tie-outs, version control, and validation checks.
Support ad hoc executive analysis related to pricing, payer strategy, reimbursement pressure, procurement savings, and margin improvement initiatives.
Translate technical findings into clear business insights for Finance and cross-functional partners.
Develop, maintain, and optimize automated data pipelines and ETL processes using SQL Server technologies; troubleshoot failures and ensure data integrity.
Build dashboards, validate metrics, and support business users with analytical reporting needs using tools such as Power BI or SSRS.
Collaborate with business stakeholders, data engineers, and technical teams to gather requirements, document data flows, and support scalable analytical solutions.