Data Analyst

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.