Sr Finance Data Analyst
BrightSpring Health Services
Job Description
Job Description
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.
MUST LIVE IN THE LOUISVILLE, KY AREA
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 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**
$84k - $105k
...be doing: Reporting to the FP&A Sales Analyst Manager, the Senior Financial Analyst is... ...high degree of proficiency in analyzing data, identifying, and communicating financial... ...functionally with sales, operations, and finance departments to resolve issues affecting the...SeniorFull timeWork experience placementFlexible hoursShift work- A staffing and recruitment agency is seeking a Part-time Senior Data Analyst to establish and maintain reports and ensure vendor reimbursement processes. The role involves processing billing and analyzing ROI while maintaining the customer database. Candidates must have...SeniorRemote jobPart time
- About the job Part-time Senior Data Analyst (Remote) Job Summary Establish and maintain a system of reports and reconcile data to efficiently submit and ensure full reimbursement of vendors, contracts, and spiffs. Maintain mClub customer database by verifying eligibility...SeniorRemote jobContract workPart timeWork experience placement
- ...from initiation through completion, including scope, timelines, risks, and deliverables. Collaborate cross-functionally with HR, Finance, Benefits, IT, and external vendors. Identify and implement payroll process improvements through automation and system...SeniorHourly payLocal area
- ...worldwide Job Description/Responsibilities The Commercial Finance Analyst plays a pivotal role in driving top-line growth, optimization,... ...-leading execution of our brand plans. Leveraging advanced data analytics, this individual will deliver high-level reporting...SuggestedWork at officeLocal areaWorldwide
$77.2k - $96.5k
...Qualifications: ~ Bachelor’s degree in business, Accounting, MIS, Finance, or related field ~3+ years supporting or implementing Oracle EBS R12 and/or Oracle Cloud Financials ~ Hands-on experience with Order-to-Cash (O2C) and/or Procure-to-Pay (P2P) processes ~...SeniorFull timeShift work- ...Job Description Job Description Job Title: Information Security Vulnerability Analyst Location: Louisville, KY Job Overview System One is seeking an Information Security Vulnerability Analyst for a long-term opportunity in the Louisville, KY area. Responsibilities...Local areaNight shift
- ResponsibilitiesThe Senior Data Center Operations Analyst installs, configures, and maintains servers, networks, and storage systems according to established procedures and policies. Administers data center operations to ensure data performance, availability, and security...Senior
- V-Soft Consulting Group, Inc. is seeking a Business Analyst (Non-IT) to support accounting processes in Louisville, KY. A bachelor’s degree in accounting or finance is required, with 0-2 years of accounting experience, such as an internship. Proficiency in Excel, Word...Internship
- ...reporting requirements Different source systems and workflows Separate Epic conversion activities Independent data mapping and validation efforts A single analyst would quickly become a bottleneck for stakeholder engagement, governance facilitation, documentation...SeniorWork at officeRemote work
$90k - $110k
...highly analytical and business-minded Senior Financial Analyst - FP&A to join our finance team at our Louisville headquarters. This role will serve... ...problem solver who enjoys translating complex financial data into actionable recommendations. This position offers the...SeniorFull time- ...Senior Reimbursement Analyst Join Team Trilogy. Weekly pay, health and dental after your first month, student loan repayment, a competitive... ...accounting firms to supply Medicare and Medicaid cost report data by completing all necessary schedules and analysis utilizing...SeniorWeekly payInterim roleLocal area
- ...Financial AnalystThe BrightSpring Health Finance team is a passionate group of people with... ...making. In addition, the Senior Financial Analyst will monitor, analyze, and report on... ...ensuring accuracy and integrity of financial data and reporting.QualificationsBachelor's degree...SeniorWork at officeWork from home
- ...development and planning teams, focusing on demand-side and market-level research. A successful candidate will be adept at turning complex data into actionable insights, communicating findings clearly, and enjoying working in a fast-paced environment. This position is...SeniorFull timeLocal areaWork from home
- ...consumer-driven design recommendations. Participate in product roadmap planning by providing consumer and market insights. Data Analytics & Business Insights Analyze consumer, market, and competitive data to identify trends, opportunities, and strategic recommendations...SeniorFull timeWork from home
- ...Virginia, Washington D.C. and Maryland. We also have Specialty Finance offices in Minnesota, Missouri and Vermont. Peoples Bank prides... ...shelf reviews. Provides guidance and coaching to Credit Portfolio Analysts and serves as a subject matter expert on special projects....SeniorWork experience placementLocal area
- ...operational excellence programs. Monitor portfolio health, identify risks and issues, and proactively recommend solutions. Drive data-informed decision-making through effective use of metrics and performance indicators. Required Qualifications ~8+ years of...Local area
- An innovative healthcare technology company seeks a Revenue Operations Analyst in Louisville, KY. The role focuses on delivering insights through analytics and reporting while collaborating with the revenue team. Candidates should have a Bachelor's degree or relevant work...Work experience placement
- ...Operations team as our Revenue Operations analyst, supporting our team in delivering... ...customer success in the past. What You'll Do Data Analysis Partner with the RevOps team to... ...Business Administration, Data Analytics, Finance OR proven experience as a data analyst or...Work experience placement
- Birch Grove seeks a Data Analyst to analyze large datasets and turn data into actionable insights for business decisions in Louisville, KY. The role focuses on gathering, processing, and interpreting data, building reports, and presenting findings with clear visualization...
- Birch Grove, a tech company in Louisville, KY, seeks a Data Analyst for full-time employment. The role involves analyzing data to drive business decisions and community impact. The Data Analyst will be responsible for gathering, processing, and interpreting various types...Full time
- ...employment-based immigration sponsorship, now or in the future. Do you thrive on transforming data into actionable insights that drive strategic decisions? As a Data Analyst at Spectrum, you'll play a key role in shaping resource optimization across multiple departments...Local areaVisa sponsorship
$65k - $70k
...Financial Analyst – Purchasing & Revenue Reconciliation (Remote) Location: 100% Remote (open to candidates living in the Midwest or Southern... ..., IF statements and other advanced Excel tools to compare large data sets and flag variances Review approved invoices for products...Full timeRemote work- ...here. Let us take you where you want to go.Job DescriptionA Finance Systems Interface Analyst is responsible for maintaining the integrations between... ...other stakeholders, and providing accurate and timely data and reports. This role oversees and manages the finance information...Local area
- ...we’re on it.Job DescriptionThe Financial Analyst will be responsible for providing financial... ...a deep understanding of the underlying data, being able to spot and correct errors in... ...experience.University degree in Business or Finance; MBA preferred. Analytical, reasoning and...SeniorFlexible hours
- ...disability insurance, 401k Plan, vacation & holidays.The Lead SAP Finance Analyst serves as the functional lead for SAP Finance (FI/CO)... ...adherence to accounting policies and regulatory requirements.Data, Reporting, and AnalyticsPartner with reporting teams to support...Work at officeWorldwide3 days per week
- ...sensing of new opportunities, analyse quantitative and qualitative data, lead and coach team of managers, and proactively communicate... ...create enduring value for clients in Strategy, Risk & Transactions (SR&T) and Technology & Transformation (T&T). We deliver purpose-...SeniorWork experience placementVisa sponsorship
- ...Actuarial Analyst IILocation: This role requires associates to be in-office 1-2 days per week, fostering collaboration and connectivity... ...You Will Make an Impact:Obtains, verifies, analyzes and models data including risk reporting and forecasting.Develops Specialty product...Temporary workWork at officeLocal area2 days per week1 day per week
- ...facing role than a reserving cycle role—the work spans multiple assigned clients and deliverables.Entry-level Retirement actuarial analyst role in Louisville, Kentucky, supporting defined benefit pension clients. You'll prepare valuations, funding notices, regulatory forms...
$66.24k - $114.26k
...Actuarial Analyst ILocation: This role requires associates to be in-office 1 - 2 days per week, fostering collaboration and connectivity... ...determination of rates. Analyzes, develops and validates statistical data. The Analyst will support the Medicaid Pricing lead in...Work at officeLocal area2 days per week1 day per week
Do you want to receive more vacancies?
Subscribe and receive similar vacancies to Sr Finance Data Analyst. Be the first to apply!
- entry level financial analyst no experience Louisville, KY
- finance analyst full time Louisville, KY
- senior financial data analyst Louisville, KY
- financial crimes analyst Louisville, KY
- program finance analyst Louisville, KY
- commercial finance analyst Louisville, KY
- remote financial analyst Louisville, KY
- group financial analyst Louisville, KY
- strategic finance analyst Louisville, KY
- senior financial analyst Louisville, KY






