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