BI Data Analyst else Data Analyst

absa; Johannesburg; On-site; ZAR 350,000 - 550,000; Full time

Job summary

Absa is seeking a BI Data Analyst to support the business through the development and maintenance of accurate information and analysis of environmental sustainability data. The role focuses on delivering valuable insights from datasets and creating actionable reporting for management and stakeholders.

The ideal candidate will coordinate data collection, validate data quality, and develop robust reports and dashboards using Power BI and other technologies, driving automation where possible.

Qualifications

Responsibilities

• Coordinate the monthly collection of environmental sustainability data from internal and external data providers.
• Review source data for completeness, consistency, reasonableness and accuracy prior to inclusion in reporting systems and management reports.
• Develop new reports, report formats and standards based on identified user requirements for the business, using multiple technologies.
• Review, test and validate Power BI dashboards and reporting visualisations to ensure figures reconcile to source data.
• Continuously identify opportunities to automate reports and to eliminate duplicate and manual report production.

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.

Belonging at Absa

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 qu