Job Description

Who are we?

At MiWay, 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 MiWay 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 MiWay’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 MiWay’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; working PL/SQL for Oracle sources.
• Hands-on SSIS development and support (package design, deployment, scheduling, troubleshooting).
• SSAS cube development and maintenance (tabular and/or multidimensional), including DAX or MDX.
• SSRS report development and Power BI semantic modelling (star schemas, measures, row-level security).
• Strong understanding of data engineering, data warehousing, and ETL/ELT frameworks, including dimensional modelling.
• Familiarity with production data environments, scheduling and release practices.

Advantageous

• Exposure to cloud data platforms (Azure, AWS or Snowflake) and Medallion/lakehouse patterns.
• Understanding of on-premise and cloud-based architectures and integration patterns.
• Exposure to core insurance administration systems (e.g. TIA) is highly advantageous.

Knowledge and Skills

Data Architecture

Data Governance

Data Management

Scripting Languages

Manage problem identification and resolution within test environment

Personal Attributes

Manages complexity - Contributing through others

Plans and aligns - Contributing through others

Optimises work processes - Contributing through others

Tech savvy - Contributing through others

Core Competencies

Collaborates - Contributing through others

Being resilient - Contributing through others

Cultivates innovation - Contributing through others

Customer focus - Contributing through others

Drives results - Contributing through others

Turnaround time

The shortlisting process will only start once the application due date has been reached. The time taken to complete this process will depend on how far you progress and the availability of managers. Deadline to apply: 18 September 2026.

Our commitment to transformation

At MiWay we believe in cultivating a positive and dynamic working environment that gives you freedom and opportunity to succeed. MiWay is committed to transformation and embracing diversity. This is what drives us to achieve a multicultural workplace with employment equity as a key goal to create an inclusive workforce, reflective of the demographics of our society.