Sr Rev Cycle BI Analyst

Overview:

Kettering Health is a not-for-profit system of 13 medical centers and more than 120 outpatient facilities serving southwest Ohio. We are committed to transforming the health care experience with high-quality care for every stage of life. Our service-oriented mission is in action every day, whether its by providing care in our facilities, training the next generation of health care professionals, or serving others through international outreach.

Kettering Health Miamisburg

• Serving the residents of Warren, Butler, and Southern Montgomery counties for over 40 years.
• Kettering Health Miamisburg, formerly Sycamore Medical Center, is a full-service hospital located minutes west of the Dayton Mall on Miamisburg-Centerville Road off I-75 in Miamisburg, Ohio.
• The cornerstone services for KH Miamisburg have been Bariatric surgeries and Orthopedic care.
• Expanded services include emergency care, sleep center, mammography, breast MRI, cardiac catheterization lab, wound center and DEXA scanning.
• 142 bed facility
• Awarded with 100 Top Hospital by IBM Watson Health for the 10th time in 2019.
• In 2020, KH Miamisburg received an A from the Leapfrog Group, a national patient safety watchdog, ranking among the safest hospitals in the United States.
• Accredited by the American College of Emergency Physicians as a Level 3 Geriatric Emergency Department.
• KH Miamisburg received several awards from Healthgrades:
  • Outstanding Patient Experience Award (2017-2019)
  • Americas 100 Best Hospitals for Prostate Surgery Award (2020)
  • Joint Replacement Excellence Award (2020)

Job Summary:
The Sr Reporting Analyst, reporting to the Manager or Director of Revenue Cycle Administration, will be responsible for data analytics and additional support of performance measures, ongoing measurement, data collection, reporting, data visualizations, and information dissemination. S/He will analyze data (e.g. clinical, financial, etc.), provide insight on trends, and recommend solutions to resolve technical problems and/or enhance and improve processes and/or functionality of an application. S/He will also be responsible for developing and maintaining reporting and dashboards using governed definition to help leaders make evidence-based decisions and creative pathways forward. Performs other duties as assigned.

Skills:

Knowledge of the Revenue Cycle operations (e.g. Patient Access / Registration, Coding, Patient Financial Services, etc.)
Microsoft Office Suite (intermediate or advanced knowledge of Excel)
Experience developing reports in various formats and platforms (e.g. Power BI) and/or writing SQL and queries
Strong communication, both oral and written
Critical thinking and problem solving/analytic mindset
Detail oriented and able to work both independently and as a team

Essential Functions:

Reporting and Analytics
Develops complex Epic reports and maintains a comprehensive understanding of database relationships within Epic, data warehouse, and/or other IS applications.
Develops, maintains, and produces monthly, quarterly, annual reports or adhoc analyses and financial models and provides insights on trends and/or anomalies to support financial decisions and strategic business cases.
Gathers, analyzes, and summarizes information using established standards to generate and evaluate potential solutions to opportunities, issues, and challenges while weighing the accuracy and relevance of available data and information.
Intakes and prioritizes data requests and determines if existing reports fulfills the request or builds/modifies reports then conducts end-user validation to ensure output meets requestors specifications. Escalates issues as appropriate in order to make and implement necessary corrections/changes as approved by relevant stakeholders. Collaborates with relevant stakeholders, both internal and external, when deploying reports using the agreed upon data platform (e.g. email, sFTP, etc.) and in the agreed upon schedule.
Monitors and evaluates usage and performance of certain reports and recommends changes to address identified issues or address report efficiency.

Operational
Assists Revenue Cycle leaders in the preparation of the annual budget and forecasting updates as needed.
Works with Revenue Cycle leaders on a variety of projects to identify and execute continuous improvement efforts to drive savings in process and operational execution. Develops, maintains, and trains on departmental resources (e.g. policies, procedures, work instructions, other training materials) necessary for the department to run sufficiently and efficiently.
Meets with leaders to review monthly departmental expenses and provide variance explanations.
Assists in timely and accurate invoice reconciliation and payments by reviewing vendor contracts for financial terms, performance metrics, etc.

Job Requirements:
Bachelors Degree in Finance, Business Administration, Healthcare Administration, Information Technology, or related field.

Licenses, Certifications and Registrations

List requirements set by the regulatory or governing body of this jobs discipline
Include whether this job requires Resuscitation certification:
?BLS
?ACLS
?ALS
?PALS
?NRP
SQL, VBA, Power BI, or similar Certification preferred
Epic Certification preferre

Work Experience:

5+ years of experience in financial management, preferably in healthcare setting.

5+ years of experience in developing reports, dashboards, etc., preferably in healthcare setting