Microsoft SQL Data Engineer

PBT Group; Cape Town; On-site; ZAR 335,000 - 670,000; Full time

Benefits offered by this job

On-site work environment

Job summary

PBT Group in Cape Town seeks an experienced Microsoft SQL Data Engineer / ETL Developer to transform data into actionable insights for clients across Africa and beyond. The role focuses on end-to-end data acquisition, warehousing, and BI processes, with a strong emphasis on SSIS, SSRS, and SSAS capabilities.

The position offers a competitive monthly salary (R30,000–R60,000) and on-site work environment, with opportunities to mentor others and shape data solutions for diverse industries.

Qualifications

• Extensive MS SQL Data Engineering experience.
• Strong expertise in SSIS and SSRS.
• Proficiency in requirement analysis and database design.
• Knowledge of source systems and dimensional data models.
• Skilled in database and data warehouse modeling.
• Programming experience in relevant languages for data staging and ETL development.
• Deep understanding of SQL and ETL tool capabilities.
• A B.Sc. or related degree is advantageous.
• 2+ years of programming experience.
• Familiarity with SSAS and Data Engineering concepts.

Responsibilities

• Plan and analyse complex business requirements to design and implement technology-enabled solutions.
• Collaborate with cross-disciplinary teams in analysis, planning, and design activities.
• Develop, modify, and evaluate high-complexity programs in line with specifications.
• Conduct quality reviews and walkthroughs of deliverables.
• Design and develop end-to-end data acquisition processes for data warehouses and data marts.
• Provide guidance and mentorship in business intelligence systems and ETL processes.
• Establish and support standards for data acquisition development.
• Create and execute complex ETL routines ensuring compliance with policies and standards.

Skills

MS SQL Data Engineering

SSIS

SSRS

SQL

Dimensional data models

ETL development

Data staging

Database design

SSAS

Education

B.Sc. or related degree

Tools

SSAS

Job description

Microsoft SQL Data Engineer required in Cape Town.

Are you a seasoned data professional passionate about transforming complex data into actionable insights? Join a leading provider of end-to-end data solutions, renowned for delivering large-scale projects across Africa, the Middle East, Australia, and Europe.

We are seeking a dedicated Microsoft SQL Data Engineer / ETL Developer to help our clients harness their data assets effectively.

Salary: R30 000 to R60 000 per month.

Duties and Responsibilities:

• Plan and analyse complex business requirements to design and implement technology-enabled solutions.
• Collaborate with cross-disciplinary teams in analysis, planning, and design activities.
• Develop, modify, and evaluate high-complexity programs in line with specifications.
• Conduct quality reviews and walkthroughs of deliverables.
• Design and develop end-to-end data acquisition processes for data warehouses and data marts.
• Provide guidance and mentorship in business intelligence systems and ETL processes.
• Establish and support standards for data acquisition development.
• Create and execute complex ETL routines ensuring compliance with policies and standards.

Requirements:

• Extensive MS SQL Data Engineering experience.
• Strong expertise in SSIS and SSRS.
• Proficiency in requirement analysis and database design.
• Knowledge of source systems and dimensional data models.
• Skilled in database and data warehouse modeling.
• Programming experience in relevant languages for data staging and ETL development.
• Deep understanding of SQL and ETL tool capabilities.
• Attention to detail and pride in work.
• Relevant ETL and BI solution training.
• A B.Sc. or related degree is advantageous.
• 2+ years of programming experience.
• Familiarity with the following:
  • Server Analysis Services (SSAS)
  • Data Engineering

What We’ll Give You:

• Competitive salary ranging from R30,000 to R60,000 per month (Cost to Company) – Negotiable.
• The opportunity to work on impactful projects in a dynamic and growth-oriented environment.
• On-site work environment.