MI \ BI Developer (SQL)

Empowering Africa’s tomorrow, together…one story at a time.

With over 100 years of rich history and strongly positioned as a local bank with regional and international expertise, a career with our family offers the opportunity to be part of this exciting growth journey, to reset our future and shape our destiny as a proudly African group.

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)

Absa Bank Limited is an equal opportunity, affirmative action employer. In compliance with the Employment Equity Act 55 of 1998, preference will be given to suitable candidates from designated groups whose appointments will contribute towards achievement of equitable demographic representation of our workforce profile and add to the diversity of the Bank.

Absa Bank Limited reserves the right not to make an appointment to the post as advertised