Senior BI and Data Engineer

Pedros; Durban; On-site; ZAR 800 000 - 1 200 000; Full time

Job summary

A retail organization in Durban is seeking an experienced Senior BI & Data Engineer to establish their Business Intelligence capability. This role involves designing data architectures, managing ETL pipelines, and creating BI dashboards. Ideal candidates will have 8–12 years of experience in BI or Data Engineering, strong SQL skills, and a relevant degree. The position ensures data governance and supports decision-making across the organization.

Qualifications

• 8–12 years’ experience in BI, Data Engineering, or related fields.
• 3 years in a senior or lead capacity with end-to-end BI responsibility.
• Certifications in SQL, BI Tools, or Data Architecture advantageous.
• Experience within retail or multi-outlet operational environments highly beneficial.
• Strong problem-solving ability.

Responsibilities

• Design and implement BI and data architecture.
• Manage ETL pipelines and integrate data from multiple systems.
• Create and maintain BI dashboards and reports.
• Establish data governance and standards.
• Collaborate with teams to improve reporting framework.

Skills

SQL proficiency

Data modeling

ETL development

Data orchestration

API integrations

BI tools

Analytical mindset

Communication skills

Education

Relevant tertiary qualification in Computer Science, Information Systems, or Data Engineering

Tools

Microsoft Fabric

Azure

Job description

Job Description

The Senior BI & Data Engineer will establish and lead the foundation of Pedros’ Business Intelligence (BI) capability. This hands‑on role is responsible for designing and implementing the data architecture, pipelines, and reporting systems that will enable accurate, scalable, and timely insights across the business. The incumbent will act as the custodian of all BI and reporting services, ensuring data accuracy, consistency, and governance across multiple departments, including Operations, Finance, HR, Marketing, and Supply Chain, to drive efficiency, performance visibility, and informed decision‑making throughout the organization.

Key Responsibilities

• Design and implement the core BI and data architecture (data warehouse, data lake, and data models) to serve as the business’s analytical foundation.
• Develop and manage ETL pipelines using API’s, SQL and JSON to integrate data from multiple operational systems and digital platforms.
• Support departmental KPIs by ensuring reporting is accurate, consistent, and aligned with business objectives across Operations, Finance, HR, and Marketing.
• Articulate and translate business data into clear, actionable insights that enable better decision‑making at both strategic and operational levels.
• Create, publish, and maintain BI dashboards, scorecards, and performance reports tailored to departmental and executive needs.
• Establish and maintain data governance, validation, and sanitization standards to ensure accuracy, reliability, and trust in all reports.
• Collaborate with cross‑functional teams to identify data gaps, define metrics, and continuously improve the reporting framework.
• Continuously evolve the data and reporting landscape to drive automation, efficiency, and scalability as the business grows.
• Propose and deploy fit‑for‑purpose BI tools and technologies, ensuring interoperability between systems and readiness for future cloud adoption.
• Serve as the technical authority and custodian of BI processes, ensuring compliance with data management standards and business priorities.
• Document all data processes, models, and governance practices for ongoing continuity and maturity development.

Requirements

• Minimum 8–12 years’ experience in BI, Data Engineering, or related fields.
• At least 3 years in a senior or lead capacity with end‑to‑end BI responsibility.
• Relevant tertiary qualification in Computer Science, Information Systems, Data Engineering, or similar.
• Certifications in SQL, BI Tools, or Data Architecture advantageous.
• Experience within retail, QSR, or multi‑outlet operational environments highly beneficial.
• Proven experience in designing and building BI or data platforms from the ground up.
• Advanced proficiency in SQL and data modelling for large transactional and operational datasets.
• Strong experience with ETL development, data orchestration, and API‑based integrations.
• Proficiency in BI tools (data modelling, dashboard design, report optimisation), platform agnostic.
• Experience working with both on‑prem and hybrid data environments (Microsoft Fabric, Azure, or equivalent).
• Deep understanding of data governance, validation, and quality assurance principles.
• Strong analytical mindset and problem‑solving ability.
• Excellent communication and documentation skills, able to translate business requirements into data solutions.

Apply