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) and travelling to our Retail Stores and Manufacturing Plants in Heidelberg and Estcourt will, from time to time, be required. The Job Purpose will be to take guided ownership in the design and modification of business intelligence and MIS systems.

The Data Analyst will interact with the business stakeholders and subject matter experts in order to understand business problems, needs and produce business intelligence 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 Year Experience in a BI environment
Knowledge of Meat Matrix system will be an added advantage.
Understanding of SQL data base concepts and ODBC Data connections

Skills:

Ability to work under pressure and meet tight deadlines.
Ability to work as part of a team.
Excellent report-writing, communication, and IT skills
Excellent analytical and reasoning skills,
Knowledge of ERP and accounting systems.
Proficient in MS SQL.
Proficient With Microsoft 365 Suite.

Job Activities:

1. Master File Maintenance

Managing users and user roles.
Managing master data, including creation, updates, and deletion.
Commissioning and decommissioning of data sets.

2. Building and Maintaining Dashboards & Reports

Designing the reporting environment, including data sources, security, and metadata.
Supporting initiatives for data integrity and normalization.
Troubleshooting the reporting database environment and reports.
Compilation and distribution of reports to users and management.
Assistance with pricing models, margin reports, cost trends to the Sales Department.
Analyze the data collected and log a detailed record of the results.
Training end-users on new reports and dashboards.

3. Data and Financial Analysis

Conduct ongoing process constraint analyses.
Report on breakeven points by products, work centres, and factories.
Report on margins by product and division.
Perform cost accumulation tasks as a member of the target costing group.
Developing and maintaining databases, data systems, and data pipelines.
Analyze large amounts of information to discover trends and patterns.

4. Undertaking data collection, pre-processing, and analysis

Acquiring data from primary or secondary data sources and maintaining databases.
Provide quality assurance of imported data, working with quality assurance analysts if necessary.
Provide management with reports that specify and compare factors that affect prices and profitability of products or services.
Present information using data visualization techniques.
Creating reports and presentations for business use.
Provide rapid feedback and insight on ad-hoc requests.

5. Collaborate with development team

Working with programmers, engineers, and management heads to identify process improvement opportunities, propose system modifications, and devise data governance strategies.

6. Assist in Audits
7. Determine tasks that can be automated