2,447,979open jobs
150,228companies
298,842added this week
Browse all
Location
In office (Johannesburg)
Seniority
Staff · 8+ years exp
Employment
Full-Time

Confirmed on the employer's own hiring board on Nov 20, 2026. First seen by Alion on Nov 17, 2026.

Overview
Company
Impact
Profile match

Kaelo provides essential healthcare solutions ensuring the physical and psychosocial wellbeing of all South Africans towards lasting social change. Kaelo meets the Healthcare needs of Corporate and Retail clients across South Africa - products offerings include Medical Insurance, Medical Aid, Gap Insurance, Kaelo Money and employee assistance programmes.

The BI Developer is responsible for the design, development, implementation and ongoing optimisation of the Lifestyle business intelligence and reporting environment, with a primary focus on Employee Assistance Programme (EAP) reporting.

The role will transform operational, clinical service and programme data into accurate, meaningful and actionable business intelligence that supports executive decision-making, client reporting, service delivery optimisation and the measurement of programme effectiveness and impact.

The successful candidate will develop and maintain automated reporting solutions, interactive Power BI dashboards, data models and reporting infrastructure that provide visibility across the full EAP service journey, from access and utilisation through to presenting needs, interventions, outcomes and organisational impact.

A key objective is to move the business beyond traditional activity-based reporting towards an integrated, insight-driven reporting model that demonstrates the value, reach, effectiveness and impact of EAP and Lifestyle interventions.

Key performance areas and responsibilities

A. EAP reporting and business intelligence development

  • Design, develop and maintain comprehensive Power BI dashboards and reporting solutions for EAP and Lifestyle services.
  • Translate business requirements into meaningful reporting specifications, data models and visual dashboards.
  • Develop reporting that provides visibility into:
    • Eligible lives and covered populations.
    • EAP utilisation and penetration rates.
    • Case volumes, session volumes and service frequency.
    • Presenting problems and employee support needs.
    • Risk categorisation and case complexity.
    • Referral sources and referral pathways.
    • Service access channels and modes of engagement.
    • Counselling, coaching and other interventions.
    • Client, employee and service satisfaction.
    • Programme participation and engagement.
    • Trends, emerging risks and changes in employee needs.
  • Develop trend analysis, benchmarking and comparative reporting across clients, industries, business units and reporting periods.
  • Enable reporting that demonstrates the relationship between EAP interventions, employee wellbeing and organisational outcomes, where supported by available data.
  • Build executive-level dashboards that translate complex data into clear business insights and recommendations.

B. Data integration and management

  • Identify, extract, consolidate and integrate data from multiple operational and business systems.
  • Develop and maintain reliable data pipelines and ETL/ELT processes.
  • Work with relevant systems and data sources, including:
    • Lifestyle Management System (LMS).
    • Historical MIP and ScopServ data, where applicable.
    • QContact telephony and contact centre data.
    • CRM and client management information.
    • Learning and programme management platforms.
    • Coaching, counselling and other Lifestyle service data.
  • Establish consistent data structures, definitions and reporting standards across systems.
  • Identify data gaps, inconsistencies, duplication and integrity issues.
  • Develop processes to improve data quality, completeness and accuracy.
  • Ensure that data is appropriately mapped across clients, divisions, eligible populations, service types and reporting periods.
  • Support the development of an integrated Lifestyle data environment that reduces manual reporting and fragmented information.

C. Reporting automation and optimisation

  • Automate recurring operational, management and client reporting processes.
  • Reduce reliance on manual Excel manipulation and spreadsheet-based reporting.
  • Develop standardised reporting templates and reusable data models.
  • Implement automated data refreshes, validation checks and exception reporting.
  • Develop downloadable client reports and self-service reporting capabilities.
  • Improve reporting turnaround times, consistency and reliability.
  • Investigate and resolve reporting discrepancies and system-related data issues.

D. Client reporting and insights

  • Develop client-facing reporting solutions that provide meaningful visibility into EAP utilisation, employee needs, service delivery and programme engagement.
  • Translate raw data into relevant insights that demonstrate the value of EAP services.
  • Support the development of customised client reports where specific reporting requirements exist.
  • Identify emerging trends and opportunities for proactive client engagement.
  • Provide analytical support for client reviews, quarterly business reviews and executive presentations.
  • Ensure reports are understandable and relevant to both operational stakeholders and senior client executives.

E. Data governance, confidentiality and compliance

  • Establish and maintain data definitions, reporting rules and business logic.
  • Ensure reporting accuracy, consistency and traceability.
  • Apply appropriate data access controls, security and confidentiality standards.
  • Ensure compliance with POPIA and applicable information security requirements.
  • Ensure that sensitive employee and counselling information is appropriately protected.
  • Apply aggregation, anonymisation and de-identification principles to client-facing and management reporting.
  • Work within appropriate professional and ethical boundaries when handling counselling and employee wellness data.
  • Maintain documentation of data sources, transformations, calculations and reporting methodologies.

F. Business partnering and continuous improvement

  • Work closely with the Head of Product - Lifestyle, operational management, counselling and coaching teams, IT and relevant system stakeholders.
  • Engage business users to understand reporting needs and translate these into technical solutions.
  • Proactively identify opportunities to improve reporting processes and business intelligence capabilities.
  • Provide analytical insights that inform service capacity planning, resource allocation and operational decision-making.
  • Support the evolution of the Lifestyle reporting strategy and future data architecture.
  • Keep abreast of BI developments, data visualisation techniques and emerging reporting technologies.

3. Key deliverables

The successful candidate will be expected to deliver:

  • EAP Power BI dashboard: A comprehensive, interactive reporting environment providing visibility into utilisation, employee needs, service delivery, interventions and trends.
  • Client reporting portal: Scalable, downloadable and client-specific reporting capabilities.
  • Automated reporting: Reduced manual reporting through automated data extraction, transformation, validation and refresh processes.
  • Integrated data model: A consistent reporting structure across relevant Lifestyle systems and data sources.
  • Data quality framework: Defined data standards, validation rules and exception reporting.
  • Executive insights: Meaningful analysis that supports strategic decision-making and demonstrates programme value.
  • Future-state reporting capability: A scalable BI environment capable of accommodating additional Lifestyle programmes and services.

Minimum qualifications and experience

  • Bachelor's degree or diploma in Information Systems, Computer Science, Data Science, Business Intelligence, Statistics or a related field.
  • Minimum 8 - 10 years' experience in BI development, data analytics or business intelligence.
  • Proven experience developing and maintaining Power BI dashboards and reporting solutions.
  • Strong SQL skills and experience working with relational databases.
  • Demonstrable experience in data modelling, ETL/ELT and data integration.
  • Experience working with multiple data sources and complex datasets.
  • Experience automating reporting processes.
  • Strong analytical and problem-solving capabilities.

5. Technical competencies

The candidate should demonstrate practical proficiency in:

  • Microsoft Power BI, including DAX, Power Query and data modelling.
  • SQL and database querying.
  • Data transformation and integration.
  • ETL/ELT processes.
  • Dashboard design and data visualisation.
  • Data validation and quality assurance.
  • Excel and advanced data analysis.
  • Data warehouse concepts and reporting architecture.
  • Power BI Service, scheduled refreshes, workspace management and access controls.

Advantageous:

  • “Google BigQuery or Microsoft Fabric and Azure data services as advantageous
  • Python for data manipulation and automation.
  • API integrations.
  • Power BI Embedded or client-facing portal integrations.
  • Experience integrating CRM, telephony, HR or case management systems.

Additional Information

Essential behavioural competencies

The role requires an individual who demonstrates:

  • Ownership and accountability: Takes responsibility for the accuracy, completeness and delivery of reporting outputs.
  • Analytical thinking: Can interrogate data, identify patterns and distinguish meaningful insights from surface-level statistics.
  • Problem-solving: Investigates discrepancies and identifies root causes rather than simply reporting errors.
  • Business acumen: Understands how operational data translates into business performance, client value and strategic decisions.
  • Attention to detail: Maintains high standards of data accuracy and integrity.
  • Communication: Can explain technical concepts and complex findings to non-technical stakeholders.
  • Initiative: Identifies opportunities for improvement and proactively develops solutions.
  • Ethics and discretion: Understands the sensitivity of employee wellness and counselling information.
Free account
Stop reading job ads. Get the ones that fit.
One free account turns this page into a shortlist built around your stack, your level and your pay.
Match on every job. Stack, seniority, pay and location, scored against your profile.
2,447,979 open roles. Read straight off company career pages, refreshed every day.
Unlimited applications. Every one you send is tracked in one place, on-site or on a company board.
3 tailored CVs a month. Rewritten for the exact job you are applying to. Included free.
Create a free account Continue with Google
Free forever. No card. Under a minute.

Your match

How well do you fit this role?
Two answers are enough for a real match. No account needed.
Check my fit
Answers stay in this browser until you create an account.

Recommended for you based on this role

Analytics
Similar stack
Same company
Johannesburg
Hybrid · Full-Time · Cape Town
Management
Agile
Waterfall
Apply
In office · 3+ years exp · Johannesburg
Apply
$75k per year (gross) · In office · Pretoria
Management
Agile
Scrum
Apply
$34k per year (gross) · In office · Pretoria
Apply
$16k per year (gross) · In office · Full-Time · Cape Town
DevOps
Incident Management
Management
ITIL
Service Desk
Apply
In office · 10+ years exp · Colombia
Python
SQL
Python
pySpark
Databases
Snowflake
MS SQL
AI/ML
Spark
DevOps
GCP
Azure DevOps
Azure
CI/CD
Analytics
Azure Data Factory
Apply
$140k – $180k per year · Hybrid · Full-Time · Warren
Python
JavaScript
TypeScript
SQL
C#
C#
.NET
Databases
PostgreSQL
Frontend
React.js
DevOps
Rest API
Azure
CI/CD
SOAP
Apply
$171k – $203k per year · In office · 10+ years exp · Master's Degree · Houston
Python
SQL
Databases
Snowflake
Microsoft Fabric
AI/ML
Model Context Protocol
AI Agents
RAG
Knowledge Graph
DevOps
Azure
Apply
DevOps 1 hour ago
In office · Full-Time · High School Diploma · Montreal
Python
JavaScript
Groovy
Frontend
npm
DevOps
Terraform
Ansible
GitHub Actions
OpenTofu
VMWare
Prometheus
GitLab CI
Azure
CI/CD
Jenkins
Git
AWS
Docker
Kubernetes
Grafana
JFrog Artifactory
Proxmox VE
GitLab
Linux
Windows
Management
Agile
Scrum
Kanban
Apply
$193k – $260k per year · In office · Public Trust · 4+ years exp · High School Diploma · Silver Spring
SQL
PowerShell
DevOps
Terraform
Azure
CI/CD
AWS
Linux
Windows
Cybersecurity
FedRAMP
Microsoft Entra ID
Active Directory
Management
ITIL
Apply
UX/UI Designer 1 day ago
In office · Full-Time · 4+ years exp · Johannesburg
Mobile
Material Design
Design
Figma
Sketch
Management
Miro
Agile
Apply
Odoo Developer 2 days ago
In office · Full-Time · 3+ years exp · Bachelor's Degree · Sandton
Python
JavaScript
SQL
Python
Flask
Django
Databases
PostgreSQL
DevOps
Rest API
CI/CD
Git
Docker
Ubuntu
Linux
Analytics
ETL/ELT
Management
Agile
Scrum
Apply
Data Engineer 21 days ago
In office · Full-Time · 4+ years exp · Master's Degree · Johannesburg
Python
SQL
Analytics
Power BI
SSIS
Microsoft Excel
Management
Jira
Apply
Cloud Engineer 24 days ago
In office · Full-Time · 5+ years exp · Johannesburg
PowerShell
DevOps
Terraform
GCP
VMWare
Azure
Bicep
Hyper-V
FinOps
IAM
Cybersecurity
ISO 27001
Microsoft Defender for Cloud
Microsoft Entra ID
Apply
In office · Full-Time · 5+ years exp · Johannesburg
Cybersecurity
ISO 27001
NIST CSF
CIS Benchmarks
Least Privilege
Microsoft Entra ID
Apply
Cloud Engineer 6 hours ago
In office · Full-Time · Johannesburg
Python
PowerShell
Bash
Databases
Databricks
Microsoft Fabric
DevOps
Terraform
Ansible
Azure DevOps
GitHub Actions
CloudFormation
Azure
CI/CD
Windows Server
Jenkins
Git
AWS
Docker
Kubernetes
Configuration Management
AWS Lambda
FinOps
Windows
DNS
Cybersecurity
ISO 27001
SOC 2
Management
Agile
Scrum
Apply
Security Architect 6 hours ago
In office · Contractor · Johannesburg
DevOps
IAM
Cybersecurity
Zero Trust
SIEM
Apply
In office · 5+ years exp · Johannesburg
Apply
In office · Full-Time · Johannesburg
Apply
In office · Johannesburg
Apply
See all jobs
This is one of many
2,447,979 more open roles from verified company boards, updated every day.