Business Intelligence Analyst

Children's Institute Inc.
Pittsburgh, United States of America
4 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Intermediate

Job location

Pittsburgh, United States of America

Tech stack

Microsoft Excel
Relational Databases
Database Queries
Operational Data Store
Pivot Tables
Power BI
Tableau
Advanced Reports
Data Analytics
Looker Analytics

Job description

The Business Intelligence Analyst plays a critical role in transforming data into actionable insights that drive operational excellence. This role focuses on analyzing service line performance, identifying trends and opportunities, and developing meaningful key performance indicators (KPIs) to support strategic and operational decision-making. Responsibilities

  • Partner with operational leaders to understand workflows, business objectives, and challenges
  • Analyze operational data across multiple service lines to evaluate performance, efficiency, and utilization
  • Identify trends, limitations, and opportunities for improvement within service delivery models as well as the broader organization
  • Design, develop, and maintain KPIs that align with organizational goals and service line strategies
  • Establish standardized performance metrics and reporting frameworks
  • Monitor KPI performance and provide actionable recommendations based on findings
  • Ensure data accuracy, consistency, and governance across all reporting processes
  • Develop dashboards and reports using BI tools (e.g., Power BI, Tableau, or similar tools)
  • Design clear, intuitive visualizations to enable translation of complex data for stakeholders at all levels
  • Automate reporting processes to improve efficiency and scalability

Requirements

  • 2-5+ years of experience in business intelligence, data analytics, or a related role
  • Experience analyzing service line operations (healthcare or similar operational environments preferred)
  • Proficiency in BI tools (Power BI, Tableau, Looker, etc.)
  • Strong SQL skills and experience working with relational databases
  • Advanced Excel skills (pivot tables, formulas, data modeling)
  • Knowledge of performance improvement methodologies (Lean, Six Sigma) is a plus
  • Experience with forecasting, capacity planning, or operational modeling is a plus
  • Bachelor's degree in Data Analytics, Business, Finance, Healthcare Administration, or related field.
  • Clearances Required: Act 73 FBI, Act 34 Criminal Clearance, and Act 33 Child Abuse Clearance

Benefits & conditions

We're proud to offer generous benefits to our team members. Regular full-time team members are eligible for the following benefits:

  • Medical and Prescription insurance-Choice of two health plans and networks
  • Dental and Vision-Free coverage for team members.
  • Paid Time Off (PTO) and Holidays
  • Medical, Bereavement, Educational, & Personal Leaves
  • Parental leave (birth & adoption) paid-6 weeks
  • 403b Retirement Plan - pre-tax & Roth options; employer match after 1 year
  • Student Loan Refinancing Program
  • Public Service Loan Forgiveness Program - CI qualifies as non-profit
  • Education Assistance/Tuition Reimbursement
  • Professional Development/CEU's
  • Life and Short- & Long-Term Disability insurance
  • Credit Union
  • Team Member Recognition Events
  • Referral bonus
  • CPR-employer paid
  • Travel mileage reimbursement at federal rate

Are you looking for a position where you can make a lasting impact in the lives of children and their families? Are you ready to brighten the future of Amazing Children? We want to hear from you! The Children's Institute of Pittsburgh is an Equal Opportunity Employer. We serve a diverse population of children and families, and we want our workforce to reflect that same diversity. We want all interested individuals to feel welcome in applying for a career at our amazing place - we can't wait to meet you!

Apply for this position