SPARK Schools

Senior Data Analyst

SPARK Schools

full-time

Posted on:

Location Type: Hybrid

Location: Randburg • 🇿🇦 South Africa

Visit company website
✨ AI Apply
Apply

Job Level

Senior

Tech Stack

AzureSparkSQLSSIS

About the role

  • Solve new and challenging data problems across the SPARK Schools ecosystem, including establishing a single source of truth, data management, and defining organisational data processes
  • Partner with business units to scope and prioritise projects, maintain infrastructure, and drive data-driven decision-making across departments
  • Build and run end-to-end Azure data pipelines (Data Factory, Databricks, ADLS Gen2, Azure SQL), implementing orchestration, scheduling, and dependency management
  • Design and implement modern data warehouse solutions (Kimball modelling, conformed dimensions, SCD Type-2, incremental/CDC patterns)
  • Deliver enterprise-grade Power BI solutions at scale, including dataset modelling, DAX optimisation, RLS/OLS, dataflows, deployment pipelines, and administration
  • Apply engineering best practices: Git-based CI/CD (Azure DevOps), Infrastructure-as-Code (ARM templates), automation/runbooks, and environment promotion
  • Ensure data quality, governance, and compliance (validation tests, lineage, POPIA/GDPR, monitoring and alerting)
  • Optimise performance and cost: query tuning (SQL & Spark), storage/compute optimisation, and ensuring reliability/observability
  • Mentor and support other analysts, simplify complex topics for non-technical audiences, and provide ad-hoc analyses when required
  • Reports To: Chief Information Officer

Requirements

  • Completed relevant bachelor’s degree in mathematics, engineering, computer science, or another relevant field (Master’s degree preferable)
  • 5 to 7 years of experience as a Data Analyst — 2 of which must be in a Senior Data Analyst role
  • Expert knowledge of SQL
  • Expert level usage of BI tools (Power BI & Excel/Google Sheets)
  • Proven experience in Azure Data Factory, Databricks, Delta Lake, ADLS Gen2, and Azure SQL
  • Strong knowledge of data modelling (Kimball, conformed dimensions, SCD Type-2, incremental/CDC)
  • Experience with CI/CD pipelines (Azure DevOps), Infrastructure-as-Code (ARM), and automation
  • Experience in data governance, testing, compliance, and monitoring
  • Analytics experience across multiple company domains (Product, Sales, Marketing, Customer Service, Finance)
  • Experience with web analytics and optimisation tools (Mixpanel, Google Analytics, etc.)
  • Experience in designing and setting up experiments (hypothesis testing, multivariate analysis, or Bayesian) a plus
  • Experience working with developers
  • Experience with databases
  • Familiarity with version-control systems
  • Strong interpersonal and communication skills
  • Excellent command of the English language, both written and spoken
  • Experience with a BI transformation tool is a plus
  • Competencies listed: SQL Server, T-SQL, SSIS, SSAS, SSRS, Git / Azure DevOps, Infrastructure-as-Code (ARM templates)
Benefits
  • fair market linked remuneration
  • 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
  • Compensation: Commensurate with experience.

Applicant Tracking System Keywords

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

Hard skills
SQLPower BIAzure Data FactoryDatabricksADLS Gen2Azure SQLdata modellingCI/CDInfrastructure-as-Codedata governance
Soft skills
interpersonal skillscommunication skillsmentoringproblem-solvingsimplifying complex topics