Senior Consultant - Snowflake

About the role

Datacom is hiring a Senior Consultant for its Data and Analytics team, which builds platforms and solutions for clients across industries. The role leads the technical delivery of large-scale data platform and BI solutions, designing, implementing and owning them. It is client-facing and requires strong communication and presentation skills. The position is full time and permanent, with a hybrid setup of three days per week in the office, and is open to Wellington, Christchurch, Hamilton and Auckland.

Key responsibilities

• Work with business users to identify consulting opportunities and elicit requirements through workshops
• Contribute to the technical architecture, design and delivery of modern data and insight platforms
• Provide thought leadership on data management and integration recommendations
• Design relational and dimensional data models across domains and industries
• Design and deploy AI solutions for data migration, modelling, application modernisation and data warehouse migrations
• Tune and optimise performance of data platforms and insight solutions
• Manage development lifecycles with source code management tools and AI modernisation techniques
• Build custom self-service solutions in Power BI and provide technical documentation, training and knowledge transfer

Required profile

• Bachelor's degree in Computer Science or a related discipline
• NZ citizens and residents only; security clearances are desirable
• Proven track record designing and building modern data platforms, including enterprise data warehouse migration
• Minimum 7 years' experience in EDW design and implementation, ETL architecting and data modelling (star and Snowflake schemas)
• Minimum 5 years' experience in semantic layer development and Power BI

Required skills

• Snowflake (dataflows, pipelines, Cortex/Coco) or Databricks (lakehouse flows, Autoloader)
• dbt, Azure/Fabric Data Factory, Coalesce, Fivetran or Matillion
• Python, Azure and AWS
• Power BI, Power Query, SQL and DAX
• DevOps, CI/CD pipelines, Git and deployment automation

What we offer

• Paid parental leave and 24/7 employee assistance programme
• Ongoing learning, certifications and career development
• Employee discounts and financial wellbeing benefits