Job description

Data Analyst - FMCG 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 Activities2. Building and Maintaining Dashboards & Reports3. Data and Financial Analysis4. Undertaking data collection, pre-processing, and analysis5. Collaborate with development team6. Assist in Audits

  • Master File Maintenance
  • Managing users and user roles.
  • Managing master data, including creation, updates, and deletion.
  • Commissioning and decommissioning of data sets.
  • 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.
  • 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.
  • 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.
  • Working with programmers, engineers, and management heads to identify process improvement opportunities, propose system modifications, and devise data governance strategies.
  • Determine tasks that can be automated

Please let the company know that you found this position on this Job Board as a way to support us, so we can keep posting cool jobs.