Finance Data Engineer

Old Mutual Life Assurance Company (SA) Ltd (PFA); Johannesburg; On-site; ZAR 600,000 - 900,000; Full time

Job summary

A prominent financial services provider in Johannesburg is seeking a Data Engineer to design and maintain data integration processes. The ideal candidate will use their expertise in Python and SQL to build data pipelines and ensure data quality. The role requires collaboration with actuarial teams to enhance data solutions. A Bachelor's degree in Computer Science or a related field is essential. Closing date for applications is 30 July 2025.

Qualifications

• Proficiency in Python and SQL for data handling.
• Experience with ETL processes and data integration.
• Bachelor's degree in Computer Science or related field required.

Responsibilities

• Design and maintain data pipelines using Python.
• Implement data quality checks and governance.
• Collaborate with teams for data solutions.

Skills

Python (Programming Language)

SQL

Data Analysis

ETL Tools

Cloud Applications

Education

Bachelor of Computer Science (BCoSc)

Bachelor of Information Technology (BIT)

Bachelor of Science (BSc): Actuarial Science

Job description

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

Job Description

The Data Engineer is responsible for designing, implementing, and maintaining data integration processes within Old Mutual’s actuarial data ecosystem, which includes Delta Bricks, the Data Lake, and Bronze/Silver/Gold data tables. This role ensures that Python scripts and other technical code for ingestion and transformation are properly updated, optimized, and maintained, while safeguarding data quality and reliability. The incumbent will collaborate with Actuarial teams and other stakeholders to provide stable, accurate, and timely data solutions that support actuarial calculations, product pricing, financial reporting, and risk management.

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

The Data Engineer is responsible for designing, implementing, and maintaining data integration processes within Old Mutual’s actuarial data ecosystem, which includes Delta Bricks, the Data Lake, and Bronze/Silver/Gold data tables. This role ensures that Python scripts and other technical code for ingestion and transformation are properly updated, optimized, and maintained, while safeguarding data quality and reliability. The incumbent will collaborate with Actuarial teams and other stakeholders to provide stable, accurate, and timely data solutions that support actuarial calculations, product pricing, financial reporting, and risk management.

Data Pipeline Development & Maintenance

• Design, develop, and maintain end-to-end data ingestion pipelines (using Python and other relevant technologies) to move data from various source systems into Delta Bricks and the Data Lake.
• Create and manage ETL/ELT processes to curate data through bronze, silver, and gold layers, ensuring consistent data quality and integrity

Data Quality & Governance

• Implement robust validation, cleansing, and reconciliation checks to ensure accuracy and completeness of data across all layers.
• Collaborate with Actuarial teams to define data quality standards and uphold governance policies within the data pipeline.

Code & Script Management

• Write, review, and maintain Python scripts (or other relevant code) used for data extractions, transformations, and loading processes.
• Manage version control and continuous integration/continuous deployment (CI/CD) practices for all data engineering codebases.

Performance Monitoring & Optimization

• Monitor data pipeline performance to identify bottlenecks and optimize code for maximum throughput, scalability, and fault tolerance.
• Conduct capacity planning and implement performance tuning measures.

Collaboration & Stakeholder Engagement

• Partner with Actuarial Analysts, Data Scientists, and other business stakeholders to understand data requirements and propose solutions that meet actuarial and reporting objectives.
• Coordinate with platform teams to ensure alignment with enterprise data architecture, security, and compliance standards.

Documentation & Knowledge Sharing

• Maintain thorough documentation of all data flows, data models, processes, and system configurations.
• Provide technical guidance, training, and best practices to team members and business partners as needed.

Incident Management & Continuous Improvement

• Troubleshoot and resolve production issues or data anomalies in a timely manner.
• Continuously refine and enhance the data engineering environment to maintain high-quality data for actuarial use cases.

Skills

Analysis of Alternatives (AoA), Analytical Processes, Analytical Sciences, Assessment Testing, Business Intelligence (BI) Analysis, Categorizing Data, Cloud Applications, Computer Literacy, Data Analysis, Database Reporting, Data Compilation, Data Controls, Data Governance, Data Interpretations, ETL Tools, Financial Modeling, Information Retrieval, Management Accounting, Numerical Aptitude, Planning and organisational skills, Python (Programming Language), Research Methodologies, Statistical Analysis Techniques, Structured Query Language (SQL), Version Control Tools

Competencies

Business InsightEnsures AccountabilityFinancial AcumenManages ComplexityOptimizes Work ProcessesResourcefulnessSelf-DevelopmentTech Savvy

Education

Bachelor of Computer Science (BCoSc) (Required), Bachelor of Information Technology (BIT) (Required), Bachelor of Science (BSc): Actuarial Science (Required)

Closing Date

30 July 2025 , 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!