Note: The job is a remote job and is open to candidates in USA. R1 RCM provides technology-driven solutions that improve the patient experience and financial performance of hospitals, health systems, and medical groups. The Senior Analytics Analyst will own reporting and analysis for front-end revenue cycle operations, including pre-registration, pre-authorization, and insurance verification, while developing dashboards, automating workflows, validating outputs, and translating complex data into actionable insights.
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
- 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
Skills
- 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
- Snowflake, Python, and experience applying AI to real analytics work (Databricks especially)
Benefits
- Competitive benefits package.
Company Overview
Company H1B Sponsorship