Senior Manager: Data Support & Analytics

Closing Date - 4 December 2020 Location Nedbank Retail, CSSB Cash Strategy and Support Project, Process and Product Manage Self: Professional Position Senior Manager: Data Support & Analytics Job Purpose Full value chain understanding and management of SSB Data and Real time reporting of critical KPI and associated data sets / models by conducting analysis, understanding the impact and present the findings. Scope business data/MI requirements and work with cross-cluster teams to deliver the final product. Job Responsibilities Power BI Implementation of real time data dashboards Real time on threshold, forecasting and volume tier reporting for critical KPI data sets. Accurate ATM Volume and withdrawal reporting and forecasting Create Models and Dashboards from Data sources Utilise trigger-based volumes to optimised SQL processing time when importing data Create Multi-Step and Dynamic SQL Server Agent Jobs scheduling to avoid file import failures and track errors within stored procedures Exporting of reports and data models using SSRS and SSIS Develop, implement, and structure Data Mart ETL and design Schema’s data models Manage report failures and rectify issues to ensure oversight Evaluate reports for accuracy, relevance, and stability and recommend report enhancements. Manage report failures, debug issues, and ensure report data does not change while you are debugging Automate processes through data automation SQL query writing to optimise processing Minimum Experience Level 3-5 years in a Product or service development role 3-5 years' Business Intelligence Development / Analyst role 3-5 years’ SQL Developer role 2-4 years' Power BI (SSRS, SSIS, SSAS, ETL/DI design and implementation) essential Database Administration and Design Qualification B Degree: Computer Sciences, IT, Project Management, Engineering, Economics, Business Management and related Microsoft certification (Power BI / MS SQL) Data Management Certification would be advantageous Office 365 Type of Exposure BI and data warehouse concepts and approaches Data modelling techniques Power BI development, Microsoft BA stack and Power BI Technical / Professional Knowledge MS SQL Server, SQL, T-SQL Creativity, Innovativeness Data Management MS BI Full Stack (SSIS, SSRS and SSAS) ETL Full Cycle --------------------------------------------------------------------------------------- Please contact the Nedbank Recruiting Team at +27 860 555 566