Data Engineer - Intermediate

The Company  

We are entering a new era, with utilities worldwide transforming to meet business and sustainability targets. For over 35 years Gentrack has been partnering with the world’s leading utilities, and more than 60 energy and water companies rely on us. Gentrack, with our partners Salesforce and AWS, are leading today’s transformation with g2.0, an end-to-end product-to-profit solution. 

Our Values and Culture   

Colleagues at Gentrack are one big team, working together to drive efficiency in two of the planet’s most precious resources, energy, and water. We are passionate people who want to drive change through technology and believe in making a difference. Our values drive decisions and how we interact and communicate with customers, partners, shareholders, and each other. Our core values are: 

• Respect for the planet  

• Respect for our customers and  

• Respect for each other  

Gentrackers are a group of smart thinkers and dedicated doers.  We are a diverse team who love our work and the people we work with and who collaborate and inspire each other to deliver creative solutions that make our customers successful. We are a team that shares knowledge, asks questions, raises the bar, and are expert advisers. At Gentrack we care about doing honest business that is good for not just customers but families, communities, and
ultimately the planet. Gentrackers continuously look for a better way and drive quality into everything they do.  

This is a truly exciting time to join Gentrack with a clear growth strategy and a world class leadership team working to fulfil Gentrack’s global aspirations by having the most talented people, an inspiring culture, and a technology first, people centric business.  

The Opportunity 

As a Data Engineer, you will play a pivotal role in constructing a scalable and resilient data solution within our newly developed Data & Analytics platform. Your responsibilities involve leveraging your technical expertise to facilitate and construct solutions for deployment across numerous clients. Engaging in projects for diverse customers, you will tackle intricate challenges that demand a multifaceted skill set. Your role requires comprehensive comprehension of the entire spectrum, allowing you to design end-to-end solutions with a keen focus on meeting user and business requirements. Operating in the realm of B2B software and services, you will contribute to providing essential services to large-scale clients across the UK, NZ, Australia, and globally, aligning with our commitment to delivering and supporting cutting-edge technology. 

The Specifics   

• Create integration processes for data ingestion into Snowflake using Snowpipe, AWS SQS/SNS, and Snowflake events. 

• Design, build, and maintain Snowflake architecture, overseeing security, access control mechanisms, and data encryption. 

• Configure, set up, and administer AWS, including creating S3 buckets, IAM Roles, permissions, and policies. 

• Develop ETL/ELT processes for data model construction using SQL, Java script, and relevant ELT tools. 

• Lead capacity planning, scaling, backup, disaster recovery, and maintain documentation and knowledge sharing. 

• Adhere to the Compliance Policies and Procedures. 

• Ensure Health & Safety by reporting incidents and hazards promptly. 

• Fulfill any additional duties reasonably requested by your direct line leader. 

What we're looking for (you don’t need to be a guru at all,
we’re looking forward to coaching and collaborating with you): 

• Solid 5+ years Data Engineering experience. 

• Proficiency in data warehousing concepts, including data modeling, schema design, data loading, and data querying. 

• Experience with Snowflake or other cloud-based data warehousing platforms (e.g., Amazon Redshift, Google BigQuery, Firebolt, Databricks, etc.). 

• Familiarity with ELT/ETL tools such as Matillion, Informatica, or Talend. 

• Strong command of complex ANSI SQL queries. 

• AWS expertise in S3 setup, data storage, integration, data transfer, security, monitoring, and troubleshooting. 

• Optional proficiency in Python programming and JavaScript for ETL and procedures. 

• Customer-facing skills with the ability to participate in demos and workshops. 

• Quick learner, team player, independent, and motivated individual. 

• Bachelor's degree in Computer Science/Data Management or equivalent. 

• Can-do attitude. 

• Optimistic outlook with common sense and a sense of humor. 

• Passion for excellence and a commitment to be the best. 

• High levels of energy, sound judgment, and determination with a sense of urgency. 

• Exceptional attention to detail. 

• Excellent relationship management and interpersonal skills. 

• Open-minded consultative approach. 

• Ability to give and receive positive and constructive feedback. 

• Creative problem-solving skills. 

What we offer in return: 

• 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 

Gentrack want to work with the best people, no matter their background. So, if you are passionate about learning new things and keen to join the mission, you will fit right in.  

#LI-JB1