Analyst MI & BI

Absa Group; Johannesburg; On-site; ZAR 500,000 - 700,000; Full time

Job summary

A leading bank in South Africa is seeking a qualified specialist to investigate, design, and maintain Management Information (MI) and Business Intelligence (BI) solutions. This role involves developing reports, analyzing data for insights, and ensuring accurate data presentation. The ideal candidate has a Bachelor's Degree in Computer Science or related fields and strong skills in SQL and Power BI. Join us to shape our future as a proudly African group.

Qualifications

• Bachelor's Degree or Advanced Diploma in Computer Science, Data Science, or related fields.
• Knowledge of statistical analysis and mathematical modeling.
• Experience in BI and data processing.

Responsibilities

• Investigate and implement MI/BI solutions for informed decision-making.
• Source and package data into user-friendly management information.
• Analyze data to uncover insights and opportunities.
• Prepare reports and automate reporting processes.

Skills

MS SQL

SSIS

SSAS

SSRS

Power BI

Education

Bachelor's Degree in Computer Science

Advanced Diploma in Data Science

Tools

Denodo

Hadoop

Job description

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 informatic

Education

Bachelor`s Degrees and Advanced Diplomas: Physical, Mathematical, Computer and Life Sciences (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