Data engineer

14 hours ago

midrand, gauteng, South Africa Sanlam Full-time R 1 Contract

Free with email or Google

Save this job and keep your search organized

Create a free account to save jobs, create alerts and return to this listing from your dashboard.

Save job Save and create alert

Free with email or Google

Who are we?

At Mi Way, our purpose is to enable people to live their way. We understand that life is not just about "things" but the meaning that those things bring to your life. We believe that technology and innovation have infinite possibilities when it's inspired by humans by you.

Therefore, we focus on our clients' needs; finding new ways to simplify their lives and how they do things.

We give them products, services, and solutions that enable them to live and enjoy life on their own terms – in their own way.

Agile values and principles are strongly embedded in our culture, and they are at the core of how we make decisions and how we approach adding value within the company.

Build a successful career with us

We’re all about building strong, lasting relationships with our employees. We know that you have hopes for your future – your career, your personal development and of achieving great things. We pride ourselves in helping our employees to realise their worth. Through its five business clusters – Sanlam Fintech, Sanlam Life and Savings, Sanlam Investment Group, Sanlam Allianz, Santam, as well as Mi Way and the Group Office – the group provides many opportunities for growth and development.

About the role

Department: Data Intelligence and Governance Group
Reporting To: Lead Data Engineer

Location:
Kosmosdal (Hybrid)

What will you do?

The Data Engineer plays a critical role in building, maintaining, and optimising Mi Way’s data pipelines and data platforms that support enterprise reporting, analytics, and decision-making.
Reporting into the Lead Data Engineer, this role focuses on hands‑on delivery and operational excellence within the data ecosystem. The objective is to ensure data is accurately ingested, transformed, structured, and made available in a consistent and scalable manner, supporting reporting, BI, actuarial, and analytical use cases.
The current reporting estate runs on the Microsoft BI stack: TIA (Oracle) as the core policy administration source, an on‑premise SQL Server data warehouse, SSIS integration, SSAS cubes, and SSRS and Power BI reporting. From day one this role is accountable for keeping that estate stable, accurate and performant.
In parallel, you will contribute to the implementation of modern data engineering patterns, including the Medallion Architecture, and to the cloud and data platform modernisation programme that will progressively replace the legacy workloads. Cloud skills will be developed on the job as the platform evolves.

What will make you successful in this role? Minimum Requirements Bachelor’s Degree or appropriate diploma/certification in Computer Science, Information Systems, Data Engineering, or a related quantitative discipline. Minimum Experience 5+ years’ experience in a Data Engineering, BI/ETL development, or similar role, with hands‑on production experience across the Microsoft BI stack (SQL Server, SSIS, SSAS, SSRS) and Power BI. Strong T‑SQL and working PL/SQL, with experience sourcing data from Oracle‑based operational systems. Practical experience within Short‑Term Insurance, Financial Services, or a closely related regulated industry. Hands‑on experience working with TIA and its data structures (highly advantageous). Exposure to cloud data platforms such as Azure, AWS or Snowflake (a strong plus, not a requirement). A demonstrable appetite to learn these as we modernise is required. Experience contributing to data platform, data warehouse, or cloud migration initiatives (advantageous). Deliverables

The Data Engineer will support the ongoing development and optimisation of Mi Way’s data ecosystem in line with the enterprise data architecture. Key deliverables include:

Legacy Estate Support: Maintain, support and enhance the existing SSIS packages, SSAS cubes and SSRS/Power BI reporting, ensuring scheduled loads complete reliably and reporting SLAs are met. Data Pipeline Development: Design and maintain reliable, well‑documented ETL/ELT pipelines across multiple source systems, including TIA (Oracle) and the SQL Server data warehouse. Data Modelling: Maintain the existing dimensional models and cubes that underpin current reporting, and build curated data structures aligned to the Bronze, Silver, and Gold layers of the Medallion Architecture as the platform modernises. Cloud Enablement: Contribute to cloud migration initiatives and the modernisation of legacy data workloads within AWS or Azure‑based environments, building cloud capability progressively. Performance Optimisation: Optimise T‑SQL queries, SSIS packages, cube processing, transformations and storage strategies to ensure efficient data processing and reporting performance. Data Quality and Controls: Implement validation, reconciliation, and monitoring checks to ensure trusted and business‑ready data assets. Competencies Requires Essential Advanced T‑SQL and strong SQL Server data warehousing skills; wor

Data engineer

Save this job and keep your search organized

Similar jobs in midrand

Related offers

Americas

Europe

Asia / Oceania

Africa

Data engineer

Save this job and keep your search organized

Similar jobs in midrand

Related offers