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

Required Qualifications

• Bachelor’s degree in Data Analytics, Statistics, Business, Computer Science, or a related field (or equivalent experience)

• 2 – 5 years of analytics experience

• Experience in Power BI reports and dashboards (DAX, Data modeling, performance optimization) and Azure

• Strong analytical, problem-solving and Microsoft Office Skills

• Proficiency in SQL, Python and data querying

• Strong analytical skills with the ability to interpret and synthesize data

• Proven ability to communicate insights and tell a story with data

• Experience working with operational or performance-based KPIs

• Ability to work independently while managing multiple priorities

   

Preferred Qualifications

• Experience in transportation, logistics, operations, or field-based services

• Experience in Microsoft Fabric

• Experience with predictive analytics, forecasting, or trend modeling

   

Skills

• BI Tools (Power BI) SQL, Excel, Python, PySparks

• Predictive analytics, decision trees, optimization

• Database design and data visualization tools

Summit School Services has a zero-tolerance policy on conduct that is incompatible with its policies and values, including sexual exploitation and abuse, harassment, abuse of authority, and discrimination. Summit School Services is committed to promoting the protection and safeguarding of all children and passengers.

We offer medical, dental, vision, basic life insurance coverage, holiday pay, and PTO accrual. Additionally, employees are able to enroll in a retirement savings plan.

At Summit School Services our goal is to be a diverse workforce that is representative of the communities we serve. All employment decisions are based on business needs, job requirements and individual qualifications, without regard to race, color, religion, sex, pregnancy (including childbirth, lactation and related medical conditions), national origin, age, physical and mental disability, marital status, sexual orientation, gender identity, gender expression, genetic information (including characteristics and testing), military and veteran status, and any other characteristic protected by applicable law.

Summit School Services LLC’s independent subsidiaries and affiliates are an equal employment opportunity (EEO) employer.

The pay rate range, along with most all of the other terms and conditions of employment, vary between different sites, geographical markets, customer/ contractual terms and positions.