Western Cape Listings

Work With The Best

At Merchants our vision is to create meaningful and sustainable futures for our people, by driving a culture of continuous learning through the many skills and development programmes we offer, which are designed to develop talent and fulfil potential.

If you were born to deliver exceptional service, apply to join our professional team and be ready to kick start your career. We’re always looking for expectational talent and are known around the world for our outstanding customer experience using the latest technology, best practice models and processes, and innovative ground-breaking training techniques.

We place our people at the centre of everything we do and believe that the way you treat your customers and people differentiates us.

Are you ready to take the next step in your career?

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

Requirements
•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