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
go to method of application »
Apply via company website ( ) or