About the Role

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.

Responsibilities

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

Requirements

• Bachelor's Degree in Analytical/Data/Technical or Other
• Analytical Skills
• Communications Skills
• Problem solving skills
• Project Management Skills (Methodolgy Specific)
• Clear criminal and credit record

Preferred Qualifications

• Honours Degree in Analytical/Data/Technical or Other
• 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