Senior Data Analyst – RCM

🔥 6 minutes ago

🦌 Connecticut – Remote

🦌 Connecticut – Remote

💵 $102.9k - $154.3k / year

⏰ Full Time

🟠 Senior

📉 Data Analyst

Apply Now

Find Similar Remote Jobs

Receive Emails For Remote Jobs

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume

Spire Orthopedic Partners

WebsiteLinkedInAll Job Openings

1001 - 5000 employees

Founded 2021

🤝 B2B

🏢 Enterprise

B2B • Enterprise

Spire Orthopedic Partners is a forward-looking capital and management partner for leading orthopedic and spine surgeons, operating as a management services organization (MSO) that provides administrative infrastructure and strategic support. The company partners with high-growth orthopedic practices across the Northeastern United States (Connecticut, New York, Massachusetts, Rhode Island), enabling around 165 physicians and 1,800 employees across 40 locations to grow, specialize, and focus on patient care while Spire handles operations, practice integration, and business development.

📋 Description

• 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

• 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

• 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.