Commercial Data and Insights Analyst - SPARK Schools Support - 2026 at SPARK Schools

Purpose of the Role

• The Commercial Data & Insights Analyst is responsible for providing real-time commercial, operational and customer insights across the full parent lifecycle - from lead generation and enrolment through to collections, retention and customer experience.
• The role exists to improve decision-making, operational visibility and commercial performance by transforming fragmented operational data into actionable insights that support enrollment growth, collections performance, utilisation, customer experience and profitability across the network.
• The analyst will support Sales, Marketing, Finance, Schools and Collections through advanced reporting, dashboard development, customer insight analysis and performance deep dives that identify operational risks, trends and improvement opportunities.

Reports To: Head of Sales and Collections

Responsibilities:

Sales & Enrolment Analytics

• Build and manage daily, weekly and monthly enrolment dashboards.
• Track the full lead-to-enrolment funnel across all stages.
• Identify fallout and friction points within the enrollment journey.
• Monitor lead quality, conversion rates and sales productivity.
• Analyse campaign performance across digital channels.
• Track school utilization, enrolment growth and attrition trends.
• Monitor new school ramp-up performance and capacity risk.
• Provide insights impacting revenue growth, utilization and EBITDA performance.

Collections & Revenue Analytics

• Produce real-time collections and cash flow reporting.
• Build debt aging and arrears analysis (30/60/90/180+ days).
• Track collection rate vs cash rate performance.
• Monitor parent payment behaviour and collections trends.
• Identify high-risk arrears accounts and recovery priorities.
• Analyze school-level collections performance and shortfalls.
• Track payment arrangements, promises to pay and recovery campaigns.
• Improve visibility into payment allocation accuracy and bad debt exposure.

Customer Experience & Insights

• Design and manage customer experience reporting across all parent touchpoints.
• Analyse customer surveys, feedback and parent sentiment trends.
• Identify recurring customer pain points across enrolment, billing, collections and communication processes.
• Produce customer insight reports for operational and leadership teams.
• Track customer satisfaction, engagement and service experience metrics.
• Provide actionable recommendations to improve parent experience and retention.
• Monitor communication effectiveness and customer response trends

Performance Deep Dives & Business Intelligence

• Conduct operational deep dives to identify root causes impacting performance.
• Analyse large datasets across spreadsheets, Google Sheets and operational systems.
• Consolidate fragmented operational data into meaningful business insights.
• Build executive-ready dashboards and automated reporting solutions.
• Develop BI dashboards and visual reporting for leadership teams.
• Support strategic decision-making using data trends and forecasting.
• Identify operational bottlenecks and efficiency improvement opportunities

Reporting & Data Management

• Build and maintain automated reporting frameworks.
• Reduce dependency on manual reporting processes.
• Ensure reporting accuracy, integrity and consistency.
• Produce executive commercial performance packs and presentations.
• Provide real-time operational visibility to management teams.
• Support data governance and reporting standardization initiatives.

Success in This Role Looks Like

• Leadership has real-time visibility into sales, collections and customer performance.
• Operational teams make faster and more accurate decisions using data.
• Customer pain points are identified and addressed proactively.
• Reporting moves from manual and reactive to automated and insight-led.
• Performance risks are identified earlier through data analysis.
• The business develops stronger commercial, operational and customer intelligence capability.

Requirements
Qualifications and Criteria

Experience:

• BCom in Business Analytics or related field
• 3–5 years in commercial analytics, sales analytics, finance analytics or business intelligence
• Experience in high-volume operational environments
• Experience presenting insights and analytics to senior leadership teams
• Experience building dashboards and executive reporting tools
• Experience conducting operational performance deep dives

Technical Skills

• Advanced Microsoft Excel and Google Sheets expertise
• Strong knowledge of formulas, lookups, pivot tables and multi-sheet analysis
• Ability to work with large and complex datasets
• Power BI / Tableau / Looker Studio dashboard development
• Data visualization and reporting capability
• CRM and operational systems reporting
• Strong spreadsheet modelling and analytical capability
• SQL advantageous

Competencies

• Strong analytical and problem-solving capability
• Commercial and operational understanding
• Attention to detail and reporting accuracy
• Ability to simplify complex data into actionable insights
• Strong presentation and communication skills
• Ability to engage senior stakeholders confidently
• Process improvement mindset
• Ability to work under pressure and manage multiple priorities