Business Development Senior Analyst

Eye Care Partners Career•Ballwin, MO

6d•Hybrid

About The Position

EyeCare Partners is the nation’s leading provider of clinically integrated eye care. Our national network of over 300 ophthalmologists and 700 optometrists provides a lifetime of care to our patients with a mission to enhance vision, advance eye care and improve lives. Based in St. Louis, Missouri, over 650 ECP-affiliated practice locations provide care in 18 states and 80 markets, providing services that span the eye care continuum. For more information, visit www.eyecare-partners.com . SUMMARY The Business Development Senior Analyst will be responsible for the integrity, maintenance, and continuous improvement of the company's core KPI models used to analyze performance and provide actionable business insights for our healthcare services company. The ideal candidate will be making highly impactful contributions in enabling data driven decision making by building and maintaining enterprise KPIs via executive dashboards, build advanced analytics as well as ad-hoc analytics. Revenue Model Support and Maintenance: Serve as the primary manager of the Power BI revenue model(s) that calculate revenue and gross-to-net adjustments based on actual cash performance data. Design and implement robust controls and validation procedures to ensure the accuracy and reliability of the source data feeds (28 Practice Management systems and Snowflake data warehouse) into the model. Maintain comprehensive documentation of the model’s logic, assumptions, data flows, and methodology for audit and knowledge transfer purposes. Proactively identify and implement improvements to the model’s efficiency, accuracy, and granularity in response to changes in business strategy, payer contracts, or regulatory requirements. Adapt model when there are changes in PM systems (e.g. consolidation/upgrades). Routinely assess any outages from unassigned SAP locations and update all provider level mapping for accurate revenue posting at the site level. Support Accounting team with troubleshooting during month-end close process and in making performance improvements. Data Analysis and Reporting: Support enterprise KPI definitions effort in partnership with various functional and operational leaders Support documentation and management KPI definitions Build automated enterprise KPI dashboards and support data & metrics delivery to executive leadership Conduct data analysis in support of a variety of analytic solutions Collaborate with the business to determine and document data and reporting requirements Create and produce forecasts, reports, ad hoc requests, dashboards, etc. Interpret data, analyze results, and provide insights to determine operational impact, trends, and opportunities Create specifications for reports based on business requests Responsible for interpretation of results as needed Help evangelize data driven decision making across the enterprise Perform other duties as requested Cross-Functional Collaboration: Work closely with Financial Operations, Accounting, Revenue Cycle and Managed Care teams to contextualize model output, validate assumptions and ensure alignment between forecasting models and operational processes. Educate and train ECP resources on Power BI models and Snowflake environment, including aiding best practices for reviewing business performance and cash-to-net analysis. Support the OPH doctor compensation team with revenue files to prepare timely and accurate productivity accruals. Support Accounting as needed on monthly close activities and cash waterfall analysis. Serve as the financial modeling expert during external audits, clearly articulating the model’s structure and calculations.

Requirements

Demonstrated ability to frame complex analytical problems, pull data, and extract insights that led to intangible business results.
Strong understanding of the healthcare revenue cycle, including billing, coding (CPT/ICD), claims processing, and gross-to-net revenue calculations.
Exceptional attention to detail, problem-solving abilities, and the capacity to simplify and communicate complex financial concepts to non-financial audiences.
Bachelor’s degree in Finance, Accounting, Economics, or a quantitative field
3+ years in a Financial Planning & Analysis (FP&A), Business Intelligence, or Revenue Cycle Analyst role, preferably within the healthcare sector (provider, payer, or services).
Advanced financial modeling skills in Excel (VBA, Power Query, complex nested formulas).
Expert proficiency in SQL for querying large datasets.
Experience with data visualization tools (e.g., Power BI).

Nice To Haves

Knowledge of value-based care or risk-adjustment models is a plus.

Responsibilities

Serve as the primary manager of the Power BI revenue model(s) that calculate revenue and gross-to-net adjustments based on actual cash performance data.
Design and implement robust controls and validation procedures to ensure the accuracy and reliability of the source data feeds (28 Practice Management systems and Snowflake data warehouse) into the model.
Maintain comprehensive documentation of the model’s logic, assumptions, data flows, and methodology for audit and knowledge transfer purposes.
Proactively identify and implement improvements to the model’s efficiency, accuracy, and granularity in response to changes in business strategy, payer contracts, or regulatory requirements.
Adapt model when there are changes in PM systems (e.g. consolidation/upgrades).
Routinely assess any outages from unassigned SAP locations and update all provider level mapping for accurate revenue posting at the site level.
Support Accounting team with troubleshooting during month-end close process and in making performance improvements.
Support enterprise KPI definitions effort in partnership with various functional and operational leaders
Support documentation and management KPI definitions
Build automated enterprise KPI dashboards and support data & metrics delivery to executive leadership
Conduct data analysis in support of a variety of analytic solutions
Collaborate with the business to determine and document data and reporting requirements
Create and produce forecasts, reports, ad hoc requests, dashboards, etc.
Interpret data, analyze results, and provide insights to determine operational impact, trends, and opportunities
Create specifications for reports based on business requests
Responsible for interpretation of results as needed
Help evangelize data driven decision making across the enterprise
Work closely with Financial Operations, Accounting, Revenue Cycle and Managed Care teams to contextualize model output, validate assumptions and ensure alignment between forecasting models and operational processes.
Educate and train ECP resources on Power BI models and Snowflake environment, including aiding best practices for reviewing business performance and cash-to-net analysis.
Support the OPH doctor compensation team with revenue files to prepare timely and accurate productivity accruals.
Support Accounting as needed on monthly close activities and cash waterfall analysis.
Serve as the financial modeling expert during external audits, clearly articulating the model’s structure and calculations.
Perform other duties as requested