Sr Reporting Analyst

UHS•King of Prussia, PA

8d•Hybrid

About The Position

The UHS Corporate Financial Systems Department is seeking a Senior Reporting Analyst who develops, maintains, and administers the corporate Finance, Physician Fee Schedule (PFS) and Behavioral Health Reporting Manager SQL databases, including Revenue Cycle and Accounts Receivable reports. Responsibilities include Stored procedure development and maintenance, user security, and data validation. Creates new Analytics Library reports (Cerner Invision and Millennium) and resolves user problems and errors encountered with the reporting databases via requests and tickets. Communicates with system users regarding all changes and enhancements, including data analysis and review to evaluate reported issues, and any balancing and correction efforts to verify and validate resolution. Uses technical experience and tools to develop and maintain Data Models, calculations/Formulas and creates Discovery Views for Pyramid Analytics dashboards, visualizations, and various reporting projects. Requires a thorough knowledge of the account flow throughout the revenue cycle from Patient Access through Patient Accounting functions. Supports related Patient accounting, Regional Finance (including Kodiak RCA team), IPM and Corporate Accounting teams via report development, data extraction, reconciliation, and related report automation. Manages/administers the day-to-day utilization and integrity of other financial reporting systems (Invision, Millennium Revenue Cycle, DA 2, CMOD, etc.). Also participates in ad-hoc projects, analyses, and related support tasks – i.e., for facility and corporate users, internal and external audit requests, etc.

Requirements

Bachelor's degree preferred with a minimum of 5 -8 years of thorough knowledge of healthcare operations such as Patient Financial Services, Revenue Cycle, and general accounting knowledge.
Skill set should include demonstrated written and verbal communication as well as proficiencies with Microsoft applications including Word, Excel, programming languages such as SQL and Snowflake and SAP Crystal Reports.
Experience with Cerner Invision and Millennium.
Ability to resolve user problem and errors with the reporting databases.
Comprehensive knowledge of revenue cycle from Patient Access through Patient Accounting functions.

Responsibilities

Stored procedure development and maintenance, user security, and data validation.
Creates new Analytics Library reports (Cerner Invision and Millennium) and resolves user problems and errors encountered with the reporting databases via requests and tickets.
Communicates with system users regarding all changes and enhancements, including data analysis and review to evaluate reported issues, and any balancing and correction efforts to verify and validate resolution.
Uses technical experience and tools to develop and maintain Data Models, calculations/Formulas and creates Discovery Views for Pyramid Analytics dashboards, visualizations, and various reporting projects.
Requires a thorough knowledge of the account flow throughout the revenue cycle from Patient Access through Patient Accounting functions.
Supports related Patient accounting, Regional Finance (including Kodiak RCA team), IPM and Corporate Accounting teams via report development, data extraction, reconciliation, and related report automation.
Manages/administers the day-to-day utilization and integrity of other financial reporting systems (Invision, Millennium Revenue Cycle, DA 2, CMOD, etc.).
Participates in ad-hoc projects, analyses, and related support tasks – i.e., for facility and corporate users, internal and external audit requests, etc.