Logo for Harris Regional Hospital - A Duke LifePoint Hospital

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

Role overview

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, and in-depth tool knowledge
  • Power BI, including comfort building with DAX

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
  • Write intermediate-to-advanced SQL against Databricks and related platforms
  • Develop Power BI dashboards and DAX measures for clear KPI presentation

Key facts

Hard skills

Other skills

  • Microsoft Excel
  • Problem Reporting
  • Communication

About the company

Harris Regional Hospital - A Duke LifePoint Hospital logo

Harris Regional Hospital - A Duke LifePoint Hospital

Hospitals & Health Care

Harris Regional Hospital, established in 1925, is an 86-bed acute and specialty care facility serving Western North Carolina with more than 100 physicians practicing in locations throughout a multi-county region, including Harris Regional Hospital Medical Park of Franklin, an outpatient facility in Macon County. LifePoint Health (NASDAQ: LPNT) is a leading healthcare company dedicated to Making Communities Healthier®. Through its subsidiaries, it provides quality inpatient, outpatient and post-acute services close to home. LifePoint owns and operates community hospitals, regional health systems, physician practices, outpatient centers, and post-acute facilities in 22 states. It is the sole community healthcare provider in the majority of the non-urban communities it serves. More information about the company can be found at www.LifePointHealth.net. All references to "LifePoint,"​ "LifePoint Health"​ or the "Company"​ used in this release refer to affiliates or subsidiaries of LifePoint Health, Inc.

Company details

IndustryHospitals & Health Care
Company size501 - 1000

Your match analysis

See how your profile stacks up against this role.

We compared the job requirements to your profile to show where you're strong and where you fall short.

Job description

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.




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.

The healthcare system is always evolving — and it’s up to us to use our shared expertise to find new solutions that can keep up. On our growing team you’ll find the opportunity to constantly learn, collaborate across groups and explore new paths for your career.


Our associates are given the chance to contribute, think boldly and create meaningful work that makes a difference in the communities we serve around the world. We go beyond expectations in everything we do. Not only does that drive customer success and improve patient care, but that same enthusiasm is applied to giving back to the community and taking care of our team — including offering a competitive benefits package.

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.

CA PRIVACY NOTICE: California resident job applicants can learn more about their privacy rights California Consent

To learn more, visit: R1RCM.com

Visit us on Facebook

Apply once. Then go straight to the hiring manager.

After you apply, unlock the direct contact details of the people who actually make the call. A quick follow-up makes you 5x more likely to land an interview.

MR

Marcus Rivera

Chief Revenue Officer

m.rivera@company.com
linkedin.com/in/marcusrivera
Unlocked after you apply
·

Revenue Analyst Related jobs

Other jobs at Harris Regional Hospital - A Duke LifePoint Hospital

Premium

Reach out to the hiring manager directly.

Gain access to the contact details of the hiring managers who actually decide, and reach out to network with them directly. That, plus more when you upgrade:

  • Full match report with fit score and gaps
  • Career diagnostics on how recruiters read you
  • Curated company matches and warm intros
  • 48h early access to new roles

Cancel anytime.