BI Analyst (Durban)

Job category: Data Processing

Location: Durban

Contract: Permanent

Remuneration: Market Related

EE position: No

City Logistics understands supply chains and the importance of adding maximum value, as well as providing cost-effective solutions and the highest service levels.Our extensive network throughout Southern Africa has been developed over 30 years, offering an exclusive supply chain solution, specializing in client and fleet requirements.This typically consists of a dedicated pool of vehicles and staff customized to the client's operational needs, enabling the client to share the benefits of our procurement, maintenance and risk management capacity.We are passionate about what we do, passionate about Retail and service excellence.Let us be part of your solution.

We are seeking a passionate and skilled Data Analyst that will be responsible for analysing, interpreting and transforming data into meaningful insights that support strategic, tactical and operational decision making across the organisation. The role includes building and maintaining data models, analytical solutions and BI reports, ensuring data quality, and leveraging Azure Synapse Analytics and SQL to deliver high value analytics that align with business objectives.

YOUR CORE FOCUS AREAS:

Data Management & Analytics Execution

• Designs, builds and maintains datasets, pipelines and data models using Azure Synapse and SQL.
• Ensures data accuracy, consistency and availability for analytics and reporting.
• Troubleshoots data quality issues and implements corrective actions.
• Develops dashboards and BI reports that deliver actionable insights.
• Performs root-cause analysis on data anomalies and system issues.
• Ensures optimal performance of queries, stored procedures and analytic workloads.
• Documents data processes, models and metadata for reference and operational resilience.

• Defines acceptance criteria for each user story
• Participates in data and analytics projects from planning to implementation.
• Works with cross-functional teams to define data requirements.
• Conducts testing and validation of data pipelines and BI reports.
• Ensures all analytical solutions meet business needs and quality standards.
• Identifies opportunities to enhance data processes, performance and quality.
• Suggests improvements to data storage, modelling and reporting flows.
• Supports automation initiatives to streamline analytics operations

• Collaborates with business units to understand data needs and challenges.
• Translates business requirements into technical specifications.
• Provides training and support to users on BI tools and reports.
• Maintains relationships with internal and external partners involved in data initiatives.
• Maintains comprehensive documentation of all data models, pipelines and analytical solutions.
• Provides regular reporting on data quality, analytics performance and project progress.

• Bachelor's Degree (NQF level 7) in Information Technology / Computer Science
• Project Management / Agile Certification
• Formal qualifications in SQL/Microsoft Azure Data Solutions/Power BI/Data Analytics or Data engineering frameworks is ideal
• Professional membership with the Institute of Information Technology Professionals South Africa (IITPSA) will be advantageous
• 3 years' experience as a BI Analyst
• Strong hands-on experience in:
  Azure Synapse Analytics
  SQL (advanced querying, optimisation, stored procedures)
  Data modelling and ETL/ELT concepts
  BI development (Power BI)
• Proven experience delivering data insights and analytical solutions
• Demonstrable experience in handling large datasets and building robust analytical pipelines
• Experience within supply chain, logistics, or operational environments is ideal