BI Data Analyst else Data Analyst

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

Belonging at Absa

Absa is committed to creating an inclusive workplace where everyone can thrive. We are an equal opportunity employer and welcome applications from suitably qualified individuals from diverse backgrounds. In support of our Diversity, Equity, Inclusion and Belonging (DEIB) commitments and Employment Equity objectives, preference may be given to candidates from underrepresented designated groups, including persons with disabilities. We encourage applicants who may require reasonable accommodation during the recruitment process to let us know so that appropriate support can be provided.

Job Summary

We are looking for a BI Data Analyst else Data Analyst to provide support to the business through the development and maintenance of accurate information and the analysis of available information. To provide valuable insights and support to business through the development and maintenance of accurate information and analysis of available data.

Job Description

Key accountabilities

Accountability: Management information Production

• Coordinate the monthly collection of environmental sustainability data from internal and external data providers, including energy, fuel, waste, water, paper, renewable energy and other environmental performance indicators.

• Ensure all required environmental datasets are submitted within agreed reporting timelines and proactively follow up on outstanding or incomplete submissions

• Review source data for completeness, consistency, reasonableness and accuracy prior to inclusion in reporting systems and management reports

• Maintain documented validation processes and supporting evidence to ensure data is suitable for internal reporting, external reporting and assurance requirements

• 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.

• Review, test and validate Power BI dashboards and reporting visualisations on a regular basis to ensure that reported figures reconcile to source data and approved reporting outputs

• Verify the accuracy of calculations, measures, KPIs, trends and visual representations displayed on dashboards before reports are presented to management and stakeholders

• Investigate and resolve dashboard data discrepancies in collaboration with reporting teams, system administrators and business stakeholders

Accountability: Governance and control

• Conduct detailed monthly validation and quality assurance reviews on all environmental sustainability data received from internal and external data providers

• Verify completeness, accuracy, consistency and integrity of all environmental datasets, including energy, fuel, water, waste, paper, renewable energy, greenhouse gas emissions and other reporting metrics

• Challenge data submissions where anomalies, gaps, variances or inconsistencies are identified and work with data providers and relevant technology teams to resolve issues prior to reporting

• Perform trend analysis, variance analysis and reasonable checks to identify potential reporting errors and ensure data quality standards are maintained

• Maintain audit trail and supporting documentation for all reported environmental data to support internal audit, external assurance and regulatory reporting requirements

• Ensure all environmental data complies with approved reporting methodologies, calculation approached and governance standards

• Escalate material data quality issues, reporting risks and non-compliance with reporting requirements to management for resolution

• Review and validate all environmental reporting outputs, scorecards, dashboards and management reports before publication or distribution to stakeholders

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.

QUALIFICATIONS AND EXPERIENCE

Education:

Bachelor's Degree in one of the following:

• Information Technology

• Statistics

• Environmental Management

• Environmental Science

• Business Analytics

Work Experience:

• 3-5 years’ experience in data analysis, business intelligence, sustainability reporting, environmental reporting or data governance

• Experience performing detailed data validation, reconciliation and quality assurance activities

• Experience working with large and complex datasets from multiple source systems

• Experience developing, reviewing or maintaining Power BI dashboards and reporting solutions

• Experience supporting audit, assurance or regulatory reporting processes would be advantageous

• Knowledge of environmental sustainability of ESG reporting metrics and methodologies would be advantageous

COMPETENCIES

Leadership Competencies:

• Analytical Thinking

• Attention to Detail

• Courageous Challenge

• Driving Execution

• Accountability

• Risk and Control Mindset

• Stakeholder Management

Knowledge and Skills

• Data Quality Management

• Data Validation and Reconciliation

• Power BI Reporting

• Root Cause Analysis

• Attention to Detail

• Analytical Thinking

• Environmental Sustainability Data Management

• Reporting Governance and Controls

• Stakeholder Management

• Audit and Assurance Support

• Report Writing

Education

Bachelor's Degree: Information Technology