23h ago
New

Symmetry: Investment Data Engineer

Pinelandsmid
Data EngineerData
2 views0 saves0 applied

Quick Summary

Overview

Let's Write Africa's Story Together! Old Mutual is a firm believer in the African opportunity and our diverse talent reflects this. Job Description Symmetry is a business in build mode,

Technical Tools
Data EngineerData

Let's Write Africa's Story Together!

Old Mutual is a firm believer in the African opportunity and our diverse talent reflects this.

Symmetry is a business in build mode, evolving and growing. We are looking for an Investment Data Engineer with strong SQL and data warehouse design skills and solid Power BI capability. Experience in a multi-manager, asset management or investment platform environment is strongly preferred.

The role designs, builds and maintains the data warehouse, data pipelines and semantic models behind Symmetry’s reporting. It is a hands-on technical position, focused on well-structured data, efficient SQL and reliable, performant Power BI reports

Responsibilities

~1 min read

  • Design, build and maintain Power BI reports and dashboards for investment, client, operational and management reporting.
  • Develop Power Query transformations and DAX measures that are accurate, performant and fit for purpose.

  • Work with investment data such as holdings, transactions, valuations, performance and reference data, and apply measures and classifications consistently across outputs.
  • Partner with the Operations team to deliver reliable reporting and analytics that support daily oversight, exception management and timely decision-making.
  • Support the production of client, compliance and regulatory reporting by delivering accurate, complete and timely data that meets required standards and deadlines.
  • Support operational controls by building automated reconciliations, validation checks and exception reports, and by providing the data and evidence required for governance and audit reviews.

  • Design, build and evolve the data warehouse using dimensional (star-schema) models, with clearly defined fact and dimension structures, keys and grain.
  • Build and optimise Power BI semantic models, relationships and row-level security.
  • Write and maintain advanced SQL (stored procedures, views and functions) and ETL/ELT pipelines to ingest, transform and reconcile data from source systems.

  • Apply sound engineering practices, including source control, peer review and documented deployments.
  • Monitor and troubleshoot data loads, refreshes and report performance, tuning queries and models where needed.

  • Implement data-quality checks and reconciliations so reports are accurate, complete and traceable to source.
  • Maintain technical documentation, data dictionaries and data lineage.

  • Lives Symmetry’s values of being brave, adaptable, authentic and enduring, not just in what they do, but how they show up and work with others. 
  • Comfortable operating in a team that is building, improving, and solving as it goes, with a strong bias for ownership and practical delivery. 
  • Brings curiosity, accountability and a continuous-improvement mindset to reporting, data quality and stakeholder service.

These responsibilities provide an overview of the role and are not exhaustive.


Requirements

~1 min read

  • 5+ years’ hands-on experience in data engineering, data warehousing or business intelligence development.
  • Strong SQL (T-SQL preferred), including complex queries, stored procedures, indexing and performance tuning.
  • Solid Power BI capability, including Power Query, DAX, semantic modelling and report development.
  • Hands-on data warehouse design experience, including dimensional and star-schema modelling (Kimball), fact and dimension design, and slowly changing dimensions.
  • Experience building and maintaining ETL/ELT pipelines (e.g. SSIS, Azure Data Factory or similar).
  • Strong analytical and problem-solving skills, with a disciplined approach to data reconciliation and root-cause analysis.
  • Clear communication, able to explain technical design and data logic to technical and non-technical colleagues.
  • Relevant degree or equivalent in computer science, information systems, data engineering, mathematics or a related technical discipline.
  • Experience in a multi-manager, asset management or investment platform environment, including investment data concepts such as funds, holdings, instruments, NAV and AUM.
  • Exposure to InfoStore or similar investment data platforms would be an advantage.
  • Exposure to Microsoft Fabric or Azure data services (e.g. Data Factory, Synapse, Azure SQL).

 

na

Action Planning, Application Development, Business Requirements Analysis, Computer Literacy, Data Compilation, Data Controls, Data Management, Data Modeling, Executing Plans, Gap Analysis, IT Network Security, Management Reporting, Market Analysis, Policies & Procedures, User Requirements Documentation

Action Oriented
Business Insight
Cultivates Innovation
Drives Engagement
Drives Results
Manages Ambiguity
Manages Complexity
Optimizes Work Processes

NQF Level 7 - Degree, Advance Diploma or Postgraduate Certificate or equivalent

29 November 2026 , 23:59

The appointment will be made from the designated group in line with the Employment Equity Plan of Old Mutual South Africa and the specific business unit in question.

The Old Mutual Story!

Location & Eligibility

Where is the job
Pinelands
On-site at the office
Who can apply
Same as job location

About this job

Posted
Today
Employer
has 1,242 open jobs on Jobera in 17 countries.

Listing Details

Posted
November 22, 2026
First seen
November 22, 2026
Last seen
November 22, 2026

Posting Health

Days active
0
Repost count
0
Trust Level
51%
Scored at
November 22, 2026

Signal breakdown

freshnesssource trustcontent trustemployer trust
Newsletter

Stay ahead of the market

Get the latest job openings, salary trends, and hiring insights delivered to your inbox every week.

A
B
C
D
Join 12,000+ marketers

No spam. Unsubscribe at any time.

Symmetry: Investment Data Engineer