Product Data Engineer

Bellville, Cape Town
Permanent
Full-time

9 days ago

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 AreWe 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 UsAt 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/TeamJoin 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

Apply Now