Data Analyst

People Dimension; Pretoria; On-site; ZAR 223,200 - 334,800; Full time

Job summary

A leading data analysis company in Pretoria is looking for a Data Analyst to manage master data and design reports and dashboards. Candidates should have an undergraduate degree in relevant fields and 1-3 years of experience in a BI environment, alongside strong SQL and BI software skills. This role demands the ability to work under pressure and effectively collaborate with teams to analyze and visualize data. Attractive opportunities for professional growth are available.

Qualifications

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

Responsibilities

• Manage users and master data, including creation, updates, and deletion.
• Design reporting environments, supporting data integrity and normalization.
• Analyze large amounts of information to discover trends and patterns.
• Collaborate with teams to identify process improvements.

Skills

SQL querying

BI software (preferably Qlik)

Advanced Microsoft Office skills

Excellent report-writing skills

Excellent analytical and reasoning skills

Ability to work under pressure

Teamwork capacity

Knowledge of ERP and accounting systems

Proficient in MS SQL

Proficient with Microsoft 365 Suite

Education

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

Job description

Duties & Responsibilities

Key Responsibilities

Master File Maintenance

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

Building and maintaining dashboards and 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.
• Providing technical expertise in data storage structures, data mining, and data cleansing.

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.

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 uses.
• Provide rapid feedback and insight on ad-hoc requests.

Assist in Audits

• Data investigations and anomaly detection in data.

Collaborate with development team

• 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

Desired Experience & Qualification

• Undergraduate degree in Computer Science, Statistics, Mathematics, or related fields
• SQL querying, BI software (preferably Qlik) and advanced Microsoft Office skills
• 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
• 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

Interested?

If you meet the requirements and would like to apply, please send your CV and available start date.

hr2 (at) peopledimension (dot) co (dot) za

Shortlisted applicants will be contacted within 2 weeks, if you do not hear from us by then your application for this position was unsuccessful, but you have been added to our database for future vacancies.