Business Intelligence Analyst

The Children's Institute of Pittsburgh • Pittsburgh, PA

8h • Onsite

About The Position

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.

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

Nice To Haves

• Knowledge of performance improvement methodologies (Lean, Six Sigma) is a plus
• Experience with forecasting, capacity planning, or operational modeling is a plus

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

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

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Number of Employees: 101-250 employees