Senior Consultant - Snowflake

Datacom; Christchurch; Hybrid; NZD 130,000 - 180,000; Full time

Benefits offered by this job

Remote working

Flexi-hours

Professional development

Social events

Job summary

Datacom is seeking a Senior Consultant to lead the technical delivery of large-scale data platforms and BI solutions across multiple New Zealand locations in a hybrid setup. You will design, implement and own data platform and insight solutions, working closely with client stakeholders and internal consultants.

Strong communication and leadership skills are essential for engaging with diverse teams. You will design data models, deploy AI-enabled data migrations, tune performance, and mentor

Qualifications

• Bachelor's degree or related discipline required and EDW design experience desirable.
• Proven track record building modern data platforms and enterprise data warehouses.
• Experience with Snowflake or Databricks, dataflow/pipelines, and data modelling concepts.
• Strong Python coding and cloud data engineering skills are expected.
• Ability to design and implement data warehouse migrations and AI-enabled data solutions.

Responsibilities

• Lead the technical delivery of large-scale data platforms and BI solutions.
• Design, implement and own data platform and insight delivery for clients.
• Engage with client stakeholders and internal teams to ensure successful outcomes.
• Design data models (relational and dimensional) across domains.
• Develop AI solutions for data migration, modelling and warehouse migrations.
• Perform performance tuning and optimization on data platforms and insights.
• Oversee development lifecycles using source control and deployment automation.
• Create self-service solutions using Power BI with diverse deployment options.
• Provide technical documentation and knowledge transfer to customers and teams.

Skills

Consultation

Stakeholder management

Communication

Data platform design

Snowflake

Databricks

Python

Cloud platforms (Azure/AWS)

Power BI

CI/CD / DevOps

Education

Bachelor's degree in Computer Science or related discipline

Snowpro / Coalesce or Azure/Fabric data engineer certification

Tools

Snowflake

Databricks

dbt

Azure Data Factory / Fabric

Coalesce

Fivetran / Matillion

Power BI

Python

Job description

Senior Consultant

Description

Senior Consultant

Datacom Location: Wellington, Christchurch, Hamilton, Auckland, hybrid set up, working three days a week from Datacom Office

Security Requirements: NZ Citizens and Residents Only, New Zealand Security Clearances are desirable.

Full Time, Permanent Position.

Our Purpose

Here at Datacom we connect people and technology in order to solve challenges, create opportunities and discover new possibilities for the communities we live in.

Our Team

The Data and Analytics team are a progressive group of diverse and creative individuals with a deep love for all things data related. They build platforms and solutions that are leading edge and at the forefront of the technology curve. A close knit and fun team embedded within our rapidly growing Professional Services division, and part of the wider Datacom ecosystem.

About The Role

As a Senior Consultant, you will lead the technical delivery of large-scale data platform and BI solutions. You will be asked to design, implement and own the delivery of robust Data Platform and Insight solutions. Our Senior Consultants work closely with your client stakeholders/teams and our internal Principal Consultants, Practice Leads, and Project Managers. This is a client facing role, so you'll need to be an excellent communicator with great engagement and presentation skills across a range of stakeholder levels.

What You’ll Do

• Working with clients (businesses users) to identify consulting opportunities, and eliciting stakeholders requirements through workshops facilitation.
• Contribute to the technical architecture, design and delivery for new modern data and insight platforms using innovative ideas and your proven experience in the latest trends for data-powered decision enablement.
• Provide thought leadership to our clients regarding data management and integration recommendations.
• Design data models (relational and dimensional modelling) across different data domains and industries.
• Design and deployment AI solutions for data migration, data modelling, application modernization and data warehouse migrations to name but a few.
• Ability to perform performance tuning and optimisation on new or existing data platforms and insight solutions.
• Manage development life cycles using various source code management tools including our AI modernisation techniques and products.
• Ability to design and develop customised self-service solutions using Power BI, with an in-depth knowledge of the different deployment options.
• Provide detailed technical documentation, end user training and knowledge-transfer services to customers, and internal teams.

Skills And Requirements

• Excellent consultation and stakeholder management skills.
• Excellent verbal and written communication skills.
• Proven track-record of designing and building modern data platforms including Enterprise Data Warehouse migration experience.
• Advanced and practical skills in Snowflake (dataflows, pipelines, Cortex/Coco) or Databricks (workflow, lakehouse flows, Autoloader), with deep experience in tools such as dbt, Azure/Fabric Data Factory, Coalesce and Fivetran or Matillion.
• Advanced and practical skills using Python
• Strong skills in cloud platforms including Azure and AWS.
• Strong skills in data platform design, implementation, configuration, performance and cost management (i.e. Fabric, Snowflake)
• Strong skills in Power BI, Power Query, SQL and DAX semantic data modelling.
• Advanced and practical skills using DevOps and knowledge of CI/CD pipelines, Git integration, and deployment automation.

Required Skills And Qualifications

• Bachelor's degree in Computer Science or related discipline
• Snowpro and Coalesce certified or Microsoft Azure/Fabric certified data engineer
• Minimum 7+ years’ experience in EDW design and implementation.
• Minimum 7+ years’ experience in ETL architecting and design.
• Minimum 7+ years’ experience in data modelling (Star schema & Snowflake schema)
• Minimum 5+ years’ experience in semantic layer development.
• Minimum 5+ years’ experience in Power BI

Why Join Us Here at Datacom?

Datacom is one of Australia and New Zealand’s largest suppliers of Information Technology professional services. We have managed to maintain a dynamic, agile, small business feel that is often diluted in larger organisations of our size. It's our people that give Datacom its unique culture and energy that you can feel from the moment you meet with us.

We care about our people and provide a range of perks such as social events, chill-out spaces, remote working, flexi-hours and professional development courses to name a few. You’ll have the opportunity to learn, develop your career, connect and bring your true self to work. You will be recognised and valued for your contributions and be able to do your work in a collegial, flat-structured environment.

We operate at the forefront of technology to help Australia and New Zealand’s largest enterprise organisations explore possibilities and solve their greatest challenges, so you will never run out of interesting new challenges and opportunities.

We want Datacom to be an inclusive and welcoming workplace for everyone and take pride in the steps we have taken and continue to take to make our environment fun and friendly, and our people feel supported.