Snowflake Data Engineer (Lead Consultant)
Theta, New Zealand
Job Description
Our Data and Insights practice specialises in business intelligence strategy, consulting and large scale implementations in order to deliver complete, versatile data and analytics solutions allowing customers to leverage the value of their data.
We are looking for a Snowflake Consultant/Data Engineer to join our team. In in this role, you will using your skills to deliver Snowflake projects for enterprise clients across a range of industries. You will be responsible for the design and delivery of enterprise cloud data solutions that are scalable and fit for purpose. This is a full time, permanent position.
The right person for this role will have:
- Experience developing end to end data pipelines using technologies such as Snowflake, AWS, Google Cloud and/or Azure.
- An understanding of data architecture, data models, data migration, integration, analysis and visualisation
- Strong hands on experience delivering database solutions using advanced SQL, TSQL, Python, Scala etc.
- Knowledge of Cloud Data Warehousing technologies such as Snowflake, Azure SQL Data Warehouse and Databricks, AWS Redshift and Google Big Query
- Exposure to ETL/ELT and Governance tools such as Matillion, DBT, Alteryx, Collibra
- The ability to work with complex datasets and analyse modelled data to find actionable insights
The skills required are:
- A minimum of five years’ experience with the SQL Server BI stack
- Experience translating functional requirements into technical specifications
- Ability to develop new systems and provide end-user training
- High attention to detail and with the ability to analyse data
- Self-confidence and professional manner when working with key stakeholders as you understand and interpret requirements
- Excellent communication skills - both verbal and written
The Tech Stack:
- SQL Server BI
- Snowflake (not schema)
- Tableau/Power BI
- T-SQL, Python
- ETL development in SSIS
- AWS and/or Azure
We thrive on delivering excellence within a collaborative environment, where working hard and playing hard go hand-in-hand. Our exceptional people use cutting edge technology and innovation to achieve smarter solutions, together. With offices in Auckland, Tauranga, Wellington and Christchurch, we're making our mark across the length and breadth of New Zealand where the opportunities within Theta are endless!
Culture and Benefits
Theta offers a family friendly work environment with flexible work hours where practical; especially relevant for caregivers.
We embrace gender equality and are committed to providing a supportive, diverse and inclusive work environment throughout our workplace.
Theta is committed to giving back to the community and are avid supporters of Cure Kids. We compete in various adventure races and do many other things to raise money for Cure Kids. And we make time for the fun things in life!
We currently provide the following benefits to ensure your professional development and personal wellbeing:
- Professional growth and learning opportunities
- A competitive salary (commensurate with experience) plus KiwiSaver
- Fully subsidised medical insurance for employees
- Heavily discounted medical insurance for immediate family of employees
- Internal Referral Incentive
- Staff Assistance Programme
- Annual Flu injections
- Sick leave from your first day on board
- Remote working options where practical and mutually agreed
- Daily fresh fruit basket, coffee machine, wide selection of teas and biscuits in all of our offices.
Please note: Whilst we usually welcome overseas applicants, please be advised that due to the current circumstances as a result of COVID-19, we are only considering applicants who are currently residing in NZ or NZ Citizens/Residents returning home from overseas.
Please click on the APPLY NOW button if you have the right skills and experience.