Business Analyst – Dashboards & Reporting
IT Services and IT Consulting · 201-500 employees
About the role
The Business Analyst will serve as the primary bridge between PE sponsors, clinical leadership, and the data engineering team to define and validate reporting metrics. They are responsible for mapping data across multiple systems and ensuring dashboard outputs accurately reflect both financial and operational performance.
What they look for
Requirements
Candidates must possess strong healthcare domain literacy and proficiency in PE reporting metrics, data modeling, and SQL. Excellent documentation skills and the ability to manage stakeholders with competing incentives are essential for this role.
Benefits
Full description
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 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
Required Skills & Qualifications:• Healthcare/dermatology domain literacy — understanding of medical vs. cosmetic revenue streams, payer mix, and clinical workflow
- Fluency in PE reporting metrics (EBITDA, SSS, provider productivity benchmarks) and ability to translate board-level asks into buildable specs
- Working knowledge of data modeling concepts (star schema, grain) to collaborate effectively with data
- engineers/architects
- SQL proficiency (reading/validating level, minimum) to independently sanity-check figures
- Strong requirements documentation discipline — precise, unambiguous metric and spec writing
- Stakeholder 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 dashboards
Nice to Have:• Prior experience with multi-site healthcare roll-ups or M&A-driven data consolidation
- Familiarity with BI tools (Power BI, Tableau, Looker) from a requirements/QA perspective
What we look for beyond required skills In 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 honest
Are 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
Similar roles
-
Market Research and New Business Analyst
JSP Madison Heights, Michigan, United States · $75K–$120K/yr
-
Senior ICT Business Analyst
New South Wales Government Sydney, New South Wales, Australia
-
Business Analyst Intern
TCOM, L.P. Sioux Falls, South Dakota, United States
-
Staff Enterprise Systems Technical Business Analyst
Realtor.com Careers Austin, Texas, United States
-
Senior Business Analyst (Washington DC)
Accenture Federal Services Washington, District of Columbia, United States · $91K–$185K/yr
-
Senior Revenue Cycle Business Analyst & Team
Aegis Sciences Corp Nashville, Tennessee, United States