Data Analyst - Hybrid

Summit School Services companies share a strong commitment to provide the highest level of transportation safety, quality transportation, outstanding customer service and positive employee relations. Our corporate headquarters, located in Warrenville, Illinois, houses the administrative and corporate support functions for the organization. Our 250+ local customer service centers (CSCs) are supported by regional operations teams located throughout North America.

Summit School Services is seeking a Data Analyst to design, build, and deliver impactful Power BI reports and dashboards that support decision-making throughout the organization. This role requires strong analytical thinking, attention to detail, and problem-solving skills to help drive business performance, enhance quality, and optimize operational processes.

Reporting & Analytics Development

• Partner with stakeholders to gather requirements for reports, metrics and dashboards

• Develop a deep understanding of business operations and data usage

• Provide guidance on data management standards and best practices

• Serve as a subject matter expert for data engineering teams and technology partners

• Design, build, and maintain Power BI reports and dashboards tailored to multiple audiences

• Identify trends and perform root cause analysis

• Ensure reports are intuitive, visually clear, and actionable for non-technical users

Data Analysis & Storytelling

• Analyze large and complex datasets to identify trends, risks, and opportunities

• Translate analysis into clear insights and narratives that drive understanding and action

• Provide context, commentary, and recommendations alongside dashboards and reports

• Present findings to stakeholders with varying levels of technical and operational expertise

Stakeholder Management

• Build collaborative relationships with business stakeholders

• Define functional requirements and gather feedback to improve data products

• Advance enterprise reporting through product-thinking, including roadmaps and backlog management

• Identify opportunities for improvement and cost savings

Team Collaboration

• Serve as a subject matter expert for Data Engineers & reporting teams

• Manage vendors and cross functional work to achieve outcomes

• Develop materials for leadership presentations

Analytics & Core Responsibilities

• Produce weekly and monthly KPI reports using Excel and Power BI

• Develop SQL queries for recurring and ad-hoc reports

• Identify trends, gaps and improvements in operational performance

• Optimize statistical calculations for better business metrics

• Engage in new analytical projects and exploratory data capturing

• Identify and resolve issues in established reports