Data Analyst II

Capitec Bank Ltd.; Stellenbosch; On-site; ZAR 500,000 - 750,000; Full time

Job summary

Capitec Bank Ltd. in Stellenbosch is seeking a skilled Data Analyst to own the Sigma analytics platform and collaborate with Treasury leadership for critical insights. The ideal candidate has over 5 years of experience, strong SQL skills, and proficiency with BI tools like Sigma, Power BI, and Snowflake.

This role requires effective communication with both technical and non-technical stakeholders, as well as expertise in data analysis and visualization. The bank offers a supportive environment for growth in the financial services sector.

Qualifications

• Minimum of 5 years’ experience in data analysis, BI engineering or analytics platforms.
• Strong SQL skills and experience working with large datasets.
• Ability to communicate insights clearly to non-technical stakeholders.

Responsibilities

• Own the analytics layer and build Sigma dashboards for decision-making.
• Translate Treasury requirements into usable data products.
• Identify opportunities to streamline reporting and improve efficiency.

Skills

SQL

Data Analysis

Data Visualization

Analytical Skills

Communication Skills

Education

Bachelor's degree in Data, Analytics, Finance, or related field

Honours degree in analytical/data/technical or related field

Tools

Sigma

Power BI

Tableau

Snowflake

Python

Excel

Job description

What you’ll be doing

This is not a traditional reporting role. You’ll own and evolve the Sigma analytics platform sitting on top of our Snowflake data environment and work closely with Treasury leadership to ensure critical insights are always available, accurate and decision-ready. The Data Analyst will work as the bridge between technical teams to translate business questions to data requirements. Understand the business processes and how data flows into the warehouse. Be involved in the design of new processes and ensure the design caters for data needs at the end of projects with little to no data rework needed.

Responsibilities

• Own the analytics layer
• Build and maintain Sigma dashboards, data models and reporting solutions supporting ALCO, Exco and Board-level decision-making.
• Translate Treasury, liquidity and capital requirements into usable data products that shape strategy and planning.
• Design KPIs, dashboards, scenario analyses and self-service tools that enable faster, data-driven decisions across technical and non-technical stakeholders.
• Act as the bridge between business and data
• Translate business questions into data requirements and ensure reporting solutions are built with the end in mind.
• Improve and automate how we work
• Identify opportunities to streamline reporting, reduce manual effort and use AI/modern tooling to improve productivity and efficiency.
• Partner across teams
• Work closely with Treasury, Finance, Risk, Data Engineering and Analytics teams to deliver high-quality, scalable solutions.

What we’re looking for

Minimum requirements

• Relevant degree in Data, Analytics, Finance, or a related field
• Minimum of 5 years’ experience in data analysis, BI engineering or analytics platforms
• Strong SQL skills and experience working with large datasets
• Experience with BI tools such as Sigma, Power BI, Tableau or similar
• Ability to communicate insights clearly to non-technical stakeholders
• Minimum of 5 years’ experience delivering data-driven insights in a business environment

What will set you apart

• Experience working on cloud data platforms (e.g., Snowflake)
• Exposure to Treasury, banking or financial services data
• Experience building data models, dashboards and automated workflows
• Understanding of AI/GenAI use cases in analytics
• Experience working with or interpreting Python/R/Excel-based models
• Proven track record of influencing decisions through data at a senior level

Qualifications (Minimum)

• Bachelor's degree in analytical/data/technical or other

Qualifications (Ideal or Preferred)

• Honours degree in analytical/data/technical or other

Knowledge

• Advanced proficiency in writing complex SQL, optimizing query performance, and working with large datasets on a cloud warehouse (Snowflake preferred).
• Strong proficiency in building advanced, governed visualisations, dashboards, and data models in Sigma (or Tableau / Power BI / Looker / similar).
• Solid understanding of cloud data warehouse architecture, data modelling and semantic layers (data layer, scenarios, lineage) — ideally Snowflake.
• Understanding of analytics workflow orchestration, automation and data governance — version control, approvals, audit trails and lineage.
• Practical understanding of AI/GenAI applied to analytics — semantic layers, AI-assisted workflow and dashboard design, and automation of analytics processes.
• Ability to read and interpret existing Python, R or Excel models in order to port their logic and outputs into Sigma + Snowflake.
• Expertise in advanced Excel (including macros/VBA) sufficient to interpret and migrate existing Excel-based models.
• Awareness of Treasury / ALM concepts (IRRBB, NII/EVE, LCR/NSFR, FTP, capital planning, stress testing) and regulatory artefacts (LAS, ICAAP, ILAAP, CSST, Recovery Plan) is advantageous — domain depth is provided by the quants and ALM specialists the role supports

Skills

• Analytical Skills
• Communications Skills

Capitec Bank is an authorised financial services provider (FSP 46669) and registered credit provider (NCRCP13). Capitec Bank Limited Reg. No: 1980/003695/06