Senior Consultant - Snowflake

About Datacom

Datacom is one of Australasia's foremost technology providers, blending technology expertise and skilled personnel to support organizations in navigating rapid change. Serving governments, enterprises, and growing businesses, they focus on delivering meaningful results for clients, communities, and employees alike.

Team Overview

The Data and Analytics division includes a creative, diverse team passionate about data. They construct advanced, cutting-edge data platforms and solutions within Datacom’s expanding Professional Services group.

Role Summary

The Senior Consultant leads technical execution of extensive data platforms and business intelligence solutions. This role involves designing, implementing, and taking ownership of robust data and insight solutions. Close collaboration and communication with clients, internal Principal Consultants, Practice Leads, and Project Managers is essential, as this is a client-facing position requiring excellent presentation and engagement skills across multiple stakeholder levels.

Key Responsibilities

• Collaborate with business users to uncover consulting opportunities and gather requirements through workshops.
• Contribute technically to architecture, design, and delivery of modern data platforms and insight solutions using innovative, current data-driven techniques.
• Provide expert guidance on data management and integration strategies to clients.
• Design relational and dimensional data models across various domains and industries.
• Develop AI-enabled solutions for data migration, modeling, application modernization, and data warehouse migration tasks.
• Perform performance tuning and optimization of both new and existing data platforms and insights solutions.
• Manage software development lifecycles utilizing version control and AI modernisation products.
• Design and build custom self-service analytics solutions with Power BI, understanding various deployment methods.
• Deliver comprehensive technical documentation, training, and knowledge transfer to clients and internal teams.

Required Skills and Experience

• Exceptional consulting and stakeholder engagement abilities.
• Strong verbal and written communication skills.
• Demonstrated success in designing and deploying modern data platforms, including enterprise data warehouse migration.
• Advanced hands-on expertise with Snowflake tools (dataflows, pipelines, Cortex/Coco) or Databricks components (workflows, lakehouse flows, Autoloader) and familiarity with dbt, Azure/Fabric Data Factory, Coalesce, Fivetran, or Matillion.
• Advanced proficiency in Python programming.
• Strong experience in cloud environments such as Azure and AWS.
• Extensive skills in data platform architecture, configuration, performance, and cost optimization, especially with Fabric and Snowflake.
• Proficient in Power BI, Power Query, SQL, and DAX semantic modeling.
• Strong understanding and practical use of DevOps methodologies, CI/CD pipelines, Git integration, and deployment automation.

Qualifications

• Bachelor’s degree in Computer Science or a related field.
• Certifications such as SnowPro, Coalesce, or Microsoft Azure/Fabric Data Engineer.
• At least 7 years of experience in enterprise data warehouse design and implementation.
• Minimum 7 years in ETL architecture and design.
• At least 7 years of expertise in data modeling (Star and Snowflake schemas).
• Minimum 5 years of experience developing semantic layers.
• At least 5 years working with Power BI.

Work Environment and Culture

Join a supportive team focused on career growth, well-being, and meaningful impact. Datacom offers industry-leading learning and development, parental leave, wellbeing resources, and employee-centric benefits to foster personal and professional success.

Why Work Here

• Paid parental leave
• 24/7 Employee Assistance Program (DataCare)
• Continuous learning, certifications, and career development
• Access to premier learning resources and future skills training
• Recognition programs celebrating outstanding contributions
• Employee discounts and financial wellness benefits
• Opportunity for impactful, meaningful work

Additional Details

Locations include Wellington, Christchurch, Hamilton, and Auckland with a hybrid work setup requiring three days per week onsite. Employment is full-time and permanent. Security requirements restrict applicants to New Zealand citizens and residents; relevant security clearances are favorable.