BI Data Analyst - Johannesburg at Absa Group Limited (Absa)

Key accountabilities 

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
• Understanding of SAS, SQL, Power BI, SSIS (databricks advantageous)
• Development of power bi dashboards
• 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
• Analyse derived information to create value add understanding of insights and opportunities presented by the data set
• Prepare customised 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 report production

Accountability:  Provide value-add insight

• Develop a thorough understanding of the key business challenges through engagement with all stakeholders in the business
• Identify opportunities through which Analytics can assist in addressing these challenges, present these to relevant stakeholders and implement
• Identify business opportunities in support of the business sales initiatives through analysis of the business management information and management information that may reside outside the business.
• Assist stakeholders in developing business cases for new products by providing relevant information to support identified business opportunities. Ensure that the management information input in business cases is credible by ensuring accuracy of the data used
• Propose approaches to the business on monitoring measures or key performance indicators (KPIs) associated with the business case and business model and ensure creditability of data received to support the measures or KPIs
• Analyse trends within the business data to reduce risks, optimise performance of the business and inform People Function decisions.

Accountability:  Governance and control 

• Conduct integrity checks on all extracted data to ensure correct data is incorporated into reports
• Ensure the accuracy of data within the business and ensure consistent use of data
• Escalate data integrity issues to relevant Manager / Data Management ensure that these receive priority to maintain a high-level of data integrity.
• Check all existing and new reports for accuracy and data integrity

Accountability:  Business partnering

• Build effective working relationships with business stakeholders to develop a detailed understanding of their business imperatives and objectives.
• Maintain an interactive process with stakeholders as the analytical solution is being developed - present and receive feedback on work-in-progress.
• Perform a consultancy role with business stakeholders. Present the final analytical outputs to stakeholders and assist in interpreting the results and providing advice & recommendations on the implementation of actions.
• Educate users where required on the design or how to utilise the solution.
• Engage with the business teams on an ongoing basis to understand management information needs and sensitise them to any relevant existing reports or management information outputs that will result in value add opportunities in their respective areas
• Conduct impact analysis of any proposed changes that will impact on management information reporting
• Actively engage and participate in new initiatives within the business to ensure that the management information component is addressed
• Engage with other key stakeholders within the Group to ensure that the business leverages off what is available and are aware of initiatives in the group that may impact on the business

Accountability:  Continuous self-development and growth

• Stay abreast of knowledge and skills relevant to the level and area of work, as well as actively seeking to attain those required for the next level of work with particular focus on best practices
• Continuously enhance the business expertise by analysing its drivers, key indicators, relationships and trends.
• Consider all influencing events, quantify the impact on the business and pro-actively find solutions
• Develop a thorough knowledge of various systems and related reporting including ability to build / adjust reports within Workday.

Education

• Bachelor's Degree: Information Technology