Data Analyst-Revenue Cycle Management (Full-Time)

The Iowa Clinic

West Des Moines, IA

JOB DETAILS
SALARY
JOB TYPE
Full-time
SKILLS
Accounts Receivable, Analysis Skills, Billing, Business Intelligence, Cerner, Charge Capture, Communication Skills, Continuous Improvement, Credit and Collections, Data Analysis, Data Modeling, Data Quality, Data Sets, Data Structures, Data Visualization Tools, Data Warehousing, Dental Insurance, Detail Oriented, Epic Systems, Finance, Financial Management, Financial Reporting, Healthcare, Healthcare Administration, ICD-10, Incentive Programs, Information Technology & Information Systems, Leadership, Medical Coding, Medical Record System, Microsoft Excel, Multitasking, Operational Measurement, Operational Strategy, Operational Support, Performance Analysis, Performance Metrics, Pivot Tables, Power BI, Problem Solving Skills, Process Improvement, Reconciliation, Reimbursement, Reporting Dashboards, Requirements Management, Revenue Analysis, Revenue Management, SQL (Structured Query Language), Strategic Analysis, System Operations, Tableau, Team Player, Trend Analysis, User Interface/Experience (UI/UX), Vision Plan
LOCATION
West Des Moines, IA
POSTED
7 days ago

Description

Job Summary

The Data Analyst – Revenue Cycle Management is responsible for extracting, transforming, and analyzing data from Practice Management (PM) and Electronic Health Record (EHR) systems to support operational and financial performance improvement across the revenue cycle. This role partners closely with revenue cycle leadership, clinical operations, and finance teams to deliver actionable insights that optimize billing, collections, coding accuracy, and overall revenue performance.

Key Responsibilities

  • Extract, transform, and analyze data from PM and EHR systems to support revenue cycle operations
  • Develop and maintain recurring reports, dashboards, and data models focused on key performance metrics (e.g., charge lag, denial rates, AR aging, collections, reimbursement trends)
  • Interpret data to identify performance trends, root causes of issues, and opportunities for process improvement
  • Collaborate with revenue cycle stakeholders (billing, coding, front-end, and clinical teams) to translate business needs into data requirements and analytical solutions
  • Perform deep-dive analyses on denials, payer behavior, coding patterns, and reimbursement variances
  • Support operational initiatives by measuring outcomes and tracking key performance indicators (KPIs)
  • Ensure data integrity through validation, reconciliation, and ongoing quality checks
  • Document data definitions, reporting logic, and business rules to support transparency and scalability
  • Automate reporting processes where possible to improve efficiency and reduce manual effort
  • Fulfill ad hoc reporting requests and support strategic analytical projects

Please note: This position is located onsite in West Des Moines, IA. We are not able to provide sponsorship for this role.

Qualifications

Education & Experience

  • Bachelor’s degree in Analytics, Healthcare Administration, Information Systems, Finance, or a related field
  • 2–5+ years of experience in healthcare analytics, preferably supporting revenue cycle functions

Technical Skills

  • Experience working with PM and EHR systems (e.g., Epic, Cerner, Athenahealth, eClinicalWorks, NextGen)
  • Strong SQL skills for querying and manipulating large datasets
  • Experience with BI and data visualization tools (e.g., Tableau, Power BI)
  • Advanced proficiency in Microsoft Excel (e.g., complex formulas, pivot tables, data modeling)
  • Familiarity with data warehousing concepts and healthcare data structures

Preferred Skills

  • Understanding of revenue cycle workflows, including scheduling, registration, charge capture, coding, billing, and collections
  • Knowledge of CPT, ICD-10, and payer reimbursement methodologies
  • Experience analyzing claims, denials, and accounts receivable (AR) data

Key Competencies

  • Strong analytical and problem-solving skills
  • Ability to translate complex data into clear, actionable insights
  • High attention to detail with a focus on data accuracy and quality
  • Effective communication and stakeholder collaboration skills
  • Ability to manage multiple priorities in a fast-paced environment
  • Continuous improvement mindset with a focus on operational efficiency

What’s in It for You?

  • Competitive compensation package
  • One of the best 401(k) programs in Central Iowa, including employer match and profit sharing
  • Company performance-based incentive program
  • Generous paid time off (PTO)
  • Paid holidays
  • Comprehensive health, dental, and vision insurance
  • Health and wellness program with up to $350/year in incentives

About the Company

T

The Iowa Clinic