Business Intelligence Manager

Findojobs South Africa; Wes-Kaap; On-site; ZAR 600,000 - 800,000; Full time

Job summary

A leading job recruitment agency is seeking a Data Architect to design and maintain data architecture and BI solutions. This role requires over 5 years of experience in data integration and strong industry knowledge of FMCG and retail sectors. The ideal candidate will lead the development of dashboards and ensure data quality across all sources in a collaborative environment.

Qualifications

• 5+ years of experience in a similar role.
• Strong industry knowledge of FMCG and retail sectors.
• Advanced expertise in system integration and process automation.

Responsibilities

• Design, develop, and maintain data architecture and BI solutions.
• Ensure data quality, security, and availability across all sources.
• Lead the development of dashboards and analytics for reporting.

Skills

Data architecture

ETL pipelines

SQL Server administration

Power BI

Data integration

Cloud databases

REST APIs

Education

IT degree or relevant qualifications

Tools

SQL Server

Microsoft Fabric

Power Platform

Job description

Responsibilities (but not limited to):

• Design, develop, and maintain data architecture, data warehouses, and BI solutions.
• Ensure data quality, security, and availability across all sources.
• Optimize performance of data pipelines, reports, and visualizations.
• Lead the development of dashboards, analytics, and data models for operational and financial reporting.
• Collaborate with stakeholders to translate business needs into actionable insights.
• Manage data integration jobs and ensure timely, verified data loads.
• Oversee deployment, testing, and support of BI systems and infrastructure.
• Provide technical leadership and troubleshoot system issues.
• Maintain strong collaboration with infrastructure teams to ensure scalability and security.
• Extensive expertise in data warehousing, ETL pipelines, and the Microsoft BI stack.
• Proficient in SQL Server administration, including SSIS, SSRS, and SSAS.
• Advanced skills in Power BI, Microsoft Fabric, DAX, T-SQL, and the Power Platform.
• Experience with cloud-based databases such as Azure SQL and AWS RDS is advantageous.
• Strong working knowledge of REST APIs, OData, JSON, XML, and Microsoft Excel.
• Industry experience in FMCG or retail environments is considered a strong asset.

What You Bring to the Table:

• 5+ years of experience in a similar role.
• IT degree or relevant qualifications.
• Strong industry knowledge of the FMCG, retail, and/or hospitality sectors.
• Proficient understanding of e-commerce ecosystems and point-of-sale (POS) platforms.
• Experience working with management information systems (MIS) to support operational and strategic decision-making.
• Advanced expertise in system integration, process automation, and AI technologies, with a focus on leveraging these tools to deliver scalable business solutions.
• Demonstrated ability to design, implement, and maintain SSIS packages, SSRS reports, and data models to support enterprise reporting and analytics.

***Only shortlisted candidates will be contacted***