BI & Data Engineer - Logistics

The South African Breweries; Johannesburg; On-site; ZAR 30 000 - 60 000; Full time

Job summary

An established industry player is seeking a talented Business Intelligence Analyst to enhance their reporting and analytics capabilities. In this role, you will support the existing landscape of reports and develop automated dashboards using Power BI and other reporting tools. Your expertise in SQL, Python, and Databricks will be essential in transforming raw data into insightful knowledge. If you are passionate about data-driven decision-making and eager to make a significant impact within a dynamic environment, this opportunity is perfect for you. Join a forward-thinking company where your contributions will shape the future of business intelligence.

Qualifications

• Advanced proficiency in Reporting and Analytics Technologies SQL, Python, Databricks and PowerBI.
• Experience in FMCG and Logistics is beneficial.

Responsibilities

• Support existing landscape of reports and Month End processes for Global KPI reporting.
• Develop technical specifications from business needs and create dynamic dashboards using Power BI.

Skills

SQL

Power BI

Python

Databricks

TSQL

Power Query

MDX

DAX

Education

Relevant 3-year university degree in Logistics

Relevant 3-year university degree in Commerce

Relevant 3-year university degree in Engineering

Relevant 3-year university degree in Information Systems

Tools

Power BI

SSMS

Databricks

Job description

Job Location : Gauteng, Johannesburg Deadline : May 24, 2025 Quick Recommended Links

• Jobs by Location
• Job by industries

Key Roles and Responsibilities :

• Support existing landscape of reports
• Support Month End processes for Global KPI reporting
• Formulate automated reports and dashboards using Power BI and other reporting tools.
• Partner with and understand business requirements to set functional specifications for reporting applications.
• You should be familiar with SSMS and TSQL, Power Query, MDX, PowerBI, Databricks and DAX are just a few of the tools and systems on the MS SQL Server BI Stack.
• Exhibit a foundational understanding of database concepts such relational database architecture, multidimensional database design, and more
• Design data models that transform raw data into insightful knowledge by understanding business requirements in the context of BI.
• Develop technical specifications from business needs and choose a deadline for work completion.
• Make charts and data documentation that includes descriptions of the techniques, parameters, models, and relationships.
• Developing Power BI desktop to create dashboards, KPI scorecards, and visual reports.
• Establish row-level security on data and comprehend Power BI's application security layer models.
• Examine, comprehend, and study business needs as they relate to business intelligence.
• Design and map data models to transform raw data into insightful information.
• Create dynamic and eye-catching dashboards and reports using Power BI.
• Make necessary tactical and technological adjustments to enhance current business intelligence systems
• Integrate data, alter data, and connect to data sources for business intelligence.

Minimum Requirements :

• Relevant 3-year university degree in Logistics, Commerce, Engineering, Information Systems or related field
• Advanced proficiency in Reporting and Analytics Technologies SQL, Python, Databricks and PowerBI – Certifications beneficial
• Experience in an FMCG – Logistics experience beneficial