Data Engineer: Real-Time Analytics & Dashboards

Kaelo; City of Johannesburg Metropolitan Municipality; On-site; ZAR 600,000 - 900,000; Full time

Job summary

Kaelo, a leading South African healthcare solutions provider, seeks an experienced Data Engineer to join the Data Engineering Department. You will design, transform and automate data flows from multiple sources into a central Data Warehouse, deliver dashboards, and partner with business stakeholders to drive insights for operations and strategy.

The role emphasizes real-time reporting, data governance, and cross-functional collaboration with business units to improve data quality and

Qualifications

• 4-5 years working experience in analytical, reporting or data warehouse teams.
• Experience creating business requirements and functional specs.
• Strong stakeholder engagement and collaboration with cross-functional teams.
• Proven ability to document data requirements and processes clearly.

Responsibilities

• Write scripts to automate data jobs and feeds for real-time/self-service reporting.
• Build dashboards and reports using Power BI or similar tools.
• Acquire datasets aligned with business needs.
• Analyze source data systems to improve data availability and quality.
• Develop business rules to transform data into actionable information.
• Monitor and maintain the Production Data Warehouse.
• Collaborate with management to align data with company objectives.
• Create data validation methods and analysis tools.
• Gather, interpret and document reporting requirements from business.
• Transform and enrich data from multiple sources for value.
• Mine and prepare ad-hoc reports to uncover insights for automation.

Skills

Data analysis

SQL

Power BI

Excel

Python

VBA

Data warehouse

Mainframe MIP

Jira

MS Project

Visio

Education

Bachelor's degree in Computer Science / Information Science / Data Science

SSIS

Data Warehouse

Tools

Jira

Slack

Fresh

MS Project

Visio

Job description

Kaelo, a leading South African healthcare solutions provider, seeks an experienced Data Engineer to join the Data Engineering Department. You will design, transform and automate data flows from multiple sources into a central Data Warehouse, deliver dashboards, and partner with business stakeholders to drive insights for operations and strategy.

The role emphasizes real-time reporting, data governance, and cross-functional collaboration with business units to improve data quality and