Senior Software Engineer - Epic BI Developer

Headquartered in King of Prussia, PA, Universal Health Services, Inc. (NYSE: UHS) is one of the nation’s largest and most respected providers of hospital and healthcare services. Since our founding in 1979, UHS has grown steadily into a premier Fortune 500® corporation perennially recognized by multiple esteemed national rating entities. Through its subsidiaries, UHS operates inpatient acute care facilities, inpatient behavioral health facilities, outpatient and other facilities, nationwide virtual behavioral health services, an insurance offering, a physician network and various related services with physical locations in the U.S., Puerto Rico, Ireland and United Kingdom.

The Corporate Information Services Department is seeking a dynamic and talented Sr. Software Engineer – Epic BI Developer
.

Sr. Software Engineer – Epic BI Developer designs and develops reports and dashboards utilizing Epic reporting tools such as Clarity, Cogito, Caboodle, Slicer Dicer, Radar, and business intelligence tools. Works with SSIS and the development of ETL processes in order to provide consistent, reliable, and automated delivery to the end user. Coordinates the transmission of custom reports to vendors, regulatory agencies, and other reporting applications such as power BI.

Responsible for conducting data discovery, analysis, and profiling of data to validate business requirements and provide inputs into functional design while serving as domain expert in Clinical and/or Revenue Cycle business area. Works closely with EMR and Revenue Cycle Analysts to understand operational workflows and data structure. Identifies and manages data quality or integrity issues within the domain and collaborate with business units to design the structure of data solutions, as well as plan their implementation within the team.

Troubleshoots and fixes data loads and other issues within Epic and data warehouse and explore new ways to present data insights to end users within a project. Responsible for managing large scale solution commitments to business stakeholders and help develop and maintain the structure of the reporting environment. Fosters informed growth by providing users with the ability to rapidly obtain the data they need.

Performs SQL queries and script writing. Works on data flows from source systems to one central EDW platform and creates data models using Integration Services. Utilizes strong skills to create Epic and Tableau dashboards/reports to communicate business metrics, as well as assisting business users with creating their own reports.
Works closely with the Clinical and/or Revenue Cycle teams throughout project life-cycles, ensuring that high-quality, timely and relevant data is available to decision makers across the organization.

• Designs, develops, implements, and maintains data models to be used by various reporting and data discovery tools. Performance and accuracy are key.
• Follows established SDLC, change control, release management and incident management processes while developing and deploying standard reports and dashboards.
• Utilizes established BI data models in order to drive reporting standards, re-use, quality and reporting simplification. Suggests improvements to the data model where applicable.
• Works collaboratively with the team manager and architects of the team and Project Managers to perform required project tasks with minimal supervision.
• Completes change requests for new reports and enhancements in a timely manner with high quality.
• Serves as Technical Lead for medium to large sized projects. Provides guidance to less experienced staff.

• Ensures that data is available to…