Note: The job is a remote job and is open to candidates in USA. Spire Orthopedic Partners is a growing national partnership of orthopedic practices providing support and operational resources for physicians. They are seeking a Senior Data Analyst to manage and report on revenue cycle data, collaborating with RCM teams and leadership to enhance financial performance visibility.
Responsibilities
- 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
Skills
- 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
- Generous PTO
- Benefits package: health, dental, vision, 401(k), etc.
Company Overview