Senior Data Engineer
Summary
Senior Data Engineer at Gentrack, a utility software provider, based in Auckland: lead the design and optimization of a scalable Data & Analytics platform for energy/water utility clients across APAC. Core stack is Snowflake (incl. Cortex AI), AWS, SQL, Python, JavaScript, Matillion, and ETL/ELT tooling, driving a shift from BI to AI-powered insights.
The Opportunity
- Support initiatives run by the GSTF and demonstrate our company values by providing a clear commitment to environmental and social responsibility.
- Contribute through identifying/proposing local sustainable practices and ideas in accordance with our Sustainability Charter.
- Utilise our sustainability app by taking part in challenges and improving behaviors to be more sustainable.
- Actively contribute to the data engineering platform, tools, and processes, ensuring they remain scalable, secure, and AI-ready.
- Lead the design, build, and optimisation of Snowflake architecture, integrating Snowflake Cortex AI for advanced analytics and natural language querying.
- Oversee code management CI/CD data engineering frameworks and release strategies in Bitbucket/Git, ensuring smooth deployments and environment consistency across regions and countries while safeguarding the global core model.
- Lead technical conversations with stakeholders to define AI use cases, set priorities, and align delivery plans with business outcomes.
- Mentor and coach engineers on integration techniques, modern data engineering practices, and solution design.
- Develop and manage robust ETL/ELT processes for data model construction using SQL, Python, JavaScript, Matillion, and AI-enabled transformation frameworks.
- Configure and administer AWS services (S3, IAM, Bedrock) for data storage, integration, and security.
- Implement and maintain disaster recovery plans, backup strategies, and high-availability configurations.
- Leverage tools like Qlik Replicate for large-scale, high-volume data ingestion and replication.
- Ensure all solutions meet compliance, privacy, and RBAC requirements, including encryption at rest and in transit.
- Maintain detailed documentation and foster knowledge sharing across data engineering practices.
- Advantage - Design and implement AI-driven data workflows using AWS Bedrock and other AI services to automate insights and predictions.
- Advantage - Migrate and evolve BI solutions into AI-enhanced dashboards, chat interfaces, and automated reporting tools.
- 8+ years of Data Engineering experience, with at least 3 years in a senior or lead capacity.
- Proven experience owning and evolving data engineering processes, tools, and platform standards to support AI and advanced analytics.
- Hands-on experience with Snowflake Cortex AI for natural language data querying, summarisation, and advanced analysis.
- Hands-on experience with Talend, AWS Data Migration Services, SnowSQL, Snowpipe, Snowpark
- Utilities/Energy sector knowledge advantageous
- Experience working in Data Consulting or professional services environments is an advantage
- Ability to lead conversations with stakeholders to define data strategies and deliverables.
- Experience converting BI solutions into AI-powered insights and self-service analytics tools.
- Strong track record of mentoring and coaching engineers in data engineering.
- Expertise in Snowflake, advanced ANSI SQL, and data-driven data transformation methods.
- Proficiency in Python and JavaScript for automation tasks.
- Experience managing Git/Bitbucket codebases, branching strategies, and release pipelines.
- Strong understanding of governance, compliance, data privacy, and secure data deployment.
- Bachelor’s degree in computer science, Data Management, or equivalent.
- Can-do attitude with a focus on delivering excellence.
- Optimistic outlook with common sense and a sense of humour.
- High levels of energy, sound judgment, and determination with a sense of urgency.
- Exceptional attention to detail.
- Excellent relationship management and interpersonal skills.
- Openminded consultative approach.
- Ability to give and receive positive and constructive feedback.
- Creative problem-solving skills.
- Personal growth – in leadership, commercial acumen and technical excellence
- To be part of a global, winning high growth organization – with a career path to match
- A vibrant, culture full of people passionate about transformation and making a difference -with a one team, collaborative ethos
- A competitive reward package that truly awards our top talent
- A chance to make a true impact on society and the planet
