Snowflake Contract - Data & Analytics

Datacom; Wellington; On-site; NZD 150,000 - 190,000; Full time

Job summary

Datacom is seeking an experienced Senior Data Consultant with Snowflake expertise to lead the delivery of modern data platforms and BI solutions on a 6-month contract in New Zealand. The role requires hands-on delivery, stakeholder engagement, and the ability to hit the ground running.

You will design, build and optimise scalable data solutions, develop ETL/ELT pipelines, and implement Power BI semantic models, while collaborating with Datacom's Data & Analytics team and customers to drive value.

Qualifications

• 7+ years in enterprise data warehouse design and implementation.
• 7+ years ETL architecture and design experience.
• 7+ years dimensional data modelling (Star, Snowflake).
• Advanced Snowflake hands-on experience.
• Strong Azure and/or Microsoft Fabric experience.
• Experience with Coalesce, dbt, Matillion, Fivetran, and Azure/Fabric Data Factory.
• Advanced Python and SQL skills.
• 5+ years Power BI and semantic layer development.
• Strong Power Query and DAX capabilities.
• CI/CD pipelines, Git, DevOps, deployment automation.
• Strong consulting, stakeholder management and communication skills.
• SnowPro and Coalesce certs, or Azure/Fabric Data Engineer cert.

Responsibilities

• Lead design and delivery of modern data platforms and enterprise data warehouses.
• Gather and clarify requirements via stakeholder workshops.
• Design relational and dimensional data models for complex environments.
• Deliver Snowflake-based data solutions, including EDW migrations and integrations.
• Design and develop ETL/ELT pipelines and data integrations.
• Optimise data platforms for performance, scalability and cost.
• Develop Power BI solutions, semantic models, and self-service analytics.
• Support CI/CD, Git, DevOps, and deployment automation.
• Provide technical documentation, knowledge transfer and customer guidance.

Skills

Data warehouse design

ETL architecture

Dimensional modelling

Python

SQL

Power BI

Power Query

DAX

Git

CI/CD pipelines

Stakeholder management

Consulting skills

Education

Bachelor's degree in Computer Science or related field

SnowPro certification

Coalesce certification

Azure/Microsoft Fabric Data Engineer certification

Tools

Snowflake

Azure Data Services

Microsoft Fabric

Coalesce

dbt

Matillion

Fivetran

Azure Data Factory

Job description

About the Role

We're looking for an experienced Senior Data Consultant with extensive Snowflake expertise to join us on an initial 6-month contract engagement with an immediate start.

You’ll lead the technical delivery of modern data platform and BI solutions, working closely with customers and Datacom's Data & Analytics team to design, build, and optimise scalable data solutions.

This is a senior, hands‑on consulting role requiring someone who can hit the ground running and confidently engage with both technical teams and customer stakeholders.

To be considered, you must be based in New Zealand and have current New Zealand working rights. Immediate availability is strongly preferred.

What You'll Do

• Lead the design and delivery of modern data platforms and enterprise data warehouse solutions.
• Gather and clarify customer requirements through stakeholder workshops.
• Design relational and dimensional data models across complex data environments.
• Deliver Snowflake-based data solutions, including EDW migrations and integrations.
• Design and develop ETL/ELT pipelines and data integration solutions.
• Optimise data platforms for performance, scalability, and cost.
• Develop Power BI solutions, semantic models, and self‑service analytics.
• Support CI/CD, Git integration, DevOps, and deployment automation.
• Provide technical documentation, knowledge transfer, and customer guidance.

What You'll Bring

• 7+ years' experience in enterprise data warehouse design and implementation.
• 7+ years' experience in ETL architecture and design.
• 7+ years' experience in dimensional data modelling, including Star and Snowflake schemas.
• Advanced hands‑on Snowflake experience.
• Strong Azure and/or Microsoft Fabric experience.
• Experience with tools such as Coalesce, dbt, Matillion, Fivetran, and Azure/Fabric Data Factory.
• Advanced Python and SQL skills.
• 5+ years' experience with Power BI and semantic layer development.
• Strong Power Query and DAX capability.
• Experience with CI/CD pipelines, Git, DevOps, and deployment automation.
• Strong consulting, stakeholder management, and communication skills.
• SnowPro and Coalesce certification, or relevant Microsoft Azure/Fabric Data Engineer certification.
• Bachelor's degree in Computer Science or a related discipline.

Contract: Initial 6-month engagement
Location: New Zealand
Start: Immediate / ASAP
Work rights: Current New Zealand working rights required