Intermediate Data Engineer

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

 

 

• Build Pipelines: Build and maintain pipelines to meet business data needs by ensuring data is reliable, accessible, and aligned with strategic goals.  

• Data Champion: Understand the data needs of various business areas and guide in the use of data sources for reporting, management of dashboards, and scorecards.  

• Data Quality: Must ensure data is correct, complete, consistent, up-to-date, valid, unique, and easy to track, while maintaining system reliability, accessibility, minimizing redundancy, documenting processes, and automating checks to ensure high-quality data. 

• Security: Must ensure data security by implementing strong access controls, encryption, authentication, and compliance with regulations to protect sensitive data throughout the pipeline. 

• Stakeholder Management: Be responsive to stakeholder feedback, and continuously optimizing processes to share reporting data with our partners to meet evolving customer needs within agreed timelines 

• Service Levels: Collaborate and work with the Analytics, Distribution, Underwriting, Actuarial, Claims, Finance, HR, IT and other teams to deliver required service levels. 

 

Experience, knowledge & skills required 

• Bachelor’s degree in Computer Science, Engineering, or a related field. 

• 3–5 years of hands-on experience in designing data models, performing data transformation, and ensuring data quality through validation and analysis. 

• Proficient in Python, SAS, and SQL, with strong expertise in Apache Spark (PySpark/Spark SQL) and Databricks for big data processing. 

• Experienced in using Git for version control and implementing CI/CD pipelines, along with tools like Terraform for managing infrastructure-as-code. 

• Solid understanding of data architecture, including data lakes, data warehouses, and BI platforms. 

• Strong logical problem-solving abilities and excellent verbal and written communication skills for effective collaboration with teams and stakeholders. 

 

Collect, analyse, report, and interpret data for use in the development of business strategies and tactics and in subsequent appraisal of results. OML Roles mapped to this profile are: Senior Data Analyst.

Responsibilities

Business Requirements Identification

Proactively collect business requirements using a variety of methods such as interviews, document analysis, workshops, and workflow analysis to express the requirements in terms of target user roles and goals, in order to garner the "why" of the requirements and the benefits of such requirements.

Data Exploration & Manipulation

Conduct research and select relevant information to enable testing, experimental adjustustment and analysis of key themes and trends using primary data sources and business intelligence tools. Coordinates data exploration and manipulation input to strategic projects where integrated data sets are required.

Advanced Analytics

Run advanced analyses and perform model assessments, validation, and enhancement activities, using software tools and functionalities.

Performance Improvement through Business Intelligence

Make recommendations to improve data and analytics systems and platforms, contributing to the continuous improvement and refinement of data and analytics strategy by conducting root cause analyses.

Insights and Reporting

Prepare and coordinate the completion of various data and analytics reports. Generates and test hypotheses and provide measurable and actionable insights and presents dashboards to stakeholders in presentations.

Data Architecture

Consult and educate stakeholders on methods for streamlining and standardizing data recording to ensure quality and accuracy.

Data Collection and Analysis

Collate and analyze data using preset tools, methods, and formats. Involves working independently.

Personal Capability Building

Develop own capabilities by participating in assessment and development planning activities as well as formal and informal training and coaching; gain or maintain external professional accreditation where relevant to improve performance and fulfill personal potential. Maintain an in-depth understanding of relevant industry best practices, business acumen, and broadening of individual skills such as presentation, communication and visualisation through ongoing education, attending conferences, and reading specialist media.

Skills

Action Planning, Business Requirements Analysis, Computer Literacy, Database Administration, Database Reporting, Data Compilation, Data Controls, Data Management, Data Modeling, Executing Plans, Gaps Analysis, Information Technology (IT) Support, IT Architecture, IT Implementation, IT Network Security, Market Analysis, Test Case Management, User Requirements Documentation

Competencies

Action Oriented

Business Insight

Cultivates Innovation

Drives Engagement

Drives Results

Manages Ambiguity

Manages Complexity

Optimizes Work Processes

Education

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

Closing Date

23 December 2024 , 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.

Old Mutual Limited is pro-vaccination and encourages its workforce to be fully vaccinated against Covid-19.

All prospective employees are required to disclose their vaccination status as part of the recruitment process.

Please refer to the Old Mutual’s Covid-19 vaccination policy for further detail. Kindly note that Old Mutual reserves the right to reinstate the requirement to vaccinate at any point if it is of the view that it is imperative to do so.

The Old Mutual Story!