Senior Software Engineer - Epic BI Developer

UHS of Delaware, Inc. - Corporate Office; King of Prussia (PA); On-site; USD 110,000 - 160,000; Full time

Job summary

Universal Health Services, Inc. is seeking a Sr. Software Engineer – Epic BI Developer to design, develop, and maintain data models and dashboards using Epic tools (Clarity, Cogito, Caboodle, Slicer Dicer) and BI platforms such as Tableau and Power BI.

You will run SQL queries, build ETL processes with SSIS, and provide data-driven insights to clinical and revenue cycle teams. You will collaborate with EMR and Revenue Cycle Analysts to understand workflows, ensure data quality, and deliver

Qualifications

• Bachelor's degree in IT/CS or related field.
• Epic certification/accreditation in Cogito and Clarity Data Model.
• 5+ years SQL programming with relational databases (procedures, design, admin).
• 5+ years BI tools and data models experience (BO, SAP Webi, SQL Server, Oracle).
• 5+ years Epic Clarity, Caboodle, Cogito reporting tools (Workbench, Radar, Slicer Dicer).
• 5+ years healthcare or insurance operations experience preferred.
• Python or OO language experience preferred.

Responsibilities

• Design, develop, and maintain data models for reporting and discovery tools.
• Follow SDLC, change control, release, and incident management.
• Leverage BI data models to drive reporting standards and quality.
• Collaborate with team manager, architects, and project managers.
• Handle change requests for reports and enhancements with high quality.
• Serve as Technical Lead for medium to large projects and mentor staff.
• Create Epic and Tableau dashboards to communicate key metrics.

Skills

SQL programming

Data modeling

BI reporting

ETL processes

Data analysis

Data quality

Technical leadership

Stakeholder communication

Education

Bachelor’s degree in IT/CS/Data Analytics

Tools

Epic Clarity

Epic Cogito

Epic Caboodle

Epic Slicer Dicer

Radar

Tableau

SSIS

Power BI

SQL Server

Oracle

Job description

Responsibilities

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. www.uhs.com

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.

Key responsibilities include:

Solution Development and Design

• 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.

Solution Maintenance and Support

• Ensures that data is available to decision makers through the created reports and dashboards, as well as self-service methods.


• Interfaces with the user community regarding data model design and support. Treats every person requesting services from the team as a valued customer, both internal and external.


• Provides technical guidance to business ad-hoc report developers on appropriate usage of the data models and BI tools.


• Stays current with the needs and operations of the enterprise; provides recommendations on the availability of existing reports and suggests opportunities to improve reporting solutions.


• Remains technically fluent with new and existing BI tools, process and development techniques.


• Provides support as needed for software installations and upgrades.


• Monitors the resolution of maintenance or enhancement issues assigned by the UHS Customer Support Center.


• Participates in user group forums and knowledge transfer sessions.

Administration and Oversight

• Provides technical support, assistance and guidance to other team members as required.


• Keeps management well informed of activities, needs, problems.


• Tracks on-going work items using work management tools.

Qualifications

Position Requirements

• Bachelor’s degree required. Degree in Information Technology, Computer Science, Data Analytics or related field of study preferred.


• Epic certification or Accreditation required in Cogito and Clarity Data Model


• 5+ years of SQL programming and working with relational database experience including:




• Stored procedure development to support reporting or data warehouse initiatives


• Database design and administrationPerformance tuning (SQL code and database architecture)




• 5+ years of experience developing solutions with BI tools and data models. (Business Objects, SAP Webi, SQL Server, Oracle,)


• 5 + years of experience with Epic Clarity, Caboodle, and Cogito suite of reporting tools including Reporting Workbench, Radar, or Slicer Dicer


• 5+ years of related managed healthcare or insurance operations experience preferred.


• Experience with Python or other object-oriented programming language preferred.

Skills

• Expertise with relational database concepts, data warehousing and ETL concepts.


• Focus on Clinical and/or Revenue Cycle


• Displays an eagerness to continually improve skills and learn new technologies.


• Comfortable with an environment where priorities change frequently.


• Ability to work and deliver strong results in a dynamic team environment.


• Ability to work in a fast moving company and industry.


• Ability to work mostly unsupervised. Proven communication and collaboration skills; willingness to take initiative to contribute beyond basic responsibilities.


• Excellent customer service, verbal and written communication skills.

Travel Requirements: 5% US or International travel

This opportunity provides the following:

• Challenging and rewarding work environment


• Growth and development opportunities within UHS and its subsidiaries


• Competitive Compensation


• Excellent Medical, Dental, Vision and Prescription Drug Plan


• 401k plan with company match


• Generous Paid Time Off

*UHS is a registered trademark of UHS of Delaware, Inc., the management company for Universal Health Services, Inc. and a wholly-owned subsidiary of Universal Health Services, Inc. Universal Health Services, Inc. is a holding company and operates through its subsidiaries including its management company, UHS of Delaware, Inc. All healthcare and management operations are conducted by subsidiaries of Universal Health Services, Inc. To the extent any reference to \"UHS or UHS facilities\" on this website including any statements, articles or other publications contained herein relates to our healthcare or management operations it is referring to Universal Health Services' subsidiaries including UHS of Delaware. Further, the terms \"we,\" \"us,\" \"our\" or \"the company\" in such context similarly refer to the operations of Universal Health Services' subsidiaries including UHS of Delaware. Any employment referenced in this website is not with Universal Health Services, Inc. but solely with one of its subsidiaries including but not limited to UHS of Delaware, Inc.

UHS is not accepting unsolicited assistance from search firms for this employment opportunity. Please, no phone calls or emails. All resumes submitted by search firms to any employee at UHS via-email, the Internet or in any form and/or method without a valid written search agreement in place for this position will be deemed the sole property of UHS. No fee will be paid in the event the candidate is hired by UHS as a result of the referral or through other means.

EEO Statement

All UHS subsidiaries are committed to providing an environment of mutual respect where equal employment opportunities are available to all applicants and teammates. UHS subsidiaries are equal opportunity employers and as such, openly support and fully commit to recruitment, selection, placement, promotion and compensation of individuals without regard to race, color, religion, age, sex (including pregnancy, gender identity, and sexual orientation), genetic information, national origin, disability status, protected veteran status or any other characteristic protected by federal, state or local laws.

Avoid and Report Recruitment Scams

We are aware of a scam whereby imposters are posing as Recruiters from UHS, and our subsidiary hospitals and facilities. Beware of anyone requesting financial or personal information.

At UHS and all our subsidiaries, our Human Resources departments and recruiters are here to help prospective candidates by matching skill set and experience with the best possible career path at UHS and our subsidiaries. During the recruitment process, no recruiter or employee will request financial or personal information (e.g., Social Security Number, credit card or bank information, etc.) from you via email. Our recruiters will not email you from a public webmail client like Hotmail, Gmail, Yahoo Mail, etc.

If you suspect a fraudulent job posting or job-related email mentioning UHS or its subsidiaries, we encourage you to report such concerns to appropriate law enforcement. We encourage you to refer to legitimate UHS and UHS subsidiary career websites to verify job opportunities and not rely on unsolicited calls from recruiters.