Subject Data Modeller at Capitec Bank

About The Role/Team

• We’re a vibrant, collaborative data team on a mission to turn information into powerful insights that drive smart decisions across the business. Our team spans Data Engineering, Business Intelligence & Reporting, Advanced Analytics, AI/ML, and Architecture - working together to make data meaningful, accessible, and actionable. 
• At the core of what we do is Analytics Engineering - the critical link that transforms raw data into valuable business-ready insights. We’re passionate about building data solutions that drive impact, support strategic goals, and empower teams to unlock the full potential of our data. 
• We’re looking for a Data Modeller to help design and shape the blueprint of our data landscape. In this role, you’ll play a key part in supporting our current modeller and scaling our enterprise data capabilities. You’ll be joining a team of curious, solution-focused individuals who love tackling tough problems, continuously learning, and supporting each other’s growth. You’ll work closely with teams across the business - translating their needs into clear, logical data models. You’ll also gain hands-on experience with modern cloud technologies, semantic modelling tools, and help shape the way we manage and use data for the future.

What We Are Looking For
Experience & Skills: 

• Minimum of 1 year of hands-on experience in Data Modelling, with a solid understanding of data structures, relationships, and best practices.
• An additional 2 to 3 years of experience in a related data role, such as Data Engineer, Data Analyst, or Business Intelligence Analyst, demonstrating a strong foundation in data analysis, transformation, and reporting.
• Exposure to data modeling principles, including concepts like star schema, snowflake models, and normalized vs. denormalized data structures. 
• Working knowledge of SQL and relational database fundamentals. 
• Hands-on experience with Python for data-related tasks. 

Nice to Have / Preferred: 

• Exposure to semantic modeling tools such as dbt, AtScale, or similar platforms. 
• Familiarity with Power BI, Salesforce Data Cloud, or other self-service analytics tools. 
• Experience working with cloud data platforms, particularly the AWS data stack (Redshift, Glue, Lake Formation) or similar environments. 
• Basic understanding of banking products or the financial services industry. 

What You’ll Be Do Doing

• Assist in building and maintaining conceptual, logical, and physical data models across various business domains (e.g., Credit, Client, Product, Risk, and Financial Performance). 
• Collaborate with Data Engineers, Business Analysts, and Data Scientists to define data requirements and modeling standards. 
• Support the development of the semantic layer used in self-service analytics tools (e.g., Power BI, Salesforce CRM Analytics). 
• Help maintain a central business glossary and data catalog to promote a common language and understanding of key metrics and definitions. 
• Ensure models align with governance and compliance standards (e.g., RDARR principles where applicable). 
• Support data quality profiling and impact assessments when changes are made to the models. 
• Participate in sprint ceremonies and agile delivery for data products.