Environmental and Sustainability Data Analyst at Absa Group Limited (Absa)

Job Summary

• Motivated and experienced Environmental and Sustainability Data Analyst that will support the business through the development and maintenance of accurate information and the analysis of available information. To provide valuable insights and support to the business through the development and maintenance of accurate information and the analysis of available information. 
• To propose approaches to the business on monitoring measures or key performance indicators (KPIs) associated with environmental management 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. 
• It is expected that the incumbent will provide technical input and be accountable for the oversight in the planning, specifications, technology selection, analyses of alternative energy sources, compiling, analysing and the management of large complex data sets, provide input into the design and execution of engineering installations, and optimisation of utilities management for the Group (inclusive of ARO), in order to drive its sustainability programme.

Job Description

Strategy Formulation

• To provide valuable insights and support to the business through the development and maintenance of accurate information and the analysis of available information.
• Provide valuable insights and support to the business through the development and maintenance of accurate information and the analysis of available information.

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 data
• Work with CRES Environmental Management team to develop complex data outputs that encapsulate various disparate data sources that needs to be combined into cohesive data artifacts.
• Develop processes that will validate data outputs as in line with previous results and investigate any outliers.
• Identify interesting trends through means of data science or other data analysis methods.
• Analyse data for trends on a monthly basis and track performance against EAP targets, (Recalculate and correct where required.)

Design and Analysis

• 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
• Prepare customised reports based on identified requirements from the business at large
• Develop regular performance reports particularly related to the needs of the business sales force to aid performance measurement and management.
• Compiling, analysing and managing large, complex data sets and translating the data into succinct reports and policy recommendations for diverse stakeholders.
• Conduct impact analysis on any proposed changes that will impact on management information reporting.
• Continuously identify opportunities to automate reports and to eliminate duplicate and manual report production
• Manage monitoring, verification, reporting, auditing and procurement activities and the development/adoption and application of appropriate technologies for all CRES environmental KPI’s

Compliance and Data Validation

• Business logic is not always static and needs adjustment from time to time which requires engagement with resources on all levels of business. Expert knowledge in a subject matter area drives improved logic and data outputs and in turn drives financials delivered to the larger group.
• Auditor internal and external engagement when queries and requests are raised so that the group can obtain satisfactory audits or improve on items that was identified for improvement.
• 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
• Prepare quarterly dashboard reporting in line with Group, CRES and Functional Balanced Scorecard reporting cycle, including variance commentary
• Conduct monthly, quarterly and annual conformance testing against the CRES Environmental Standard
• Check all existing and new reports for accuracy and data integrity

Monthly Data Runs and Monitoring

• Use workflow system to ensure required data sources are loaded and escalate challenges seen
• Ensure monthly datasets are prepared for downstream actuarial and finance processes via the Absa approved ETL tools
• Developed new and Updated existing ETL processes as and when new requirements are known as per the timelines of the larger team.
• Investigate anomalies within the results produced and liaise with the relevant resources to drive resolution and correction of these anomalies.
• Work with actuarial, finance and data resources to obtain sign off on a monthly bases so that the agreed monthly processes can proceed with downstream processes like SAP consuming the delivered data artifacts.
• Monthly preparation of data sources that isn’t fully automated using input from finance and investment clusters.

Stakeholder Management

• 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.
• 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
• 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
• Educating users where required on the design or how to utilise the solution.
• Actively engage and participate in new initiatives within the business to ensure that the management information component is addressed

People Management

• 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
• Agree and implement own development plans.

It is essential that the have the following skills:

• Minimum of 5 years hands-on technical experience in SQL, python and PowerBI/Qlikview/Tableu.
• Environmental and Sustainability Data Analytics experience.

Education

• Bachelor's Degree: Information Technology