Job Description

Westchester (Hybrid) | $75,000–$82,000 base + annual bonusOur client is an established, physician-led healthcare organization with clinics across multiple states. Its business increasingly runs on value-based care contracts, where quality and cost data affect how the organization is paid. That makes accurate reporting central to clinical, financial and operational decisions.About the roleThis is an individual contributor role on a small reporting and analytics team. You’ll take reporting requests from clinical, billing, finance, audit and leadership teams. You’ll write SQL to pull and combine data from several EHR systems, check that the numbers reconcile across sources, and deliver reports and Excel tools.Much of the reporting is still manual today. An outside partner is building a new Power BI environment, and once it’s in place, you’ll maintain and extend it. Over time you’ll replace recurring manual pulls with automated reports and dashboards.Location and scheduleOnsite Monday through Thursday, remote on Fridays.Compensation$75,000–$82,000 base, depending on experience. Includes an annual bonus and a 401(k) with company contribution.Preferred qualificationsHealthcare reporting experience with EHR data from Epic, NextGen, athenahealth or a similar systemStrong hands-on SQL, ideally SQL Server, including joins, subqueries, stored procedures and viewsAdvanced Excel, including PivotTables, formulas and data manipulationHands-on Power BI experience building or maintaining reports (expert level not required)Working knowledge of ICD-10, CPT and HCPCS codes in reporting logicA track record of finding and fixing data discrepancies between systemsExperience with lab or medication data, Epic Clarity or Caboodle, or revenue cycle and claims reportingExposure to value-based care, population health or quality measure reporting