Product Data Engineer

Capitec; Bellville; On-site; ZAR 600,000 - 900,000; Full time

Job summary

Capitec is seeking a Product Data Engineer to join their dynamic team, focused on developing robust data solutions using SQL within a Redshift environment. The ideal candidate will have 4-6 years of experience in data engineering, including strong SQL skills and a background in ETL processes, while contributing to impactful business decisions.

Qualifications

• 4-6 years of experience as Data Engineer or similar role.
• Proficient in SQL and relational databases.
• Experience with cloud platforms like AWS or Azure.

Responsibilities

• Develop and maintain data assets and features in the environment.
• Write and optimize SQL queries for efficient data transformation.
• Collaborate with BI Analysts to align data structures with business needs.

Skills

SQL

Data Modelling

ETL/ELT Processes

Data Governance

Problem Solving

Education

Relevant tertiary qualification in Information Technology or Data Analysis

Tools

AWS

Azure

Git

Job description

Join Us in Becoming the Best Bank in the World!

We appoint energized and motivated people for their potentialandcontinuously look fortalented, driven individualstohelp usinnovate and evolve.That is why we focus on finding the right people for the right jobs. We love what we do because we focus on making a positive difference for our clients and employees. Our company DNA is built around talented and committed teams dedicated to build a brand that we are proud of and earns the trust of our clients.

Who We Are

We are a bank, but we’re much more than that.We believe that banking is about enabling peopleto control their financial lives through banking that is simplified, accessible, affordable and delivered through personal experience. By helping our clients manage their financial lives better, we enable them to live better.

Why Choose Us

At Capitec, we offer our best by living up to our CEO values in every situation – we always put theClient first, act withEnergy andtakeOwnership.And to support people in being their best,our Employee Value Propositionoffersevery value to all team members through cohesive teams, growth opportunities as well asemployee benefitsand savings. We make it a priority toensure that each member of the Capitec team feels welcome, valued, focused, and has the opportunity to grow.

About The Role/Team

Join a dynamic and cross-functional team where collaboration is key. You'll be part of a highly capable group that includes Business Intelligence Analysts (BIBAs), Data Engineers, and BI Developers. Our team is responsible for developing robust data solutions using SQL within a Redshift environment, building dimensions and fact tables to enable insightful reporting through Power BI.

As a Product Data Engineer, you’ll play a central role in building and maintaining data features, supporting key data structures, and contributing to impactful business decisions. The team values knowledge-sharing, innovation, and continuous improvement. We’re looking to for someone who is passionate about data, driven to solve problems, and eager to grow in a supportive environment.

What You’ll Do

• Develop and maintain features and data assets in the data environment by building robust data tables, facts, and dimensions that support business reporting and analysis.
• Write and optimise complex SQL queries to transform, model, and structure data in a Redshift environment for efficient use in reporting tools.
• Design and implement stored procedures to build new tables from scratch and enhance existing structures for long-term scalability and performance.
• Collaborate with Business Intelligence Analysts (BIBAs) to understand business requirements and translate them into efficient data structures and solutions.
• Work closely with BI Developers to ensure seamless integration between data infrastructure and Power BI reporting outputs.
• Participate in the solution design process, providing technical input to ensure data architecture supports both current and future business needs.
• Contribute to and maintain documentation related to data models, processes, and technical design to support maintainability and knowledge sharing.
• Ensure high standards of data integrity, governance, and security are maintained across all data assets.
• Demonstrate ownership and accountability in delivering accurate, reliable, and performant data solutions.
• Actively participate in code reviews and peer collaboration, fostering a learning-oriented, high-performing team environment.
  
  

What We Are Looking For

• 4 – 6 years of proven experience as Data Engineer or similar role.
• Solid experience with SQL and relational database systems.
• Familiarity with ETL/ELT processes and data transformation best practices
• Understanding of data modelling concepts (e.g. star/snowflake schemas, dimensional modelling).
• Experience working with large datasets in a structured data warehouse environment.
• Exposure to data governance, quality assurance, and performance optimization.
• Experience with cloud platforms (e.g., AWS, Azure, GCP) is ideal.
• Strong understanding of ETL/ELT processes and data modeling techniques.
• Familiarity with version control systems (e.g., Git) and CI/CD pipelines.
• Strong analytical and problem-solving skills with a high attention to detail
• A proactive, self-motivated attitude and willingness to take initiative
  
  

Education (Minimum)

• A relevant tertiary qualification in Information Technology or Data Analysis
  
  

If you are interested in being part of this dynamic team, on a mission to build the best bank in the world through unlocking the potential of its people, please apply. We would love to hear from you!

Capitec is committed to diversity and, where feasible, all appointments will support the achievement of our employment equity goals.