MI \ BI Developer (SQL)

time left to apply End Date: January 10, 2025 (25 days left to apply)

job requisition id R-15970246

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

1. 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.
2. Collect and package data into usable and user-friendly management information for the relevant teams and stakeholders in the business.
3. Develop new reports, report formats and standards based on identified user requirements for the business, using multiple technologies.
4. Analyze derived information to create value add understanding of insights and opportunities presented by the data set.
5. Prepare customized reports based on identified requirements from the business at large.
6. Develop regular performance reports particularly related to needs of the business sales force to aid performance measurement and management.
7. Continuously identify opportunities to automate reports and eliminate duplicate and manual processes.
8. Conduct special studies and make recommendations to management regarding opportunities, progress and improvement strategies. May research and prepare reports on related subjects.
9. Report production.
10. ETL processing on the full Microsoft BI Stack (SQL focused).

Accountability: Management Information (MI) and Reporting

1. Engage with internal business and technical stakeholders to understand requirements and ensure objectives, priorities and key requirements are agreed and understood.
2. Interpret data and identify issues, risks and opportunities and relate results and insights to Business users.
3. Conceptualize, design and build Management Information (MI) / Business Intelligence (BI) models in support of business requirements.
4. Leverage expertise in analytical & creative problem solving to synthesize a solution design (build a solution from its components) beyond the analysis of the problem.
5. 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:

Bachelor's Degree or Advanced Diploma in the 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

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.

About Us

Absa Group Limited (“Absa Group”) is listed on the Johannesburg Stock Exchange and is one of Africa’s largest diversified financial services groups.

Absa Group offers an integrated set of products and services across personal and business banking, corporate and investment banking, wealth and investment management and insurance.

Absa Group owns majority stakes in banks in Botswana, Ghana, Kenya, Mauritius, Mozambique, Seychelles, South Africa, Tanzania (Absa Bank Tanzania and National Bank of Commerce), Uganda and Zambia and has insurance operations in Botswana, Kenya, Mozambique, South Africa and Zambia. Absa also has representative offices in China, Namibia, Nigeria and the United States, as well as securities entities in the United Kingdom and the United States, along with technology support colleagues in the Czech Republic.