Senior Analytics Analyst, Front-End (Pre-Service) Revenue Cycle

R1 RCM Holdco Inc.; Utah; Hybrid; USD 55,000 - 69,000; Full time

Benefits offered by this job

Competitive benefits package

Job summary

R1 RCM Holdco Inc. seeks a Senior Analytics Analyst to own reporting for the front-end revenue cycle, pulling data from multiple systems and delivering KPI-focused insight to health-system stakeholders.

You will write complex SQL, work with Databricks, build Power BI dashboards, and automate recurring reporting using Power Automate and Excel. Collaboration with engineers and program teams is essential.

Qualifications

• Intermediate or better SQL, with fluency in CTEs, row-number/window functions, unions, and join logic.
• Hands-on Databricks experience
• Advanced Excel - XLOOKUP, pivot tables
• Power BI, including comfort building with DAX
• Power Automate Experience working in analytics with complex datasets, ideally in healthcare, finance, or operations
• Strong communication skills - much of this data is obtained by asking the right people the right questions

Responsibilities

• Build and deliver recurring and ad-hoc reporting on pre-service performance for internal leaders and client stakeholders
• Source data that lives across multiple systems and owners, partnering directly with engineers and pre-service program teams to get what isn't in a database
• Write intermediate-to-advanced SQL - CTEs, window functions, unions, and the right join for the job - against Databricks and related platforms
• Develop Power BI dashboards and DAX measures that make front-end KPIs clear to non-technical audiences
• Automate recurring reporting and manual workflows using Power Automate and Excel
• Analyze complex datasets to surface trends, patterns, and anomalies, then translate them into concise summaries leadership can act on
• Validate data transfers and reporting outputs, since these metrics carry contractual obligations
• Take full ownership of a defined reporting portfolio and the stakeholder relationships that come with it

Skills

SQL

Databricks

Advanced Excel

Power BI

Power Automate

Communication skills

Tools

Databricks

Snowflake

Python

Excel

Power BI

Power Automate

Job description

About the Role

R1 is the leading provider of technology-driven solutions that transform the patient experience and financial performance of hospitals, health systems, and medical groups. We are the one company that combines the deep expertise of a global workforce of revenue cycle professionals with the industry’s most advanced technology platform, encompassing sophisticated analytics, AI, intelligent automation, and workflow orchestration. As a Senior Analytics Analyst, you will own the reporting and analysis behind R1's front-end revenue cycle - pre-registration, pre-authorization, and insurance verification. This is one of the harder analytics problems in the business: the data doesn't sit in one database, so you'll pull it together from systems, engineers, and the people who run the programs themselves. The numbers you produce go to health system stakeholders and clients as contractual KPIs, which means accuracy here has direct financial consequences. You'll join a team of three analysts, taking over a well-established and genuinely complex book of work.

What you'll do

• Build and deliver recurring and ad-hoc reporting on pre-service performance for internal leaders and client stakeholders
• Source data that lives across multiple systems and owners, partnering directly with engineers and pre-service program teams to get what isn't in a database
• Write intermediate-to-advanced SQL - CTEs, window functions, unions, and the right join for the job - against Databricks and related platforms
• Develop Power BI dashboards and DAX measures that make front-end KPIs clear to non-technical audiences
• Automate recurring reporting and manual workflows using Power Automate and Excel
• Analyze complex datasets to surface trends, patterns, and anomalies, then translate them into concise summaries leadership can act on
• Validate data transfers and reporting outputs, since these metrics carry contractual obligations
• Take full ownership of a defined reporting portfolio and the stakeholder relationships that come with it

What we're looking for

• Intermediate or better SQL, with fluency in CTEs, row-number/window functions, unions, and join logic
• Hands-on Databricks experience
• Advanced Excel - XLOOKUP, pivot tables, and the speed that comes from really knowing the tool
• Power BI, including comfort building with DAX
• Power Automate Experience working in analytics with complex datasets, ideally in healthcare, finance, or operations
• Strong communication skills - much of this data is obtained by asking the right people the right questions

Preferred

• Snowflake, Python, and experience applying AI to real analytics work (Databricks especially)

This role might be right for you if…

• You'd rather chase down a fragmented data source than wait for someone to hand you a clean table
• You like being trusted to run your own work and make your own calls
• You want your reporting to matter - these KPIs are tied to contractual commitments, not just a dashboard someone glances at
• You're curious about applying AI in day-to-day analytics
• You enjoy a collaborative team where people genuinely help each other out

Your first 30 and 90 days

First 30 days: Learning and access. You'll get provisioned across the various systems this team depends on, meet your stakeholders, and start absorbing the reporting portfolio you're inheriting. Success looks like moving access forward quickly and asking sharp questions. By 90 days: You've taken over the full scope of that portfolio and are running it independently, with your manager available for guidance and decisions rather than day-to-day direction.

Compensation

For this US-based position, the base pay range is $54,661.00 - $68,674.31 per year . Individual pay is determined by role, level, location, job-related skills, experience, and relevant education or training.

Benefits

• competitive benefits package.

Equal Employment Opportunity

R1 RCM Inc. (“the Company”) is dedicated to the fundamentals of equal employment opportunity. The Company’s employment practices , including those regarding recruitment, hiring, assignment, promotion, compensation, benefits, training, discipline, and termination shall not be based on any person’s age, color, national origin, citizenship status, physical or mental disability, medical condition, race, religion, creed, gender, sex, sexual orientation, gender identity and/or expression, genetic information, marital status, status with regard to public assistance, veteran status or any other characteristic protected by federal, state or local law. Furthermore, the Company is dedicated to providing a workplace free from harassment based on any of the foregoing protected categories. If you have a disability and require a reasonable accommodation to complete any part of the job application process, please contact us at 312-496-7709 for assistance.

About R1

R1 is the leader in healthcare revenue management, helping providers achieve new levels of performance through smart orchestration. A pioneer in the industry, R1 created the first Healthcare Revenue Operating System: a modular, intelligent platform that integrates automation, AI, and human expertise to strengthen the entire revenue cycle. With more than 20 years of experience, R1 partners with 1,000 providers, including 95 of the top 100 U.S. health systems, and handles over 270 million payer transactions annually. This scale provides unmatched operational insight to help healthcare organizations unlock greater long-term value. To learn more, visit: https://www.r1rcm.com.