Business Intelligence Developer at Absa Group Limited (Absa)

Job Summary

• The BI Developer in the Risk Business Unit plays a crucial role in enhancing the bank's risk management capabilities through the development and implementation of advanced business intelligence solutions. This position entails the designing and developing interactive dashboards, reports and data visualizations using BI tools like PowerBI, create and maintain ETL (Extract, Transform, Load) processes to integrate data from multiple sources. Furthermore, build and maintain data marts for reporting and analytics while ensuring data accuracy, consistency and security across systems. Additionally, the role involves migrating existing visualizations from QlikView to more advanced platforms, ensuring seamless and efficient data visualization. By leveraging their technical expertise and analytical skills, the BI Developer will support the Risk Business Unit in identifying, assessing, and mitigating risks, ultimately safeguarding the bank's assets and ensuring regulatory compliance.

Job Description

Key accountabilities 

Accountability: ETL/ELT Development (50%)

• Deliver key strategic data projects following the data standards and principles. This includes performing tasks in the data delivery lifecycle i.e. identifying data sources, analysis and interpreting data, data mapping, development (coding and scripting), testing, performing releases, and documenting project deliverables.
• Design, develop, and maintain ETL processes to extract, transform, and load data from various sources into data warehouses.
• Optimize and troubleshoot ETL workflows to ensure data integrity, accuracy, and performance.
• Develop and maintain ETL scripts and documentation for data pipelines.
• Collaborate with data architects and database administrators to ensure effective data integration and storage solutions.
• Implement data quality checks and validation routines to ensure data accuracy.
• Monitor ETL processes and workflows to identify and resolve issues promptly.
• Conduct performance tuning and optimization of ETL processes.
• Ensure data security and compliance with company policies and industry regulations.

Accountability: Data Visualization (15%): 

• Design and develop interactive and visually appealing dashboards and reports using SAS and SAS Viya.
• Migrate existing visualizations from QlikView to SAS Viya Visual Analytics and PowerBI.
• Collaborate with business stakeholders to understand requirements and translate them into effective data visualizations.
• Ensure data visualizations are user-friendly, insightful, and aligned with business objectives.
• Provide training and support to end-users on data visualization tools and best practices.
• Continuously evaluate and improve data visualization techniques and tools.

Accountability: Stakeholder Management (10%):

• Develop and maintain documentation for data visualization processes and standards.
• Coordinate all changes on the platform to ensure ongoing stability by contributing to business and project requirements on an adhoc basis. Take remedial action to ensure seamless customer service.
• Provide support to ensure data services are running as per service level agreements. Escalate non-adherence through the relevant channels within SLA context.
• Maintain professional relationships with stakeholders ensuring continuous communication and managing expectations.
• Engage and provide data support to internal and external audit.

Accountability: Data Governance and Adherence (15%) 

• Ensure proper data governance is in place adhering to risk and control principles in deliverables and perform risk and control assessments, front to back for the allocated business.
• Ensure controls are in place over applications to ensure the data integrity by performing data integrity gap analysis
• Monitor and track data quality issues, identify gaps, and apply action plans to remediate gap
• Manage user and group permissions and authorizations via a request.

Accountability: Continuous self-development and growth (10%)

• Sharing of knowledge and skills. Focus on data skills evolution and remaining relevant.
• Proactively increase technical skills through active research. Keep abreast of legislation and other industry changes that impacts on role by reading the relevant newsletters, websites and attending sessions.

Preferred Education & Work Experience

• Bachelor’s degree in Mathematics, Statistics, Engineering, Management Information Systems, Information Technology, Informatics, Computer Sciences/Systems or related technical field.
• 3+ years of relevant experience in Data management, Business Intelligence, Data quality management, Change management, Data quality technologies and governance design and implementation.

Technical Skills

• Experience performing root cause analysis on internal data, external data and processes to answer specific business questions.
• Experience in data warehousing(SQL Server, Oracle, Teradata, Hadoop & SAS), data architecture, data governance, data modelling, dashboard preparation, & reporting tools and trend analysis
• Experience in executing data/risk processes supported by strong knowledge in the data infrastructure and platforms
• Experience in ETL, Big data concepts & Cloud computing
• Exposure to reporting and BI technologies, QlikView, PowerBI etc.
• Proficiency in managing data life cycle
• Excellent analytical and problem-solving skills
• Programming (Optional): Python, R , DAX for advanced analytics

Non-Technical Skills

• Good communication skills - ability to present the Analytics results to a technical and non-technical audience
• Knowledge of building collaborative work environments
• Collaboration tools (JIRA, Confluence, etc.)
• Focus on quality and risk
• Deciding and Initiating Action
• Learning and Researching
• Creating and Innovating

Education

• Bachelor's Degree: Information Technology