Business Intelligence Analyst

At The Children’s Institute of Pittsburgh, we’ve built our legacy on being amazing. After more than a century of the highest quality care and service to children and their families, we’re forever proud of our team members who don’t just make a career here – they make a difference.

Job Title: Business Intelligence Analyst

Location: The Children's Institute Squirrel Hill Campus, 1405 Shady Avenue, Pittsburgh, PA 15217

Schedule: Monday – Friday, Full Time, Onsite

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

• 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

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

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!