Data Analyst

Eskort; Gauteng; On-site; ZAR 30 000 - 60 000; Full time

Job summary

An exciting opportunity awaits for a skilled Data Analyst to join a dynamic team in a forward-thinking company. This role involves designing and enhancing business intelligence systems while collaborating with stakeholders to address business needs. You will manage data, create insightful dashboards, and ensure data integrity, all while working in a fast-paced environment. If you possess strong analytical skills and a passion for data-driven decision-making, this position offers a chance to make a significant impact on the business's success. Join this innovative firm and contribute to exciting projects that shape the future of data analytics.

Qualifications

• 1-3 years of experience in a BI environment.
• Understanding of SQL database concepts and ODBC Data connections.

Responsibilities

• Design and modify business intelligence and MIS systems.
• Build and maintain dashboards and reports for management.
• Analyze collected data and document results for business use.

Skills

SQL querying

BI software (preferably Qlik)

Advanced Microsoft Office skills

Excellent report-writing skills

Strong analytical and reasoning skills

Teamwork skills

Ability to work under pressure

Education

Undergraduate degree in Computer Science

Undergraduate degree in Statistics

Undergraduate degree in Mathematics

Tools

MS SQL

Microsoft Suite

Meat Matrix system

Job description

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.

Job Purpose

Take guided ownership in designing and modifying business intelligence and MIS systems. Interact with business stakeholders and subject matter experts to understand business problems and needs, and produce 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 (advantageous)
• 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 and Microsoft Suite

Job Activities

1. Manage master files, users, and roles
2. Maintain master data and data sets
3. Build and maintain dashboards and reports
4. Design reporting environment with secure data sources
5. Support data integrity and normalization initiatives
6. Troubleshoot reporting database environment
7. Distribute reports to users and management
8. Assist with pricing models, margin reports, and cost trends
9. Analyze collected data and document results
10. Train end-users on reports and dashboards
11. Conduct ongoing process analyses
12. Report on margins and perform cost tasks
13. Develop and maintain databases and data pipelines
14. Discover trends and patterns in large data sets
15. Handle data collection, pre-processing, and analysis
16. Ensure data quality and provide management reports
17. Use data visualization for reporting
18. Prepare reports and presentations for business use
19. Respond quickly to ad-hoc data requests
20. Collaborate with development teams for system improvements
21. Assist in audits and identify automation opportunities