Product Data Engineer

Capitec Bank; Bellville; On-site; ZAR 500,000 - 700,000; Full time

Job summary

Join Capitec Bank as a Product Data Engineer, where you'll develop robust data solutions using SQL and work in a collaborative environment. With a focus on innovation and continuous improvement, you'll play a significant role in enabling impactful business decisions through data insights. This position demands strong technical skills and a passion for data analysis, contributing directly to the mission of building the best bank in the world.

Benefits

Growth opportunities

Employee benefits and savings

Collaborative team environment

Qualifications

• 4-6 years of proven experience as Data Engineer or similar role.
• Experience with cloud platforms and version control systems.
• Proactive, self-motivated attitude with strong analytical skills.

Responsibilities

• Develop and maintain data assets and features for business reporting.
• Write and optimize complex SQL queries to structure data efficiently.
• Collaborate with analysts to translate requirements into data solutions.

Skills

SQL

Data transformation

Data modeling

Problem-solving

Attention to detail

Education

Relevant tertiary qualification in Information Technology or Data Analysis

Tools

Redshift

AWS

Git

Job description

Join Us in Becoming the Best Bank in the World!

We appoint energized and motivated people for their potential and continuously look for talented, driven individuals to help us innovate 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 people to 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 the Client first, act with Energy and take Ownership. And to support people in being their best, our Employee Value Proposition offers every value to all team members through cohesive teams, growth opportunities as well as employee benefits and savings. We make it a priority to ensure 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.