Data Engineer

TFG; Wes-Kaap; On-site; ZAR 900,000 - 1,200,000; Full time

Job summary

TFG is seeking a Data Engineer IV to lead the design, implementation and maintenance of advanced data pipelines that form the company’s data platform. You will enable data-driven decisions by delivering batch and streaming processing, data warehouses, dashboards, and AI-enabled analytics.

You will collaborate with stakeholder teams to define reporting requirements, build scalable solutions, and drive digital transformation across Group Risk and Assurance.

Qualifications

• Bachelor’s degree in CS, Informatics, Statistics, or related field.
• 3+ years’ experience in Data Analytics/BI or similar environment.
• Strong storytelling and presentation capabilities.
• Experience in analysing and interpreting large datasets.

Responsibilities

• Assist business teams with operational metrics, dashboards, and reporting.
• Design and develop interactive visualisations using reporting tools.
• Provide ad hoc reporting, data analysis and decision-support insights.
• Develop and implement improved analytical methods and models.
• Analyse historical data to identify trends for strategic decisions.
• Develop, test and maintain predictive analytic models.
• ETL data from multiple sources into reporting platforms.
• Define reporting requirements with stakeholders and translate into scalable solutions.
• Establish standards for data development and AI model operation.

Skills

Power BI

SQL/NoSQL

Alteryx/SSIS

AI in audits

Predictive analytics

R/Python

Storytelling/Presentation

Education

Bachelor's degree in Computer Science / Informatics / Statistics / related field

Tools

Pyramid

SQL Server Integration Services (SSIS)

Power BI

Job description

Data Engineer

The Data Engineer IV is responsible for leading the design, implementation, and maintenance of advanced data pipelines that constitute TFG’s data platform, enabling effective use of data across the organisation. They create and manage robust, mission-critical batch and streaming data processing capabilities and enhance data marts and data warehouses. The Data Engineer also delivers data analytics, business intelligence and automation solutions that support Group Risk and Assurance activities and objectives.

• Assist business teams and management with operational metrics, dashboards, and reporting.
• Design and develop interactive visualisations using reporting and visualisation tools.
• Provide ad hoc reporting, data analysis and decision-support insights.
• Develop and implement improved analytical methods, models and solutions.
• Analyse historical data to identify trends and support strategic decision-making.
• Develop, test and maintain predictive analytical models.
• Extract, transform and load (ETL) data from multiple source systems into reporting and visualisation platforms.
• Perform detailed business analysis, defining “current state”, identifying problems, opportunities for improvement and solutions to support the achievement of the digital transformation strategy.
• Provide technical recommendations on solutions to problems.
• Validate the accuracy, completeness and integrity of data used in analytical solutions.
• Engage with stakeholders to define reporting requirements and translate business needs into scalable analytical solutions.
• Establish and govern standards applicable to the development and operation of data into AI models ensuring persistence and repeatability.

• 3+ years' experience in a Data Analytics, Business Intelligence, or similar environment.
• A bachelor’s degree in computer science, Informatics, Statistics, Accountancy, or a related field.
• Strong storytelling and presentation capabilities.
• Experience in analysing and interpreting large and complex datasets.
• Ability to create data models from disparate data sources.
• Sound knowledge of data warehousing concepts, architectures and processes.
• Ability to work independently, manage competing priorities and deliver outputs within agreed timelines.
• Strong analytical, critical-thinking and problem-solving capabilities.
• Ability to communicate complex technical and analytical concepts to stakeholders at operational, management and executive levels.

Skills

• Power BI and/or Pyramid.
• SQL and NoSQL technologies.
• Experience with Alteryx and/or SQL Server Integration Services.
• Experience in leveraging and applying AI technology across all phases of audit projects leveraging MCP.
• Predictive and prescriptive analytics.
• Experience with R and/or Python (advantageous).

Behaviours

• Ensures Accountability - takes accountability and ensures others are held to account on agreed upon performance targets
• Manages Complexity - interprets and simplifies complex and contradictory information when resolving organisational problems
• Plans and Aligns - develops plans and prioritises initiatives that align to the organisational goals and objectives
• Optimizes Work Processes - assesses and improves the efficiency, effectiveness, and quality of various work processes
• Organizational savvy - understands and navigates dynamics created by processes, systems, and people

Preference will be given but not limited to candidates from designated groups in terms of the Employment Equity Act.