Senior Data Engineer

Senior Data Engineer job vacancy in Cape Town.

PBT Group is seeking an experienced Senior Data Engineer to strengthen its data platform and analytics capabilities. This role is suited to a hands‑on, technically strong engineer with deep experience in data warehousing, SQL-based transformations, and modern cloud data stacks.

The successful candidate will play a key role in designing, building, and optimising scalable data pipelines and warehouse solutions that support enterprise analytics, reporting, and business decision‑making.

Duties and Responsibilities:

• Design, develop, and maintain enterprise‑grade data warehouse solutions
• Build and optimise data transformation pipelines using DBT
• Develop complex, high-performance SQL queries and models
• Work extensively with Snowflake and legacy platforms such as Sybase IQ
• Develop and maintain data pipelines using Python
• Implement data engineering best practices including version control, testing, and documentation
• Collaborate with analytics, BI, and business teams to support reporting and insights
• Contribute to CI/CD processes using Azure Dev Ops / Git
• Ensure data quality, performance, and reliability across the data platform

Minimum Requirements:

Experience:

• 7+ years’ experience in Data Engineering or related roles
• Strong background in Data Warehousing and dimensional modelling
• Proven experience working in enterprise‑scale data environments

Technical

Skills:

Strong hands‑on experience with:

• SQL (advanced query development and optimisation)
• DBT (models, testing, documentation, and deployment)
• Snowflake (data modelling, performance tuning)
• Sybase IQ (or similar large‑scale analytical databases)
• Python (ETL, data processing, automation)
• Azure Dev Ops / Git (source control, CI/CD pipelines)

Preferred Experience:

• Cloud-based data platforms (Azure preferred)
• Experience supporting BI and analytics teams
• Exposure to modern data engineering patterns and architectures
• Financial services or insurance industry experience

Key

Competencies:

• Strong problem‑solving and analytical skills
• Ability to work hands‑on and independently
• Excellent collaboration with cross‑functional teams
• Attention to detail and data quality
• Delivery-focused with a continuous improvement mindset

Ideal Candidate Profile:

The ideal candidate is a senior, technically capable Data Engineer who:

• Is comfortable working across modern and legacy data platforms
• Has deep SQL and data modelling expertise
• Enjoys building robust, scalable data solutions
• Can operate effectively in complex enterprise environments