Senior Data Analyst RCM

Who we are:

Spire Orthopedic Partners is a growing national partnership of orthopedic practices that provides the support capital and operational resources physicians need to grow thriving practices for the future. As a Management Services Organization (MSO) Spire provides the infrastructure for administrative operations that allows practices to operate at their highest level so doctors can focus their efforts on what matters most patient care. Headquartered in Stamford Connecticut the Spire network spans the Northeast with more than 165 physicians 1800 employees 285 other clinical providers and 40 locations in New York Connecticut Rhode Island and Massachusetts.

What youll do:

Revenue cycle is the financial backbone of a healthcare organization and the data behind it is complicated. At Spire Orthopedic Partners were looking for a Senior Data Analyst who knows RCM inside and out: charges collections denials A/R aging payer mix coding patterns and can turn that data into clear actionable reporting for finance and operations leadership.

This role sits at the intersection of finance billing and data. Youll work closely with our RCM teams practice administrators and the VP of Data to build the reporting infrastructure that drives revenue performance visibility across our portfolio of orthopedic practices.

Spires leadership is highly data-driven and actively investing in accelerating our analytics capabilities. Theres an existing foundation here and were looking for someone who can assess whats working retire what isnt and build the things that will move us forward. That takes more than technical skill. It takes good judgment and the confidence to make calls.

Responsibilities/Duties:

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

Who you are:

• 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. Were on Snowflake and you should be comfortable writing complex queries from scratch not just tweaking someone elses
• 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 doesnt 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 dont add up
• Healthcare experience required; orthopedic or surgical specialty experience is a strong plus
• Bachelors 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

What we offer:

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

We are an equal-opportunity employer. Qualified Applicants are considered for positions and are evaluated without regard to actual or perceived race color creed religion national origin ancestry citizenship status age sex or gender (including pregnancy childbirth and related medical conditions) gender identity or gender expression (including transgender status) sexual orientation marital status military service and veteran status physical or mental disability protected medical condition as defined by applicable state or local law genetic information or any other characteristic protected by applicable federal state or local laws and ordinances (referred to as protected characteristics).

The final pay offered to a successful candidate will be dependent on several factors that may include but are not limited to the type and years of experience within the job the type of years and experience within the industry education etc.