Data Analyst

ExecutivePlacements.com - The JOB Portal; Pretoria; On-site; ZAR 300,000 - 400,000; Full time

Job summary

A leading FMCG company is seeking a Data Analyst to design and modify business intelligence systems. This role involves creating dashboards and analytical solutions while collaborating with stakeholders. Candidates should have a degree in a relevant field and proficiency in SQL and BI tools. The role offers an exciting opportunity for career growth in a dynamic environment.

Qualifications

• 1-3 years of experience in a BI environment.
• Knowledge of Meat Matrix system is an advantage.
• Understanding of SQL database concepts and ODBC data connections.

Responsibilities

• Building and maintaining dashboards & reports.
• Data collection, pre-processing, and analysis.
• Analyzing large data sets for trends and patterns.

Skills

Ability to work under pressure

Teamwork skills

Excellent report-writing

Strong analytical skills

Proficiency in MS SQL

Proficiency with Microsoft 365 Suite

Education

Undergraduate degree in Computer Science, Statistics, Mathematics, or related fields

Tools

SQL querying

BI software (preferably Qlik)

Job description

Data Analyst

Recruiter: Eskort

Job Ref: Ire000032/EE

Date posted: Friday, June 27, 2025

Location: Irene, South Africa

Summary: Data Analyst - FMCG

Position Info: An exciting opportunity exists for a Data Analyst to join our company! This position is mainly based in Irene (Centurion), with occasional travel to our retail stores and manufacturing plants in Heidelberg and Estcourt.

The job purpose is to take guided ownership in designing and modifying business intelligence and MIS systems. The Data Analyst will interact with business stakeholders and subject matter experts to understand business problems and needs, producing dashboards and analytical solutions.

Qualifications:

• Undergraduate degree in Computer Science, Statistics, Mathematics, or related fields.
• SQL querying, BI software (preferably Qlik), and advanced Microsoft Office skills.

Experience & Knowledge:

• 1-3 years of experience in a BI environment.
• Knowledge of Meat Matrix system is an advantage.
• Understanding of SQL database concepts and ODBC data connections.

Skills:

• Ability to work under pressure and meet deadlines.
• Teamwork skills.
• Excellent report-writing, communication, and IT skills.
• Strong analytical and reasoning skills.
• Knowledge of ERP and accounting systems.
• Proficiency in MS SQL.
• Proficiency with Microsoft 365 Suite.

Job Activities:

1. Building and maintaining dashboards & reports.
2. Data and financial analysis.
3. Data collection, pre-processing, and analysis.
4. Collaborate with development team.
5. Assist in audits.
6. Master file maintenance.
7. Managing users and roles.
8. Managing master data, including creation, updates, and deletion.
9. Commissioning and decommissioning data sets.
10. Designing reporting environment, including data sources, security, and metadata.
11. Supporting data integrity and normalization initiatives.
12. Troubleshooting reporting database environment and reports.
13. Reporting and distribution of reports to users and management.
14. Assisting with pricing models, margin reports, and cost trends.
15. Analyzing data and logging detailed results.
16. Training end-users on reports and dashboards.
17. Ongoing process constraint analysis.
18. Reporting on margins by product and division.
19. Cost accumulation tasks as part of target costing.
20. Developing and maintaining databases, data systems, and pipelines.
21. Analyzing large data sets for trends and patterns.
22. Acquiring data from primary/secondary sources and maintaining databases.
23. Quality assurance of imported data.
24. Providing management reports on factors affecting prices and profitability.
25. Presenting data visually.
26. Creating reports and presentations for business use.
27. Providing rapid feedback on ad-hoc requests.
28. Collaborating with programmers, engineers, and management to improve processes and data governance.
29. Identifying tasks suitable for automation.