Senior Data Engineer — Scalable Pipelines & BI
Tiger Brands
An application made for this job — a tailored resume and cover letter that speak straight to the posting.
Job summary
Tiger Brands is seeking a Senior Data Engineer to design, build, and operate scalable data pipelines and analytical models for the FMCG value chain.
You will lead ETL/ELT processes in SQL Server/SSIS, implement CI/CD with Azure DevOps, and develop SSAS/Power BI semantic layers to enable enterprise-wide insights.
The role emphasizes data warehousing, governance, and collaboration with business units to drive reliable reporting and operations.
Qualifications
- 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).
- Pipelines for automated builds, deployments, and releases
- Automated package deployment for SSIS/SSAS/SQL
- Strong understanding of data warehousing methodologies (Kimball).
Responsibilities
- 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.
- 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.
- 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 to enable consistent, self-service analytics.
- 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.
- 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.
- Lead the operational support of data platforms, pipelines, and analytics solutions, ensuring high system availability and rapid incident resolution.
Skills
Education
Tools
Job description
Tiger Brands is seeking a Senior Data Engineer to design, build, and operate scalable data pipelines and analytical models for the FMCG value chain.
You will lead ETL/ELT processes in SQL Server/SSIS, implement CI/CD with Azure DevOps, and develop SSAS/Power BI semantic layers to enable enterprise-wide insights.
The role emphasizes data warehousing, governance, and collaboration with business units to drive reliable reporting and operations.
'/%3e%3cpath%20d='M101.744%2012.4726L102.894%2016.1947L99.0021%2013.2201L101.744%2012.4726ZM105.3%208.40937H100.488L99.0026%203.59473L97.5116%208.41047L92.7%208.40385L96.5965%2011.3834L95.1055%2016.1942L99.0021%2013.2196L101.408%2011.3834L105.3%208.40992V8.40937Z'%20fill='white'/%3e%3cdefs%3e%3clinearGradient%20id='paint0_linear_5593_1381'%20x1='90'%20y1='9.44471'%20x2='99'%20y2='9.44471'%20gradientUnits='userSpaceOnUse'%3e%3cstop%20stop-color='%2300AD70'/%3e%3cstop%20offset='0.998594'%20stop-color='%2300B67A'/%3e%3cstop%20offset='1'%20stop-color='%23DCDCE6'/%3e%3c/linearGradient%3e%3c/defs%3e%3c/svg%3e){kind=small}
