Senior Front-End Analytics Lead - 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

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.