Data Analyst

Bright Placements; Pretoria; On-site; ZAR 350,000 - 600,000; Full time

Job summary

Bright Placements is seeking a Data Analyst for an FMCG environment in Pretoria. You will turn sales, stock, financial, customer and operational data into insights to improve profitability, forecasting, inventory and performance.

Key focus areas include Power BI dashboards, advanced Excel, SQL and data integrity, with collaboration across Sales, Marketing, Finance and Supply Chain to drive data-driven decisions.

Qualifications

• Essential: Grade 12 / Matric.
• Essential: Bachelor’s degree or diploma in Data Analytics / Data Science / Statistics / Mathematics / Business Analytics / IT / Finance / Economics / Supply Chain / Commerce or related field.
• Essential: 2-4 years' experience in data analysis, reporting, BI or similar role.
• FMCG, retail, manufacturing or supply-chain experience highly advantageous.
• Advanced Microsoft Excel skills.
• Strong Power BI experience.
• Working knowledge of SQL and relational databases.

Responsibilities

• Collect, analyse and interpret large datasets from multiple sources.
• Analyse sales, revenue, margins, pricing and product performance.
• Identify trends, patterns, variances and opportunities.
• Prepare daily, weekly and monthly management reports.
• Develop and maintain interactive Power BI dashboards and reporting tools.
• Provide ad-hoc analysis and reports as requested by management.
• Analyse sell-in and sell-out performance across customers, channels and regions.
• Monitor SKU/product performance and identify slow-moving or underperforming products.
• Analyse promotional effectiveness and return on investment.
• Track sales targets, market performance, margins and profitability.
• Provide insights to Sales, Marketing, Finance and Category Management teams.

Skills

Advanced Excel

Power BI

SQL

Data analysis

Commercial analysis

Education

Bachelor's degree or diploma in Data Analytics

Statistics

Mathematics

Commerce or related field

Information Systems / IT

Economics

Supply Chain Management

Tools

Power Query

Power Pivot

ETL tools

Python or VBA

ERP systems (SAP/Oracle)

Job description

A Data Analyst in an FMCG environment is responsible for turning sales, stock, financial, customer and operational data into actionable insights that help management improve profitability, forecasting, inventory and business performance. Current FMCG roles in Pretoria commonly emphasise Power BI, advanced Excel, SQL, dashboards, data integrity and commercial analysis.

Key Duties and Responsibilities

Data Analysis & Reporting

• Collect, analyse and interpret large datasets from multiple sources.
• Analyse sales, revenue, margins, pricing and product performance.
• Identify trends, patterns, variances and opportunities.
• Prepare daily, weekly and monthly management reports.
• Develop and maintain interactive Power BI dashboards and reporting tools.
• Provide ad-hoc analysis and reports as requested by management.
• Analyse sell-in and sell-out performance across customers, channels and regions.
• Monitor SKU/product performance and identify slow-moving or underperforming products.
• Analyse promotional effectiveness and return on investment.
• Track sales targets, market performance, margins and profitability.
• Provide insights to Sales, Marketing, Finance and Category Management teams.

Stock & Supply Chain Analysis

• Monitor stock levels, stock movement and product availability.
• Identify potential overstocking, stock-outs and slow-moving inventory.
• Assist with demand forecasting and inventory planning.
• Analyse historical sales, seasonality and market trends to support forecasts.
• Monitor supply-chain KPIs such as fill rate, delivery performance and OTIF where applicable.

Data Management

• Extract, clean, validate and transform data from ERP, SQL databases and other systems.
• Ensure accuracy, consistency and integrity of business data.
• Investigate discrepancies and data-quality issues.
• Maintain data models, reporting databases and automated reporting processes.
• Improve and automate repetitive reporting processes using Excel, Power Query, Power BI or SQL.

Business Intelligence & Decision Support

• Translate business requirements into analytical solutions.
• Identify opportunities for improved efficiency, cost reduction and profitability.
• Provide data-driven recommendations to management.
• Present findings clearly to both technical and non-technical stakeholders.
• Work closely with Sales, Marketing, Finance, Procurement, Operations, Supply Chain and IT.

Qualifications

Essential:

• Grade 12 / Matric.
• Bachelor's degree or diploma in one of the following:
• Data Analytics
• Data Science
• Statistics
• Mathematics
• Business Analytics
• Information Systems / IT
• Finance
• Economics
• Supply Chain Management
• Commerce or a related field.
• 2-4 years' experience in data analysis, reporting, business intelligence or a similar role.
• FMCG, retail, manufacturing or supply-chain experience highly advantageous.
• Advanced Microsoft Excel skills.
• Strong Power BI experience.
• Working knowledge of SQL and relational databases.

Advantageous Experience

• SAP, Oracle, Microsoft Dynamics or another ERP system.
• Power Query and Power Pivot.
• Python or VBA.
• Experience with ETL/data pipelines.
• Experience with demand forecasting and inventory analysis.
• Knowledge of FMCG concepts such as SKU, sell-in, sell-out, ROS, gross margin, promotions, stock availability and OTIF.
• Excellent analytical and numerical ability.
• Strong attention to detail and accuracy.
• Excellent problem-solving skills.
• Strong commercial/business acumen.
• Ability to work with large datasets.
• Ability to identify trends and convert data into practical recommendations.
• Strong communication and presentation skills.
• Ability to explain complex information to non-technical stakeholders.
• Good organisational and time-management skills.
• Ability to work under pressure and meet reporting deadlines.
• Proactive, inquisitive and solutions-oriented.
• Strong team player with the ability to work across departments.

Ideal Candidate Profile

2-4+ years' experience | FMCG/Retail experience | Advanced Excel | Power BI | SQL | Strong commercial and analytical skills