Data Engineer (ETL & Data Modelling)

About

The Data Engineer (ETL & Data Modeller) is responsible for designing, developing, and maintaining scalable data pipelines and robust data models to support enterprise reporting, analytics, and operational systems. The role requires strong expertise in data integration, transformation, and data architecture, ensuring high data quality, integrity, and availability across platforms.

Key Responsibilities

• Design, develop, and maintain ETL (Extract, Transform, Load) processes to integrate data from multiple sources.
• Build and optimize data pipelines for efficient data processing and transformation.
• Develop conceptual, logical, and physical data models aligned with business requirements.
• Ensure data accuracy, consistency, and integrity through data validation and quality checks.
• Work closely with business analysts, data scientists, and stakeholders to translate business needs into technical data solutions.
• Optimize database performance through indexing, partitioning, and query tuning.
• Implement data governance, security, and compliance standards.
• Support data warehousing solutions and reporting platforms.
• Troubleshoot and resolve data‑related issues promptly.

Required Experience

• Minimum of 7 years’ experience in Data Engineering, ETL development, and Data Modelling.
• Proven experience with ETL tools (e.g., Informatica, SSIS, Talend, or similar).
• Strong experience in SQL and database technologies (e.g., Oracle, SQL Server, PostgreSQL).
• Experience in data warehousing concepts (e.g., star schema, snowflake schema).
• Familiarity with cloud data platforms (e.g., AWS, Azure, or Google Cloud) is advantageous.
• Experience with big data technologies (e.g., Hadoop, Spark) is an added advantage.

Minimum Qualifications

Must hold at least one of the following qualifications at NQF Level 7:

• Bachelor’s Degree (BSc / BCom / BEng)
• Advanced Diploma
• BTech

In one or more of the following fields:

• Computer Science
• Information Technology
• Information Systems
• Data Science / Data Analytics / Data Management
• Informatics / Computer Studies
• Electrical / Electronic / Computer Engineering

Key Competencies

• Strong analytical and problem‑solving skills
• Attention to detail and data accuracy
• Ability to work in cross‑functional teams
• Strong communication and stakeholder engagement skills
• Ability to work under pressure and meet deadlines