Job Description

Job Title: Bus. Intelligence Analyst
Job ID: 733052
Status: Full-Time
Regular/Temporary: Regular
Shift: Day Job
Facility: H.C. Pharmacy Central, Inc.
Department: Pharmacy
Location: 3175 East Carson Street, Pittsburgh PA 15203



The Business Intelligence (BI) Analyst develops and supports solutions that turn data into actionable information, enabling data driven decisions for Pensiamo and its clients. The BI Analyst will be tasked with participating in and assisting senior team members with a broad spectrum of BI activities: cultivating new data integrations across clients, normalizing data between disparate data sources, creating recurring and ad-hoc reports and developing data visualizations that simplify complex data sets and analyses.


  • Create and deliver user training on tools and reports
  • Develop and maintain robust documentation of data sources, integrations and reports
  • Develop, execute and maintain test scripts to validate report accuracy and expected results
  • Liaise with clients and 3rd parties to identify new data sources and understand changes to existing data sources
  • Maintain knowledge of industry standards and best practices and keeping current with industry trends and emerging technologies
  • Participate in and assist senior team members with efforts to maintain, validate and update data within the data warehouse to ensure data integrity
  • Participate in and assist senior team members with new reports and analytics lifecycles from concept-to-production
  • Participate in and assist senior team members with the development of BI integrations between ERP, clinical and 3rd party systems and the data warehouse


  • B.S. degree in Information Technology, Business or equivalent Minimum 3 years experience in a Business Intelligence related role
  • Experience with data integration and ETL tools
  • Experience with data modeling and analysis for data warehousing, big data and data analytics
  • Experience collaborating with business stakeholders to develop business requirements and functional specification documents
  • Understanding and knowledge of data architecture and data flows within systems
  • Proficiency with systems, database administration, and scripting

Salary Range: $26.64 to $44.88 / hour

Union Position: No

Apply Current Employee?


At UPMC, our shared goal is to create a cohesive, positive, experience for our employees, patients, health plan members, and community. If you too are driven by these values, you may be a great fit at UPMC!


UPMC provides a total rewards package that can help you achieve the goals you have for your career and your personal life. Whether you want to learn a new skill through a training course, reach personal health and wellness targets, become more involved in your community, or follow a career path that provides you with the right experience to be successful, UPMC can help you get to where you want to be.


Now more than ever, YOU can help us shape our communities and UPMC into a better place for everyone to work, study, play, and thrive.

Learn more about working here and check out our policies and recent updates.

UPMC Ranked #17 Best Places for Women & Diverse Managers in 2018

Talent Network