Western Cape: MI Analyst posted by Merchants SA Pty Ltd

The purpose of this position is to provide accurate reports for operations and control the quality of delivery to Business Units. This position also conducts analytics to advise on process information and functionality. 1.Database and Report Management Identifies relevant sources of data from which to draw information Agrees specification format with stakeholders Gathers and collates information into a report and ensures accuracy Ensures accuracy of exception capturing and real time reporting Setup and design reports accordingly to stakeholder requirements Document MI SOP for all supported Business Units Ensure MI Administrators are suitably skilled on designed reports, and handover management of MI SOP Clearly documents stakeholder requirements for new/amended report requirements Extracts data into correct format from SQL / Other data sources Provides recommendations to stakeholders on effective data capturing and storage to ensure timely delivery of reporting Conducts ongoing monitoring of data sources to ensure efficient delivery of data to stakeholders Manages and maintains the daily delivery and validation of operational reporting for various business units Designs operational report requirements in Power BI for the relevant Business Units Attends meetings and act as the interface between the Data Engineer and Data Analysts, effectively communication changes and issues that need to be addressed 2.Stakeholder Management Attends stakeholder meetings as required, provides feedback on progress and recording issues that need attention Provides feedback to BI Team on areas of concern that need focus Effectively communicates changes/updates to all stakeholders as applicable Provides direction to stakeholders on required reporting within the context of Enterprise Information Platform Effectively communicate and work with the Data Analysts and Data Engineers to design new data requirements that fall outside of the currently available dataset 3.Analysis Interprets data to identify trends and risks Explores and identifies reasons for trends Analyses and documents business processes, including recommendations for improvement against the identified weakness Provide trend analysis and recommendations to relevant stakeholders as applicable 4.Data Security Maintains data standards in accordance with business requirements, Dimension Data and Merchants policies and the data protection legislation Works in accordance with the security information requirements and procedures of the company Controls access to databases environments through permissions and privileges 2 years Information Management experience,preferably in a Call Centre environment Understanding of databases and data frameworks Proficiency in excel advanced Proficiency in SQL Scripting and SQL Server Proficiency in SQL Server Proficiency in SSIS/SSMS MS Power Query Advanced Min of 2 years MS SQL experience Database Design