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.