Data Analyst II

Capitec; Stellenbosch; On-site; ZAR 450,000 - 650,000; Full time

Job summary

Capitec is seeking a Data Analyst II to join our Group Treasury team in Stellenbosch. You’ll own the analytics layer, evolve Sigma on Snowflake, and deliver finance-focused dashboards and data products for ALCO, Exco and Board decisions.

You will translate complex data into actionable insights, partner with Treasury, Finance, Risk and Analytics peers, and drive automation to improve reporting and efficiency.

Qualifications

• 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.

Responsibilities

• Own the analytics layer.
• Build and maintain Sigma dashboards, data models and reporting solutions supporting ALCO, Exco and Board-level decision-making.
• Turn complex data into clear insight.
• Translate Treasury, liquidity and capital requirements into usable data products that shape strategy and planning.
• Drive smarter decision-making.
• 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.

Skills

SQL

Sigma

Power BI

Tableau

Python/R/Excel

Data storytelling

Snowflake

AI/GenAI analytics

Excel macros/VBA

Treasury/ALM knowledge

Education

Bachelor's Degree in Analytical/Data/Technical or Other

Honours Degree in Analytical/Data/Technical or Other

Tools

Sigma

Power BI

Tableau

Snowflake

Looker

Job description

Job description:

We’re on a mission to stay insights driven.

At Capitec, we believe in making banking simple, accessible and driven by data. Our teams don’t just work with data — they use it to shape decisions, influence strategy and unlock real value for our clients.

We’re looking for a Data Analyst II to join our Group Treasury team, where you’ll play a key role in how balance sheet, liquidity and capital insights are translated into meaningful reporting and analytics for senior decision-making forums.

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.

You wil:

• Own the analytics layer
• Build and maintain Sigma dashboards, data models and reporting solutions supporting ALCO, Exco and Board-level decision-making.
• Turn complex data into clear insight
• Translate Treasury, liquidity and capital requirements into usable data products that shape strategy and planning.
• Drive smarter decision-making
• 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, optimising 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
• Problem solving skills
• Project Management Skills (Methodolgy Specific)

Conditions of Employment

• Clear criminal and credit record