Senior Data Analyst – RCM

Spire Orthopedic Partners

Senior Data Analyst at Spire Orthopedic Partners specializing in healthcare revenue cycle analytics. Design dashboards, optimize SQL queries, and deliver actionable insights for finance leadership.

Posted 6/30/2026full-timeRemote • Connecticut • 🇺🇸 United StatesSenior💰 $102,900 - $154,300 per yearWebsite

Tech Stack

Tools & technologies

PythonSQL

About the role

Key responsibilities & impact

Design and maintain RCM dashboards and reports in Power BI covering charges, payments, adjustments, denial rates, A/R aging, days in A/R, and payer performance
Write and optimize complex SQL queries in Snowflake to extract and model data from billing systems and practice management platforms
Partner with RCM leadership, billing teams, and finance to define KPIs, understand what's driving variances, and communicate findings clearly
Build out payer-level and procedure-level analyses to identify leakage, underpayments, and denial trends
Monitor data quality across billing feeds and flag anomalies before they become problems downstream
Deliver recurring production reports and ad hoc analysis on time, with context, not just numbers
Present findings to finance, operations, and executive audiences in a way that drives decisions
Document methodology and report logic so the work is repeatable and auditable
Mentor junior team members on RCM data concepts and analytical best practices

Requirements

What you’ll need

5+ years of analytics experience with at least 3 years focused specifically on healthcare revenue cycle
Deep familiarity with RCM concepts: CPT/ICD coding, ERA/EOB processing, denial management, payer contracting basics, and A/R metrics
Strong SQL skills. We're on Snowflake, and you should be comfortable writing complex queries from scratch, not just tweaking someone else's
Power BI proficiency including data modeling, DAX, Power Query, and building reports that finance and billing teams can actually work with
Ability to work with messy, high-volume billing data and still produce clean, trustworthy outputs
Strong communication skills. You can explain what the data says, what it doesn't say, and what to do about it
Comfortable presenting findings to finance, operations, and executive leadership
Familiarity with practice management or billing platforms such as Athena or Modernizing Medicine (ModMed)
High attention to detail and a low tolerance for numbers that don't add up
Healthcare experience required; orthopedic or surgical specialty experience is a strong plus
Bachelor's degree in a quantitative, finance, or healthcare-related field
Experience with dbt for managing data transformations in Snowflake preferred
Python or R for automation and statistical analysis preferred
Familiarity with Excel at an advanced level including pivot tables, Power Query, and complex formulas
Exposure to multi-site or physician group RCM environments

Benefits

Comp & perks

Excellent growth and advancement opportunities
Dynamic environment
Access to a diverse network of practitioners
Broad infrastructure of tools and programs to enhance the employee experience
Competitive Compensation
Generous PTO
Benefits package: health, dental, vision, 401(k), etc.

ATS Keywords

✓ Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

SQLPower BIData ModelingDAXPower QueryCPT/ICD CodingA/R MetricsData AnalysisStatistical AnalysisData Transformation

Soft Skills

Strong CommunicationAttention to DetailMentoring