Data Engineer at Hollard Insurance

Role Objectives:

• Design, develop and maintain data engineering processes to extract, transform and load data from primarily off-platform sources. Ensure reliable, high-quality data availability for reporting and data analysis by applying appropriate technologies, standards and governance.

Key Responsibilities:

Data engineering delivery

• Design ETL processes, pipelines and scripts aligned to best practices
• Develop and maintain data extraction and transformation logic
• Maintain ETL architecture and data flow across systems
• Validate data integrity and implement validation routines

Data modelling and architecture

• Translate business requirements into data models
• Develop conceptual, logical and physical data models
• Apply OLTP and organisational standards in design
• Recommend reuse and optimisation of data models

Data platforms and database management

• Design and maintain databases and data structures
• Create database objects (tables, views, stored procedures, triggers)
• Maintain database documentation and standards compliance
• Manage data security, access and user permissions with DBAs

Cloud data engineering

• Develop data workloads using Azure and Microsoft Fabric
• Support cloud migration initiatives and pipeline refactoring
• Test and validate migrated data solutions
• Identify and escalate cloud optimisation opportunities

Operational support and data quality

• Monitor and resolve production data issues
• Conduct root cause analysis for data and system issues
• Ensure logging, alerting and scheduling of data jobs
• Maintain high-quality production deployments

Required Knowledge and Experience    
Experience:

• 3–5 years in data engineering or BI environments
• 2–3 years ETL development experience
• 1–2 years cloud data platform experience (Azure / Fabric)
• Experience with SQL and relational database design
• Experience supporting production data pipelines

Key Measurements of Outputs

• Quality and reliability of data pipelines and ETL processes
• Accuracy and integrity of delivered data
• Timeliness of data availability and delivery against SLAs
• Reduction in production incidents and data errors
• Successful delivery of cloud migration components
• Stakeholder satisfaction and responsiveness

Technical Competencies

• ETL design and development (SSIS, SQL Server)
• SQL development (DDL, DML, T-SQL)
• Data modelling and database design
• Azure and Microsoft Fabric data services
• Data warehouse and data mart design

Behavioural Competencies

• Analytical thinking and problem solving
• Attention to detail and accuracy
• Accountability and ownership
• Stakeholder communication
• Teamwork and collaboration

Educational Requirements    
Minimum Qualifications:

• Matric / Grade 12
• National diploma or bachelor’s degree in IT, Computer Science, Informatics, Engineering or related field
• BI certification (advantageous)

Deadline:28th May,2026