Intermediate BI Developer

UPMC; Pittsburgh (Allegheny County); Hybrid; USD 65,000 - 90,000; Full time

Job summary

UPMC is seeking an Intermediate BI Developer to turn data into actionable information, creating and maintaining reports and dashboards. The role focuses on developing enterprise BI capabilities, analytics, and visualizations, with a path toward more advanced BI work.

This hybrid position requires on-site presence one week per month and during as-needed periods, with day-to-day work during standard business hours. Strong SQL, SSIS, and Epic Cogito experience are highly valued.

Qualifications

• Bachelor's degree preferred in computer science, mathematics, HIM, analytics, statistics, or equivalent BI coursework
• 3 years BI work experience or relevant course work preferred
• Experience with BI tools such as Power BI, Qlik, or Tableau preferred
• Experience with report writing tools such as SSRS, Business Objects, Cognos, etc. preferred
• Strong communication, interpersonal, and presentation skills
• Understanding of data governance, data quality, and data management best practices

Responsibilities

• Work with stakeholders to translate reporting requirements into technical requirements and interactive reports
• Create and maintain technical documentation for BI solutions
• Troubleshoot BI solutions to ensure accuracy and smooth operations
• Assist with dashboard design and understanding data models to convert raw data into insights
• Create and maintain BI solutions (data marts, dashboards, views) and monitor performance and process improvements
• Manage tasks and timelines related to assigned work

Skills

SQL

SSIS

Epic Cogito

Education

Bachelor's degree in CS/Math/HIM/Analytics

Tools

Power BI

Qlik

Tableau

SSRS

Business Objects

Cognos

Job description

UPMC is hiring an Intermediate BI Developer. This opportunity offers work life balance, an excellent total rewards package, and room for career growth. If you have SQL, SSIS, and Epic Cogito experience

Work Location:

Hybrid- required to be on-site one week out of the month and as required.

Work Hours:

Daylight Standard Business Hours

Purpose:

The Intermediate BI Developer develops and supports solutions that turn data into actionable information, enabling data driven decisions for UPMC. The Intermediate BI Developer creates and maintains reports and dashboards, moving data output from existing static content to interactive visualizations. The Intermediate BI Developer performs analytics within business intelligence tools. This entry level role will focus on the design, development, implementation and maintenance of enterprise BI and reporting platforms.

Responsibilities:

• Work closely with business stakeholders to understand reporting and analytics requirements and translate them into technical requirements, visualization and interactive reports.
• Create and maintain technical documentation. Document BI solutions, including data models, ETL processes, technical specifications, and end-user documentation.
• Troubleshoot and debug BI solutions to ensure smooth operations and accurate data.
• Assist with Dashboard design and architecture and understanding data models to convert raw data to meaningful insights. Make recommendations based on needs / wants.
• Create and maintain and support all BI solutions (i.e. Data marts, dashboards and views) performance monitoring, measurement, forecast, and ongoing process improvement.
• Manage tasks and timelines related to assigned work.
• Preferred bachelor's degree typically in computer science, mathematics, HIM, analytics, statistics, or relevant associated course work or 3 years equivalent BI work experience
• Preferred: Experience with BI tools such as Microsoft Power BI, Qlik, or Tableau.
• Preferred: Experience with report writing tools such as Microsoft SSRS, Business Objects, Cognos, etc.
• Strong communication, interpersonal, and presentation skills.
• Strong analytical and problem-solving skills.
• Understanding of data governance, data quality, and data management best practices.
• Ability to plan and manage simultaneous tasks and projects.
• High degree of professionalism, enthusiasm, and initiative.
• Ability to work in a fast-paced, team environment is a must.
• Experience working with minimal direction and the keen ability to leverage business sense to guide decision making next slide healthcare experience preferred but not required.
• Strong attention to detail.
• Ability to manage multiple tasks and projects, strong interpersonal relationships, excellent planning, communication, documentation, and analytical and problem-solving abilities.
• Preferred knowledge of clinical workflow in hospital, ambulatory and post-acute environments.
• Work with leadership on new project initiatives.

Top 3 Skills Needed:

• SQL
• SSIS
• Epic Cogito

Preferred:

• Current or past UPMC employee or contractor

Licensure, Certifications, and Clearances:

Act 34

UPMC is an Equal Opportunity Employer/Disability/Veteran