About our client: Our client, a reputable financial services firm listed on the Johannesburg Stock Exchange (JSE), holds a strong belief in the transformative power of incremental progress. They are committed to empowering individuals and businesses alike, offering tailored solutions and expert guidance to help pave the way to success. With a focus on innovation and excellence, they provide secure financial futures through personalised advice and cutting-edge products. Their mission is to support diverse goals and aspirations, enriching lives across every journey. What you will be doing: Design scalable relational and analytical data models, building structures optimised for both operational (OLTP) and reporting (OLAP) workloads. Build and maintain robust data ingestion and transformation processes, developing reliable ETL/ELT pipelines to integrate data from diverse internal and external systems. Analyse execution plans, troubleshoot performance issues, and implement advanced indexing...