Revenue Cycle Data Analyst

Mercy Cedar Rapids - Cedar Rapids, IA

Full-time - Entry Level

Cedar Rapids, IA

About the position

This position at Mercy Medical Center supports the organization's philosophy of patient-centered care by focusing on the analysis of data trends, ensuring data integrity, preparing reports, and creating visual dashboards for both internal and external stakeholders. The Revenue Cycle Data Analyst plays a crucial role in the financial analysis of the revenue cycle, working closely with the Director of the Revenue Cycle to develop and maintain standards that measure the effectiveness of all aspects of the revenue cycle. This role requires a strong analytical mindset and the ability to communicate findings effectively to various stakeholders. The analyst will be responsible for developing and maintaining statistical data for monthly and daily reports, including denial reports and late charge reports. They will provide feedback to affiliates regarding issues identified during the analysis of processes and assist them in implementing best practices throughout the revenue cycle. Collaboration is key in this role, as the analyst will work in a group setting to share insights and ideas regarding reporting, while also maintaining professional relationships with the general public, affiliate executives, staff, and physicians. In addition to operational responsibilities, the analyst will oversee compliance initiatives within the revenue cycle, ensuring adherence to federal, state, and local regulations. This includes leading the research, planning, implementation, monitoring, validation, and reporting for a broad portfolio of compliance systems and initiatives. The analyst will analyze all revenue cycle functions to identify trends and provide insights for decision-making, while also maintaining data integrity through collaboration with administrators and providers. The role requires the creation of visually engaging dashboards using tools like Tableau and Epic, as well as the extraction, transformation, and loading of data from relational databases. Overall, this position is integral to supporting the financial health of Mercy Medical Center and contributing to a positive workplace culture through professionalism and teamwork.

Responsibilities

• Develop and maintain Revenue Cycle/Financial Analysis and communicate to Director of the Revenue Cycle.
• Assist the Director in developing and maintaining standards to measure the effectiveness of all aspects of the revenue cycle.
• Develop and maintain statistical data for monthly and/or daily reports (denial reports, late charge reports, etc.).
• Provide feedback to the affiliates regarding issues found during analysis of processes.
• Assist affiliates with Best Practices throughout the Revenue Cycle.
• Work in a group setting sharing thoughts and ideas regarding reporting.
• Maintain a professional relationship with the general public, affiliate executives and staff, and physicians on all matters which relate to Mercy Medical Center.
• Work with affiliate departmental staff to ensure standardization and compliance.
• Operate department equipment and systems.
• Adhere to all MMC Personnel policies and procedures, departmental policies, and safety guidelines.
• Operate Slicer/Dicer functionality within EPIC and other analytical tools to identify process change needs, etc.
• Responsible for the Revenue Cycle compliance initiatives both within the compliance function as well as functions across the enterprise.
• Lead and direct the researching, planning, implementation, and monitoring, validation, and reporting for a broad portfolio of Revenue Cycle compliance systems and initiatives.
• Oversee the researching and interpretation of regulations and laws to establish Revenue Cycle compliance standards.
• Analyze all Revenue Cycle functions to identify trends, provide communication to the managers.
• Analyze data trends and provide insights for decision-making.
• Maintain data integrity by collaborating with administrators/providers.
• Prepare reports and streamline existing ones for accessibility.
• Create visually engaging dashboards using Tableau, Epic and other tools.
• Extract, transform, and load data from relational databases.
• Collaborate with stakeholders to understand data needs and requirements.
• Ensure accurate and timely reporting to meet organizational goals.
• Contribute to a positive workplace culture through professionalism and teamwork.
• Support survey research and data collection efforts, if required.

Requirements

• One year of experience in healthcare or administration.
• Proficiency in Microsoft Office Suite (Excel, Outlook, PowerPoint, etc.) and Tableau.
• Excellent communication skills and a track record of managing detailed information accurately.
• Ability to work with minimal to no supervision.
• Excellent interpersonal skills and customer service skills.

Nice-to-haves

• Knowledge of Iowa healthcare systems, healthcare insurers, and organizations.
• Experience using Tableau Prep for cleaning, validating, and analyzing data prior to visualization.
• Experience with survey research and data collection accompanied by excellent analytical and problem-solving skills.

Benefits

• Health insurance coverage
• Dental insurance coverage
• 401k retirement savings plan
• Paid time off (PTO)
• Professional development opportunities