Data Solutions Analyst

Capitec Bank; Stellenbosch; On-site; ZAR 900,000 - 1,200,000; Full time

Job summary

Capitec Bank is seeking an experienced Data professional to shape the data warehouse for multiple credit and business teams. You will define data structures, ensure data quality, and work with stakeholders to translate business needs into robust data solutions.

You will lead user-story creation, coordinate across development and QA, and drive governance and cross-team collaboration. A strong background in data warehousing and analytics is essential.

Qualifications

• Bachelor's degree in IT or CS.
• 5–10 years data analysis experience translating requirements into technical specifications.
• Lead data capability initiatives in large-scale data environments.
• Designs and leads test plans; validates data transformation logic.
• Collaborates with data developers to define KPI's, metrics and dashboards.

Responsibilities

• Define how data is structured, sourced and stored for trusted data across teams.
• Translate stakeholder needs into clear data requirements and documented solutions.
• Write user stories with acceptance criteria and coordinate delivery across dev and QA.
• Lead test plans and validate transformation logic; drive defect resolution.
• Define and maintain data quality rules and governance processes.

Skills

SQL

Data analysis

Agile methodologies

Stakeholder communication

KPI/dashboard requirements

Education

Bachelor's degree in IT or CS

Tools

ETL tools

Data modelling tools

Job description

About the role

Over 23 million people bank with us. The data that powers every decision behind that - from product design to credit risk to client experience - needs to be clean, trusted and built to scale. That's where you come in. The Credit Access Data team is growing. We work at the intersection of granting, pricing and decision science, building the data foundations behind new credit products from the ground up. This isn't a maintenance role. You'll have a direct say in how our data warehouse grows, shape architectural decisions and work with senior stakeholders to turn complex business questions into reliable data that teams across our entire organisation can act on. You'll also lead a Community of Practice, bringing data practitioners together to share knowledge and raise standards across the business. We work openly, we move fast and we trust people who know their craft, if you see data as an outcome, not just an output, this is the role for you.

What you'll do

• Define how data is structured, sourced and stored - so that one trusted set of data powers many different teams and tools across our business
• Work directly with business stakeholders to understand what they need, then turn those needs into clear data requirements and well-documented solutions
• Write user stories with clear acceptance criteria and coordinate delivery across development and QA teams
• Lead test plans, validate transformation logic and drive defect resolution - so that what gets built is exactly what was agreed
• Define and maintain data quality rules, engage governance processes and make sure issues get resolved, not just reported
• Build relationships across multiple business areas and adapt how you communicate depending on who's in the room

Knowledge and Experience

Minimum Experience:

• Bachelors Degree in Information Technology - Computer Science or Information Technology
• 5-10 years in business and data analysis, translating requirements into technical specifications
• At least 5 years working across teams, leading data capability initiatives in large-scale data environments
• Designs and leads test plans. Validates data transformation logic and reports. Coordinates defect resolution.
• Understands multiple business functions and data needs. Adapts language and approach to different stakeholders
• Collaborates with data developers to define KPI's, metrics and dashboard requirements. Ensures alignment to business objectives

Technical skills:

• Strong SQL - data validation, reconciliation and transformation logic
• Experience with dimensional modelling, star and snowflake schemas, and fact and dimension tables
• Ability to read and contribute to logical and conceptual data models, and document metadata with full traceability
• Working knowledge of data warehouse and Lakehouse concepts - data ingestion, ETL processes, data marts and reporting

Ways of working:

• Comfortable writing user stories and coordinating development and QA teams through full delivery cycles
• Experienced in Agile methodologies and project management
• Confident communicator who works equally well with technical and non-technical stakeholders
• Strong analytical thinker with commercial awareness and a practical approach to problem-solving

Knowledge:

• Banking, telecommunications and financial services
• Quantifying business value from data
• Data Architecture including concepts of data warehousing and Lakehouse
• Data warehousing including concepts of data sources, data ingestion, data marts, ETL (extract, Transform and Load processes), dashboards and reporting, advanced analytics and predicative modelling
• Project management and Agile Methodologies
• Data governance and data management
• Cross functional facilitation
• Leading a Community of Practice

Additional Information

• Clear criminal and credit record

Capitec is committed to diversity, applications to this position will strictly be considered in support of our employment equity goals.