Software Engineer II - Data Engineering

Universal Hospital Services Inc.; King of Prussia (PA); On-site; USD 90,000 - 130,000; Full time

Benefits offered by this job

Growth and development opportunities

Competitive Compensation

Excellent Medical, Dental, Vision and

401k plan with company match

Generous Paid Time Off

Job summary

Universal Health Services, Inc. (UHS) is seeking a Software Engineer II – Business Intelligence Developer to design and develop analytics assets on the enterprise data warehouse. The role focuses on data discovery, profiling, and delivering reliable data models and dashboards for Clinical and/or Revenue Cycle domains.

Responsibilities include data modeling, ETL, and collaboration with clinical and revenue teams to ensure timely, high-quality data for decision makers.

Qualifications

• Bachelor’s degree in Information Technology, Computer Science or related field.
• 3+ years of SQL programming and working with relational databases.
• 3+ years of experience developing solutions with BI tools and data models.
• Experience with Python or other object-oriented programming language.
• 3+ years of related managed healthcare or insurance operations experience preferred.

Responsibilities

• Designs, develops, implements, and maintains data models for reporting and analytics.
• Develops dashboards and reports using enterprise BI tools.
• Follows SDLC, change control, and release management processes.
• Ensures data quality and supports data loading in the data warehouse.
• Provides technical guidance to ad-hoc report developers and stakeholders.
• Acts as Technical Lead for small to medium projects.

Skills

SQL programming

Python

Data modeling

ETL concepts

Relational databases

Communication skills

Education

Bachelor’s degree in Information Technology or Computer Science

Tools

SQL Server

Oracle Analytics Cloud

Snowflake

SSIS

Apache Airflow

Spark

Job description

Responsibilities

One of the nation’s largest and most respected providers of hospital and healthcare services, Universal Health Services, Inc. (UHS) has built an impressive record of achievement and performance. Growing steadily since itsinceptioninto an esteemed Fortune 500®corporation, annualrevenuesduring2025were$17.4billion.In 2026,UHS was again recognized as one of Fortune World’s Most Admired Companies™ and in 2025, waslisted in Forbes ranking of America’s Largest Public Companies.

Headquarteredin King of Prussia, PA, UHS has approximately101,500employeesand continues to grow through its subsidiaries. Operating acute care hospitals, behavioral health facilities, outpatient facilities and ambulatory care access points, an insurance offering, a physiciannetworkand various related serviceslocatedin 40U.S.states, Washington, D.C., PuertoRicoand the United Kingdom.Foradditionalinformationvisitwww.uhs.com.

The Corporate Information Services Department is seeking a dynamic and talented Software Engineer II – Business Intelligence Developer.

The Software Engineer II – Business Intelligence Developer ddesigns and develops analytics assets utilizing the enterprise data warehouse and business intelligence tools to provide consistent, reliable, and automated delivery to the end user. Conducts 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. Identifies and manages data quality or integrity issues within the domain and collaborates 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 a data warehouse and explores new ways to present data insights to end users within a project. Manages small scale solution commitments to business stakeholders and participates in developing and maintaining the structure of the reporting environment.

Provides users with the ability to rapidly obtain the data that they need. Works on data flows from source systems to one central EDW platform and creates data models using data orchestration tools like Integration Services, Apache Airflow, and Spark.

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. Focuses on Clinical and/or Revenue Cycle.

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 is 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 to drive reporting standards, re-use, quality and reporting simplification. Suggests improvements to the data model where applicable.
• Works collaboratively with the senior members 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 to effectively accomplish desired objectives.
• Serves as Technical Lead for small to medium sized projects.

Solution Maintenance and Support:

• Ensure that data is available to decision makers through the created reports and dashboards, as well as self-service methods.
• Provides outstanding customer service to both internal and external customers.
• Provides technical guidance to business ad-hoc report developers on appropriate usage of 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.
• Participates in user group forums and knowledge transfer sessions.
• Monitors the resolution of maintenance or enhancement issues assigned by the UHS Customer Support Center.

Qualifications

Position Requirements:

Knowledge:

• Bachelor’s degree in Information Technology, Computer Science or related field of study.
• 3+ years of SQL programming and working with relational databases. Experience including:
• Stored procedure development to support analytics and data warehouse initiatives
• Database design and administration
• Performance tuning (SQL code and database architecture)
• 3+ years of experience developing solutions with BI tools and data models. (Business Objects, SQL Server, Oracle Analytics Cloud, Snowflake, Parquet)
• Experience with Python or other object-oriented programming language is required.
• 3+ years of related managed healthcare or insurance operations experience preferred.

Skills:

• Expertise with relational database concepts, data warehousing and ETL concepts.
• 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 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.*

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.

We believe that diversity and inclusion among our teammates is critical to our success.