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.
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:
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:
Knowledge and Skills
- Data Validation and Reconciliation
- Environmental Sustainability Data Management
- Reporting Governance and Controls
- Audit and Assurance Support
Education
Bachelor's Degree: Information Technology
