Application Analyst I - Supply Chain Reporting (SQL)

UHS • King of Prussia, PA

156d

About The Position

Universal Health Services, Inc. (NYSE: UHS) is one of the nation’s largest and most respected providers of hospital and healthcare services. The Corporate Supply Chain Department is seeking a dynamic and talented Application Analyst I – Supply Chain Systems. This entry-level position is responsible for supporting and maintaining the reporting applications SQL database, ERP, etc. The analyst will gather reporting & data requirements from end-users, create accurate reports, and provide support to daily IT operations. The role requires strong data analytical skills, an IT mindset, and problem-solving abilities.

Requirements

• Associate’s degree required, Bachelor’s degree preferred.
• One or more years of SQL/Reporting/Data Analytics experience in Information Services.
• Understanding of SQL, reporting dashboard development, Microsoft tools like Excel, data analysis, etc.
• Familiarity with data governance and data quality initiatives.
• Introduction to database management, project management, report validation methods, and data warehouses.
• Some knowledge of ERP Supply Chain applications.
• Knowledge of system application implementation, enhancement, and support methods and practices.
• Knowledge of computer systems analysis, techniques, and procedures.
• Developing skills in working with users to determine software or system application functionality.
• Understanding of SC-IT standards and quality methods and metrics.
• General familiarity with business requirements gathering process to generate reports.

Nice To Haves

• Proficiency in SQL, Excel, and reporting tools (e.g., Power BI, Tableau) is preferred.
• Excellent written and verbal communication skills.

Responsibilities

• Regularly meets with supervisor and team to discuss, develop/modify reporting requirements based on end-user/customer needs.
• Monitors and resolves daily IT tickets related to supply chain systems as needed.
• Ensures data extraction/load accuracy, consistency, and timely delivery of reports.
• Writes SQL queries to retrieve data and fine-tune them based on customer needs.
• Provides assistance with training to UHS staff on reporting applications.
• Interacts with Leadership on implementation of new enhancements on ERP/reporting applications.
• Coordinates development of test data, system testing, and documentation for all phases of the application development life cycle.
• Troubleshoots application issues and coordinates with technical teams for resolution.
• Leads assigned data cleansing projects across supply chain systems.
• Ensures strict adherence to work plans, reporting all serious deviations to Supervisor.
• Provides support to Supply Chain IS team in major application upgrade projects.
• Adheres to UHS Service Level and Change Management Policies.
• Provides on-call/weekend support as needed for any patch/upgrade testing.
• Establishes and maintains regular communications with user community.
• Assists management with training analysts in the performance of their duties.
• Documents recurring issues and recommends process improvements.
• Prepares and promptly submits all routine and special reports.
• Creates and maintains user guides and documentation for reporting processes.

Benefits

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

What This Job Offers

• Job Type: Full-time
• Career Level: Entry Level
• Education Level: Associate degree
• Number of Employees: 1,001-5,000 employees