What are the responsibilities and job description for the Data Analyst-Revenue Cycle Management (Full-Time) position at The Iowa Clinic?
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
Qualifications
Education & Experience
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
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
- 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
- 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
- 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
- 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