Business Intelligence Analyst II [BI Analyst II] (Stellenbosch) at Capitec Bank

Purpose Statement

• To build value for the product line by solving client and business challenges using data. 
• To utilise data and analytical skills and experience to build insights which enable senior decision makers to make better, informed decisions faster.
• Productionise insights to be consumed across team (focus on building reusable data assets).
• To build an understanding of various business domains and relevant products, to address queries and execute analytical tasks.
• To collaborate with cross-functional teams to identify business opportunities.

Education (Minimum)

• A relevant tertiary qualification in Business Administration or Statistics
• Grade 12 National Certificate / Vocational

Education (Ideal or Preferred)

• Certification in Business Analysis

Knowledge and Experience

Minimum Experience:

• At least 3 years’ experience as Business Intelligence Analyst or equivalent Data role (Data Analyst, etc.); including experience in Data Analytics, BI methods and tools, Data Warehousing, and the Data Product Life Cycle
• Identifying, quantifying, and subsequently delivering value on how to solve business challenges using data 
• Stakeholder engagement 
• Building Data Visualisations using tools such as Power BI 
• Intermediate to advanced SQL skills: Using SQL to prepare and analyse data (e.g., indexes, query plans, foreign key constraints, common table expressions, etc.)
• Coding and performing code reviews
• ETL (extraction, transform, load) data flow, and traceability
• Documentation

Minimum Knowledge:

• Knowledge and basic experience in using low/no code AutoML on modelling tools such as Power BI or AWS Sagemaker  
• Design thinking
• Dimensional Modelling
• The Data Product Life Cycle (DPLC)
• Data privacy and security regulations and best practices 
• Data quality and incident management  
• Agile project management methodology
• Data management 

Ideal Experience / Knowledge:

• Having relevant industry certifications (e.g., CompTIA Data+; Certified Analytics Professional [CAP]; Associate Certified Analytics Professional [aCAP]; Google Data Analytics Professional Certificate; Microsoft Certified; Power BI Data Analyst/Associate; and/or AWS Certified Data Analytics)
• Working with data on Cloud platforms (such as AWS or Microsoft Azure)
• Previous experience working in Business Analysis / Data Analysis in the financial/banking sector
• Knowledge of change management principles and practices
• Mentoring colleagues

Skills

• Commercial Thinking Skills
• Facilitation Skills
• Numerical Reasoning skills
• Presentation Skills
• Problem solving skills
• Attention to Detail
• Planning, organising and coordination skills
• Communications Skills
• Interpersonal & Relationship management Skills