Job Description

Position summary
Industry: FMCG & Supply Management
Job category: FMCG, Retail, Wholesale and Supply Chain
Location: Cape Town
Contract: Permanent
Remuneration: Market Related
EE position: No
Introduction
The Engineer: Business Analyst plays a key role in partnering with business stakeholders to understand, document, and translate their data, reporting, and analytical needs into scalable, engineering-led solutions. This role works closely with data architects and data engineers to ensure that data models, integrations, and reporting frameworks align with business processes and operational needs. By enabling structured, well-defined requirements, the Engineer: Business Analyst helps to deliver robust, data-driven solutions that improve business decision-making and efficiency.
Job description

• Engage with business users to gather, document, and validate their data, reporting, and analytical requirements.
• Collaborate with data architects and engineers to design efficient and scalable data solutions that support business processes.
• Translate business needs into technical specifications, ensuring alignment with data models, source-to-target mappings, and ETL/ELT processes.
• Support the development and implementation of data-driven solutions, including cloud-based BI dashboards and structured reports.
• Perform functional testing and data validation before solutions are deployed to business users.
• Assist business stakeholders during user acceptance testing (UAT) to ensure solutions meet expectations.
• Ensure consistency in reporting metrics and data definitions, reducing ambiguity in business reporting.
• Provide training and user support to enable business teams to effectively use reporting tools and cloud-based data solutions.
• Provide input into data governance initiatives, including metadata management, data lineage, and data quality improvements.
• Support business teams in maintaining high standards for data accuracy and consistency.
• Identify and support automation opportunities, reducing reliance on manual processes and increasing efficiency.
• Stay up to date with industry trends, continuously improving engagement models and reporting frameworks.

Minimum requirements

• Bachelor's degree in Data Analytics, Information Systems, Computer Science, Business, or a related field.
• Minimum 5 years of experience in a Business Analysis-related role, with at least 3 years in a data, analytics, or cloud-based reporting environment.
• Strong knowledge of Business Analysis techniques and methodologies, including requirements gathering, process modeling, stakeholder management, and impact assessment.
• Experience working in data and reporting environments, collaborating with data architects, data engineers, and business teams.
• Familiarity with the retail industry and business processes, understanding how data, reporting, and cloud solutions support operations and decision-making.
• Hands-on experience with SQL, structured reporting, and visualization tools (Power BI, QlikSense, QuickSight, SSRS).
• Strong understanding of data warehouse best practices, including star schema, dimensional modeling, and ETL/ELT processes.
• Experience working with AWS, Azure, or Google Cloud data platforms, including S3, Redshift, and data lakes.
• Ability to create functional and technical specifications for data and reporting solutions.
• Awareness of metadata management, data lineage tracking, and data security best practices.
• Ability to work within structured methodologies for cloud-driven, scalable data architecture, integration, and reporting.

ADDITIONAL CRITERIA

• Business Acumen: Ability to understand business processes and how cloud-based data solutions enhance operations.
• Collaboration & Communication: Strong engagement skills to work with business, IT, and cloud/data teams.
• Problem-Solving: Ability to troubleshoot reporting issues, resolve data inconsistencies, and improve processes.
• Attention to Detail: Ensures the accuracy and reliability of data insights presented to stakeholders.

Adaptability & Continuous Learning: Keeps up with emerging trends in cloud, data lakes, and analytics technologies.