Superintendent Business And Data Analyst (Power Bi / Sql / It Systems / Integration / Change Ma[...]

Reference Number : MHU

Job Description:

Our client is a leading mining company with multiple operations across the country who require a Superintendent Business and Data Analyst. Some core duties include identifying problems, applying critical thinking together with business knowledge to provide information and reporting; assisting the different stakeholders in the entire systems value chain, ensuring that the strategic objectives are met; and assisting with compiling and tactical implementation of business specifications for functionality of IT systems for the design, change requests, and/or new system implementation.

Responsibilities:

1. Assist with implementation and project manage applicable systems changes to enhance the efficiency of the use of IT systems.
2. Propose system change requests and align them with business rules, specifications, and requirements.
3. Participate in the selection of IT system vendors where required.
4. Liaison between ICT and business where required.
5. Implement the business analysis approach and ensure it is aligned with the strategic drivers.
6. Engage with end users and stakeholders to understand reporting requirements and define the scope of reports.
7. Act as a liaison between stakeholders and other key role players to deliver analysis requirements or business system changes.
8. Extract, transform, and load data from multiple sources, including CSV files, SharePoint, Excel spreadsheets, Power BI datasets, BW, and AWS (Amazon Web Services).
9. Ensure data accuracy, completeness, and consistency during the integration process.
10. Assist and implement the use of analysis.
11. Ensure that business definitions for tables and master data are in line with business and continuously updated.
12. Ensure strategies are in place to continuously update master data to ensure appropriate, complete, and accurate master data.
13. Assist with data analysis for third-party use and public distribution.
14. Design, develop, and maintain relational databases.
15. Create database tables, indexes, views, and other database objects.
16. Ensure data integrity and performance in database structures.
17. Write efficient and optimized SQL queries for data retrieval, manipulation, and updates.
18. Debug and optimize existing SQL code for better performance.
19. Implement stored procedures, triggers, and functions as needed.
20. Develop technical designs for Power BI reports, including data models, calculations, relationships, and visualisations.
21. Utilise DAX (Data Analysis Expressions) for creating complex calculations and measures.
22. Design efficient and user-friendly report layouts and interactive dashboards.
23. Implement visualisations, interactive filters, slicers, and drill-through capabilities to provide an immersive user experience.
24. Design and implement dashboards and new technology as required.
25. Design and implement specifications for outcomes of business analysis.
26. Ensure the accuracy and reliability of data within the reports.
27. Perform testing and validation to confirm that reports meet the defined requirements.
28. Design methodology and project documentation – technical specifications, business process documentation.
29. Create a user manual or playbook for each report.
30. Change Management Process.
31. Train employees on changes to systems and processes.
32. Develop training programmes for employees on usage of new tools and enhancements thereof.

Requirements:

1. Qualification and Skill NQF 6 (Diploma or Advanced Certificate) NQF 7 (Bachelor's Degree or Advanced Diploma) and Project Management advantageous.
2. Microsoft Certification as Power BI Data Analyst Associate advantageous.
3. Have at least 5 years' experience in a related role.
4. Have a minimum 2-3 years of experience in building reporting solutions using Power BI.
5. Display strong proficiency in Power BI Desktop and Power BI Service.
6. Show strong understanding of integration and systems i.e. COUPA / SAP etc.
7. Have a minimum 2-3 years in the following applications: SQL, SharePoint site development, PowerApps, Power Automate, Artificial Intelligence (AI) or Machine Learning (ML).
8. Display proven expertise in data integration from various sources such as Azure Synapse, Excel, CSV, SharePoint and Power BI datasets.
9. Demonstrate experience in designing and developing interactive and visually appealing reports, dashboards, and visualisations in Power BI.
10. Show solid understanding of data visualisation best practices and ability to translate complex data into clear insights.
11. Show expertise in writing complex DAX (Data Analysis Expressions) formulas for creating advanced calculations and measures.
12. Display proficiency in Power Query M Language for data transformation and cleansing.
13. Be familiar with SQL queries and database concepts.
14. Show strong Stakeholder Relations experience including managing the delivery of systems expectations and service expectations of service providers.
15. Have an understanding of the legislative and regulatory framework impacting on the systems design and delivery.
16. Be computer literate (Power BI, Excel, SQL, SAP modules, Coupa, AWS and related software programs).
17. Be experienced in the design of systems functional specifications and strategy for business processes where required.
18. Display excellent project knowledge in the implementation of any business requests.
19. Have experience in writing training documents (specifications, charters, change control, training).
20. Have a valid driver's license.

Benefits and Contractual Information:

Permanent role. If you wish to apply for the position, please send your CV to Mark Huber Managing Lead - Executive Mining Recruitment CA Mining. CA Mining will respond to short-listed candidates only. If you have not had any response in two weeks, please consider your application unsuccessful; however, your CV will be kept on our database for any other suitable positions.