Senior Data Consultant - Snowflake

About the role

Datacom is looking for an experienced Senior Data Consultant with extensive Snowflake expertise to join an initial 6-month contract with an immediate start. You will lead the technical delivery of modern data platform and BI solutions, working closely with customers and the Data & Analytics team to design, build and optimise scalable data solutions. The role is senior and hands-on, and you must be based in New Zealand with current working rights.

Key responsibilities

• 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 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.

Required profile

• 7+ years in enterprise data warehouse design and implementation.
• 7+ years in ETL architecture and design.
• 7+ years 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 with Power BI and semantic layer development.
• CI/CD, Git, DevOps and deployment automation experience.
• SnowPro and Coalesce certification, or a relevant Microsoft Azure/Fabric Data Engineer certification.
• Bachelor's degree in Computer Science or a related discipline.