Commercial Data and Insights Analyst

SPARK Schools

Commercial Data & Insights Analyst responsible for operational insights across the parent lifecycle at SPARK Schools. Supporting various teams with reporting and analysis for growth and performance improvements.

Posted 5/20/2026full-timeRandburg • 🇿🇦 South AfricaMid-LevelSeniorWebsite

Tech Stack

Tools & technologies

SQLTableau

About the role

Key responsibilities & impact

**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.

Requirements

What you’ll need

**Qualifications and Criteria**
**Experience: **
- 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
**Values: **Service, Persistence, Achievement, Responsibility, Kindness

Benefits

Comp & perks

**SPARK offers:**
- fair market linked remuneration
- discretionary performance-based annual bonuses and increases
- above average/good annual leave
- life, disability and funeral cover
- employee wellness support
- educational support & study leave
- individualised professional development, support and mentorship
- employee discount on school fees
- opportunities for career growth

ATS Keywords

✓ Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

commercial analyticssales analyticsfinance analyticsbusiness intelligencedashboard developmentdata visualizationreporting accuracySQLspreadsheet modelinganalytical capability

Soft Skills

analytical problem-solvingattention to detailpresentation skillscommunication skillsstakeholder engagementprocess improvementability to work under pressuretime management