Product Data Engineer

Capitec Bank Ltd.; Bellville; On-site; ZAR 450,000 - 600,000; Full time

Job summary

A leading banking institution is seeking a Product Data Engineer to join their dynamic team. The role involves developing data solutions using SQL and collaborating with Business Intelligence Analysts to enhance reporting capacity. This position is ideal for individuals passionate about data and eager to contribute to impactful business decisions. Candidates should possess significant experience with SQL and data modeling concepts and have a relevant qualification in Information Technology or Data Analysis.

Qualifications

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

Responsibilities

• Develop and maintain features and data assets in the data environment.
• Write and optimise complex SQL queries for reporting tools.
• Collaborate with BI Analysts to translate business requirements into data structures.

Skills

SQL

Data Modeling

Problem-Solving

Education

Relevant tertiary qualification in Information Technology or Data Analysis

Tools

Cloud platforms (AWS, Azure, GCP)

Version control systems (Git)

Job description

Press Tab to Move to Skip to Content Link

Select how often (in days) to receive an alert:

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.

Capitec Bank is an authorised financial services provider (FSP 46669) and registered credit provider (NCRCP13). Capitec Bank Limited Reg. No: 1980/003695/06