Business Analyst – Dashboards & Reporting - VentureDive - Career Page

Job Overview:We're looking for a Business Analyst to be the translation layer between the PE sponsor and practice leadership, clinical and operational staff, and our data engineering and BI build team. You'll own requirements, define metrics, and validate data for dashboards that span portfolio-level financial reporting down to clinic-level operational detail.Key Responsibilities:Reconcile PE-level reporting needs (EBITDA, same-store growth, add-on/integration performance) with clinic-level operational metrics (patient volume, no-shows, provider productivity, procedure mix)Map and normalize data across multiple EMR/PM systems, billing/RCM platforms, and scheduling tools inherited from acquired locationsDefine and document a shared metrics glossary (e.g., “active patient,” “same-store,” “revenue per provider”) and secure sign-off from relevant business stakeholders, such as finance or clinical opsGather and prioritize requirements across stakeholder tiers — PE sponsor/board, practice leadership, clinic managers,physiciansWrite functional specs for the BI development team: KPIs, drill-down levels (portfolio → region → clinic → provider), refresh cadence, and access permissionsValidate dashboard output against source systems before it reaches leadership or the boardRequired Skills & Qualifications:Healthcare/dermatology domain literacy — understanding of medical vs. cosmetic revenue streams, payer mix, and clinical workflowFluency in PE reporting metrics (EBITDA, SSS, provider productivity benchmarks) and ability to translate board-level asks into buildable specsWorking knowledge of data modeling concepts (star schema, grain) to collaborate effectively with dataengineers/architectsSQL proficiency (reading/validating level, minimum) to independently sanity-check figuresStrong requirements documentation discipline — precise, unambiguous metric and spec writingStakeholder management across groups with competing incentives (growth/exit metrics vs. day-to-day operations)HIPAA/compliance awareness, particularly around patient-level data exposure in operational dashboardsNice to Have:Prior experience with multi-site healthcare roll-ups or M&A-driven data consolidationFamiliarity with BI tools (Power BI, Tableau, Looker) from a requirements/QA perspectiveWhat we look for beyond required skillsIn order to thrive at VentureDive, you…are intellectually smart and curious…have the passion for and take pride in your work…deeply believe in VentureDive’s mission, vision, and values…have a no-frills attitude…are a collaborative team player…are ethical and honestAre you ready to put your ideas into products and solutions that will be used by millions?You will find VentureDive to be a quick pace, high standards, fun and a rewarding place to work at. Not only will your work reach millions of users world-wide, you will also be rewarded with competitive salaries and benefits. If you think you have what it takes to be a VenDian, come join us ... we're having a ball!#LI-Hybrid

Job Overview:

Key Responsibilities:

Reconcile PE-level reporting needs (EBITDA, same-store growth, add-on/integration performance) with clinic-level operational metrics (patient volume, no-shows, provider productivity, procedure mix)

Map and normalize data across multiple EMR/PM systems, billing/RCM platforms, and scheduling tools inherited from acquired locations

Define and document a shared metrics glossary (e.g., “active patient,” “same-store,” “revenue per provider”) and secure sign-off from relevant business stakeholders, such as finance or clinical ops

Gather and prioritize requirements across stakeholder tiers — PE sponsor/board, practice leadership, clinic managers,physicians

Write functional specs for the BI development team: KPIs, drill-down levels (portfolio → region → clinic → provider), refresh cadence, and access permissions

Validate dashboard output against source systems before it reaches leadership or the board