Lead Data Engineer (12 Month Contract) Mmh250512-5

Momentum; Gauteng; On-site; ZAR 800 000 - 1 200 000; Full time

Job summary

Momentum Investments is seeking a Lead Data Engineer to drive data engineering initiatives. This role involves designing and optimizing data solutions, leading a team of SQL developers, and ensuring high-quality data infrastructure. Ideal candidates will have extensive experience in SQL, Python, and data engineering, with strong leadership and communication skills.

Qualifications

• Minimum 8 years of experience in data engineering/SQL development.
• At least 3 years in a leadership role.
• Expertise in SQL & Python development.

Responsibilities

• Lead and mentor SQL warehouse developers.
• Manage KPIs and delivery timelines.
• Design scalable data pipelines and infrastructure.

Skills

SQL Development

Python

Data Engineering

ETL Processes

Problem Solving

Communication

Education

Bachelor's degree in Computer Science or Engineering

Tools

SQL Server

Oracle

PostgreSQL

SSIS

AWS Glue

Informatica

Talend

Job description

Role Purpose

As the Lead Data Engineer at Momentum Investments, you will play a pivotal role in driving our data engineering initiatives forward.

You will be responsible for designing, developing, and optimizing our data warehouse solutions. Additionally, you will serve as the technical lead of the SQL Data engineering team, overseeing skilled SQL developers to implement robust data models, ETL processes, data infrastructure, pipelines, and reporting solutions that support data-driven decision-making.

Requirements

• Bachelor's degree in computer science, Engineering, or a related field.
• Minimum of 8 years of experience in data engineering / SQL development roles.
• At least 3 years in a leadership role managing performance, technical development, and delivery of developers, with a successful track record in data engineering projects.
• Over 8 years of hands-on SQL development experience, including warehouse, data lake, or data vault development using SSIS, Python, and SQL Transact.
• Minimum 6 years of Python experience for data processing, automation, and ETL / ELT pipelines.
• Expertise in SQL & Python development, query optimization, and performance tuning.
• Proficiency in database technologies such as SQL Server, Oracle, and PostgreSQL.
• Hands-on experience with ETL tools like SSIS; experience with AWS data tools (Glue, Parquet) and ETL tools like Informatica or Talend is advantageous.
• Knowledge of big data technologies (Hadoop, Spark, Kafka) and languages (C#, Java, Scala) is advantageous.
• Certifications in cloud platforms (e.g., AWS Certified Data Analytics) are a plus.
• Strong problem-solving skills, attention to detail, and ability to deliver high-quality solutions.
• Effective communication skills to articulate technical concepts to non-technical stakeholders.
• Proven leadership and mentoring abilities to guide and develop teams.

Duties and Responsibilities

• Lead and mentor SQL warehouse developers in designing, developing, and maintaining data solutions.
• Manage KPIs, technical performance, capacity, and delivery timelines of the data team.
• Develop team skills through training, planning interventions, and monitoring personal development plans.
• Collaborate with stakeholders to translate business requirements into technical solutions.
• Perform SQL backend development, including data architecture design and implementation.
• Design scalable data pipelines and infrastructure, optimizing for performance and reliability.
• Automate deployment processes using GitLab CI / CD.
• Enforce coding standards, best practices, and quality assurance.
• Research emerging technologies to enhance data engineering capabilities.
• Stay updated on industry trends and contribute strategic insights.
• Provide technical guidance and foster a culture of continuous learning.

Additional Details

Seniority level: Mid-Senior level

Employment type: Contract

Job function: Information Technology