BI Analytics and Solutions Engineer - Cape Town

International FMCG Retailer is seeking to employ an experienced BI Solutions engineer to join their ever growing team

Position Purpose

The BI Analytics & Solutions Engineer is responsible for owning, designing, and evolving end-to-end business intelligence solutions across the organization. This role goes beyond report building and focuses on architecting scalable, reliable, and trusted BI solutions across the full BI ecosystem.

The role requires a holistic understanding of the BI stackfrom source systems and data transformation, through automation and semantic modelling, to reporting platforms and business consumption.

Key Responsibilities

• Own BI solutions across the full lifecycle: Source systems, Automation, data transformation & reporting.
• Primary BI owner for South Africa, managing and resolving BI-related issues impacting local users and aligning with global requirements and recommendations on systems and reporting guidelines.
• Design, build, and maintain Power BI datasets, reports, workspaces and apps
• SAP Analytics Cloud (SAC) Development
• o Design and maintain SAC stories, templates, and landing pages
• o Create and manage live models from BW queries
• Contribute to the evolution of SAP‑based analytics architecture, including SAP BW, SAP Analytics Cloud, and SAP Datasphere, in line with the Group roadmap
• Support the transition from legacy SAP BW‑centric reporting to modern, cloud‑based analytics models where applicable
• Implement scalable transformations in SQL where appropriate
• Build, maintain, and troubleshoot Power Automate flows
• Act as internal business partner on the development and rollout of new reporting and analytical requirements across Sales, Marketing, Supply chain and Finance.

Knowledge, Skills & Experience

• Minimum of 3-5 years experience in BI analytics or similar role
• Relevant degree in Software Engineering or Information Technology.
• Experience with SAP analytics Cloud (JavaScript-based SAC scripting)
• Exposure to, or an understanding of, SAP Datasphere or modern cloud data platforms would be advantageous
• Strong experience in Power BI, SQL and Power automate
• Strong MS office skills
• High caliber of professional interpersonal skills, with excellent analytical, conceptual, and communication skills (both oral and written)

Personal Characteristics:

• Performance driven, tenacious and goal orientated
• Strong communication and networking skills
• Strong internal influencing skills
• Innovative problem-solving ability and can facilitate change
• Able to lead cross functional teams both internally and externally
• Project-management experience capable of managing numerous projects at once in a high-paced environment
• Ability to think outside the box when searching for solutions to problems
• Highly numerate with excellent analytical skills and attention to detail
• Able to set priorities and clear targets
• High degree of flexibility
• Able to grow with the level of responsibilities and with the size and structure of the business