Product Data Engineer at Capitec Bank

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