Back to jobs

Lifestyle BI Developer

Johannesburg, GP, South Africa

Actively hiring, first seen by us 3 days ago
Pay
Pay not listed
Work setting
On-site — work setting source
Work setup in the employer’s posting: On-site
From the employer’s posting
Employment
Full-time — employment source
Employment type in the employer’s posting: Full-time
From the employer’s posting

What you’ll work on

Full posting
  • Design and maintain Power BI dashboards and reporting for EAP and Lifestyle services

  • Build data pipelines and ETL/ELT processes across LMS, CRM, QContact and other systems

  • Automate recurring operational and client reports to reduce manual Excel work

  • Develop client-facing reports and insights on EAP utilisation and engagement

  • Enforce data definitions, quality checks and POPIA-compliant confidentiality

From the employer’s posting
Design, develop and maintain comprehensive Power BI dashboards and reporting solutions for EAP and Lifestyle services.
Develop and maintain reliable data pipelines and ETL/ELT processes.
Automate recurring operational, management and client reporting processes.
Develop client-facing reporting solutions that provide meaningful visibility into EAP utilisation, employee needs, service delivery and programme engagement.
Ensure compliance with POPIA and applicable information security requirements.

What you’ll bring

All qualifications

Core experience

  • Bachelor's degree or diploma in Information Systems, Computer Science, Data Science, Business Intelligence, Statistics or a related field.
  • SQL and database querying.
  • Python for data manipulation and automation.
  • Proven experience developing and maintaining Power BI dashboards and reporting solutions.
  • Experience integrating CRM, telephony, HR or case management systems.
  • Strong SQL skills and experience working with relational databases.
Qualification wording
Bachelor's degree or diploma in Information Systems, Computer Science, Data Science, Business Intelligence, Statistics or a related field.
SQL and database querying.
Python for data manipulation and automation.
Proven experience developing and maintaining Power BI dashboards and reporting solutions.
Experience integrating CRM, telephony, HR or case management systems.
Strong SQL skills and experience working with relational databases.
Education & alternatives
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.
Apply at Kaelo

Posting record

Report an error

Actively hiringFirst seen by us 3 days ago, still listed, and not a repost of an earlier posting.

Status in our records
Live
First seen by us
Nov 18, 20263 days ago
Recorded sightings
4
Last seen by us
Nov 22, 2026

These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.

How this job compares

Time since we first saw it

Day 3

Early. Similar jobs usually come down between day 5 and day 43.

From 16,009 similar postings that came down. Coming down is not always a hire.

Kaelo is hiring

2 open jobs

Open jobs by the week we first saw them, last 12 weeks.

  • 50% of open jobs were reposted
Hiring record

See how this role fits your experience

Add your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.

  • Python
  • SQL
  • Azure
  • BigQuery
  • Excel
  • Power BI
  • Power Query
Where the posting names them
- “Google BigQuery or Microsoft Fabric and Azure data services as advantageous - Python for data manipulation and automation. - API integrations.
- 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.
- Microsoft Power BI, including DAX, Power Query and data modelling. - SQL and database querying. - Data transformation and integration.
Advantageous: - “Google BigQuery or Microsoft Fabric and Azure data services as advantageous - Python for data manipulation and automation.
- 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.
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.
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.
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.
- 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.
The candidate should demonstrate practical proficiency in: - Microsoft Power BI, including DAX, Power Query and data modelling. - SQL and database querying.
- Data warehouse concepts and reporting architecture. - Power BI Service, scheduled refreshes, workspace management and access controls. Advantageous:
- API integrations. - Power BI Embedded or client-facing portal integrations. - Experience integrating CRM, telephony, HR or case management systems.

Your next step

Complete your application on jobs.smartrecruiters.com. The employer’s form will show what is required.

Applying through SmartRecruiters

  • Uploading your resume fills in the application form for you, so check what it filled before you send.

Already applied? Track this application

Job description

View original posting ↗

Job Description

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:

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

Qualifications

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

 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.

Company Description

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.

Demand for Analyst roles

New Analyst postings at the employers we follow are up 26% over the last 6 weeks compared with the 6 before.

Weekly new Analyst postings at the same employers, from the week of August 17 to the week of November 9. The fewest in a week was 993, the most 1,510, and the latest week had 1,367.
August 17Last week

Each bar is one week of new postings. The darkest bars are the last 6 weeks.

Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.

About the role

We file this job under Analyst, by the work the posting describes.

Analysts answer business questions with data. They pull numbers with SQL, build reports and dashboards, and explain what changed and why to the people making decisions.

Most postings ask for SQL, spreadsheets, a dashboard tool such as Tableau or Power BI, and clear writing.

Unlike a data scientist, an analyst mostly explains what happened rather than building models that predict what will.

Source details

View original posting ↗

Source notes

Source excerpts

Selected passages from the saved posting. Check the full description for conditions and exceptions.

Pay

No pay amount identified in the saved description.

Location & working pattern

Johannesburg, GP, South Africa

Working pattern and location restrictions need checking in the full posting.

Work authorization

No clear work-authorization passage found. Eligibility is unconfirmed.

Find answers in the posting

AI
How answers work

AI selects complete passages from this posting. Check them for conditions and exceptions.

Uses this posting and your question. No profile needed.