Specialist: MI & BI at Absa Group Limited (Absa)

Job Summary

• To investigate, design, implement and maintain Management Information (MI) and Business Intelligence (BI) solutions in order to provide timely and accurate reporting and solutioning development to business in order to enable informed decision making. This is to be achieved by establishing and maintaining effective relationships with the relevant stakeholders and applying intimate knowledge of data systems in the context of the core business

Job Description

Accountability:  Management information Production

• Source information from different data warehouses, data marts, manual systems and on-line systems based on knowledge of appropriate data sources given the business requirement
• Collect and package data into usable and user-friendly management information for the relevant teams and stakeholders in the business
• Develop new reports, report formats and standards based on identified user requirements for the business, using multiple technologies
• Analyze derived information to create value add understanding of insights and opportunities presented by the data set
• Prepare customized reports based on identified requirements from the business at large
• Develop regular performance reports particularly related to needs of the business sales force to aid performance measurement and management.
• Continuously identify opportunities to automate reports and to eliminate duplicate and manual
• Conducts special studies and makes recommendations to management regarding opportunities, progress and improvement strategies. May research and prepare reports on related subjects
• report production
• ETL processing on the full Microsoft BI Stack (SQL focused) 

Accountability: Management Information (MI) and Reporting

• Engage with internal business and technical stakeholders to understand requirements and ensure objectives, priorities and key requirements are agreed and understood.
• Interpret data and identify issues, risks and opportunities and relate results and insights to Business users.
• Conceptualize, design and build Management Information (MI) / Business Intelligence
• Leverage expertise in analytical & creative problem solving to synthesize a solution design (build a solution from its components) beyond the analysis of the problem
• (BI) models in support of business requirements.
• Oversee integrity of reports, both when developing new reports as well as when executing existing scripts to ensure data is accurately presented.

Knowledge & Skills:

• MS SQL
• SSIS
• SSAS
• SSRS
• Power BI

Added Advantages:

• Denodo
• Hadoop

Education

• Batchelor's Degree or Advance Diploma in

following degrees and/or  subjects may be particularly useful:

• computer science
• data science/computer and data science
• engineering
• mathematics
• mathematics and operational research
• physics
• statistics
• business mathematics and informatics

Education

• Bachelor`s Degrees and Advanced Diplomas: Business, Commerce and Management Studies (Required)