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