Senior Data Engineer

Tiger Brands; Randburg; On-site; ZAR 900,000 - 1,300,000; Full time

Job summary

Tiger Brands is seeking a Senior Data Engineer to design, develop, and optimize robust data pipelines and analytical data models supporting FMCG value chains. You will enable reporting, forecasting, and cross-functional analytics across the organization.

The role emphasizes data quality, scalable data warehousing with SQL Server/SSAS, and advanced Power BI dashboards. Collaboration with IT and business units is essential to drive insights and improve decision-making.

Qualifications

• Bachelor’s degree or higher in a related IT field.
• Experience with enterprise data platforms and data warehousing concepts.
• Strong knowledge of SQL Server, SSIS/SSAS, and Power BI.

Responsibilities

• Design, build, and maintain scalable ETL/ELT pipelines using SQL Server and SSIS.
• Develop integration solutions across ERP, supply chain systems, trade promotion systems, and partner data feeds.
• Implement automated testing, version control, and deployment using Azure DevOps Repos, Pipelines, Artifacts.
• Design and optimize star schemas, fact tables, and conformed dimensions in SQL Server and SSAS.
• Build and maintain SSAS Tabular models with partitioning and incremental refresh.
• Ensure data warehouse structures follow CI/CD standards using Azure DevOps.

Skills

SQL Server

SSIS

SSAS Tabular

Power BI

Azure DevOps

Data warehousing

Kimball

ETL/ELT

DevOps

Education

Bachelor’s degree in computer science, Information Systems or related field

Tools

Azure DevOps

SSIS

SSAS

Power BI

Job description

It's fun to work in a company where people truly BELIEVE in what they're doing!

The Senior Data Engineer is responsible for designing, developing, optimizing, and maintaining robust data pipelines and analytical data models that support the FMCG value chain. The role ensures reliable, high-quality data for reporting, planning, forecasting, supply chain visibility, commercial insights, and operational decision-making across the organization.

What You Will Do

Data Engineering & Integration

• Design, build, and maintain scalable ETL/ELT pipelines using SQL Server and SSIS, following DevOps-aligned development practices.
• Develop integration solutions across ERP, supply chain systems, trade promotion systems, and partner data feeds.
• Implement automated testing, version control, and deployment using Azure DevOps Repos, Pipelines, Artifacts.

Data Modelling & Warehousing

• Design and optimize star schemas, fact tables, and conformed dimensions in SQL Server and SSAS.
• Build and maintain SSAS Tabular models with proper partitioning, incremental refresh, and data security.
• Ensure data warehouse structures follow CI/CD standards using Azure DevOps for controlled releases.

Reporting & Analytics

• Prepare optimized datasets and enterprise-grade semantic models for Power BI.
• Deploy Power BI datasets and reports .
• Implement row-level security, model governance, and performance improvements.
• Design and maintain business-centric semantic layers (e.g., Power BI datasets, SSAS Tabular models) to enable consistent, self-service analytics.

Data Platform Operations

• Ensure SQL Server environment stability including indexes, jobs, backups, partitioning, and performance tuning.
• Develop automated deployment processes for SSIS packages, SSAS models, and SQL scripts using Azure DevOps CI/CD pipelines.
• Implement monitoring and alerting for data jobs with DevOps dashboards and automation tools.

Collaboration & Stakeholder Engagement

• Work closely with business units to understand FMCG data needs and translate them into scalable solutions.
• Participate in sprint planning, backlog refinement, and DevOps ceremonies.
• Mentor junior engineers on DevOps practices, coding standards, and best practices.

Operational Support

• Lead the operational support of data platforms, pipelines, and analytics solutions, ensuring high system availability and rapid incident resolution.
• Proactively monitor, troubleshoot, and resolve complex data job failures, performance bottlenecks, and user issues.
• Drive root cause analysis and implement long-term solutions to prevent recurring incidents.
• Oversee scheduled maintenance, upgrades, and deployments, coordinating with cross-functional teams to minimize business disruption.
• Develop and maintain comprehensive operational documentation and mentor team members in best practices for incident response and platform reliability.

What You Will Bring To The Table

• 10+ years as a Data Engineer in a complex enterprise environment.
• Expert in SQL Server (T-SQL, performance tuning, indexing, security).
• Strong hands-on experience with SSIS, including complex ETL packages and optimization.
• Strong ability with SSAS Tabular (Multidimensional advantageous).
• Advanced Power BI (DAX, modelling, enterprise dataset design).
• Proven experience using Azure DevOps including:
• Pipelines for automated builds, deployments, and releases.
• Automated package deployment for SSIS/SSAS/SQL.
• Strong understanding of data warehousing methodologies (Kimball).

Business and FMCG

• Deep understanding of FMCG processes including:
• Procurement & Raw Materials
• Manufacturing, BOMs & Production
• Warehousing, Inventory, and Logistics
• Trade Promotions & Commercial
• Product & Customer hierarchies
• Finance (COGS, GL)
• Ability to design and model datasets that serve cross-functional FMCG needs

Soft Skills

• Strong communication and influence skills across IT and business teams.
• Ability to troubleshoot complex data issues quickly.
• Structured documentation and governance mindset.
• Experience mentoring and guiding technical teams.
• Deadline-driven, highly organized, and able to manage multiple priorities while maintaining attention to detail.
• Demonstrates strong problem-solving skills and the ability to work independently or collaboratively to deliver results under pressure.

Advantageous

• ERP knowledge (Oracle EBS, SAP) in FMCG context
• Knowledge of MDM and data governance practices
• Previous experience on Oracle database in a data warehousing environment
• Previous experience with Strategy (MicroStrategy)

Qualifications

• Bachelor’s degree in computer science, Information Systems or related field.
• Microsoft certifications (SQL, Data Engineering, Power BI) beneficial.

Key Competencies

• Technical depth & hands-on engineering approach
• DevOps mindset with focus on automation
• Strong problem-solving & analytical capability
• Business acumen in FMCG environments
• Discipline in code quality, documentation, and governance
• Ability to work independently and lead technical initiatives

In accordance with the employment equity plan of Tiger Brands and its employment equity goals and targets, preference may be given, but is not limited, to candidates from under-represented designated groups.