AWS Data Engineering

Old Mutual SA - Two-Pot Retirement Data Platform

Supported data engineering for the Two-Pot Retirement System, a retirement savings model that separates contributions into vested, savings, and retirement components. The work focused on market values, transformation, reporting, and client-ready outputs.

Role Data Engineer

Domain Retirement + Insurance

Focus AWS Data Pipelines

Pipeline Design

Transforming legacy market values into client-ready reporting outputs.

Built AWS-backed data workflows to extract values from legacy systems, apply product-specific transformations, and publish data in formats required by downstream clients, reporting, and visualization processes.

Legacy Systems

Market Values

AWS Processing

Product Rules

Client Outputs

Reporting

Data Extraction

Pulled market values and retirement product data from legacy systems and prepared them for downstream transformation.

Legacy system integration
Market value extraction
Data quality checks

Transformation

Applied product-level business transformations to support vested, savings, and retirement pot reporting requirements.

Product-specific rules
Spark and Python processing
Polars and Pandas workflows

Publishing

Wrote transformed data into formats available to downstream clients, reporting jobs, and visualization workflows.

Client-ready output formats
Postgres persistence
Reporting and visualization support

Technology Stack

Cloud and data processing tools for regulated financial workflows.

Apache Spark AWS Services AWS Lambda Python Polars Pandas Postgres Reporting Visualization

Two-Pot Retirement savings data model support

AWS Cloud-backed data processing workflows

Spark Distributed transformation and processing