Data & Analytics Principal Consultant

Datacom; New Zealand; On-site; NZD 130,000 - 160,000; Full time

Job summary

A leading IT services provider in New Zealand is seeking a Principal Consultant in Data & Analytics to lead technical delivery and client engagements. The role involves designing robust Data Platform solutions and mentoring developers. Candidates should have extensive experience in ETL processes and cloud platforms. Join a vibrant team dedicated to leveraging data for impactful solutions. This position offers a dynamic work environment and numerous professional development opportunities.

Benefits

Social events

Remote working

Flexi-hours

Professional development courses

Qualifications

• 8+ years’ experience in EDW design and implementation.
• 8+ years’ experience in ETL architecting and design.
• 8+ years’ experience in data modelling (Star schema & Snowflake schema).
• Experience in Microsoft SQL server technologies including SSIS, SSRS.
• 5+ years’ experience in semantic layer development.

Responsibilities

• Lead client presentations to articulate value.
• Identify upselling opportunities within existing accounts.
• Lead technical architecture for new Data Platform solutions.
• Provide thought leadership on data and integration.

Skills

Engagement with senior stakeholders

Pre-sales solutioning

Data solutions in cloud platforms

ETL/ELT process design

Data modelling

Performance tuning

Client management skills

Education

Bachelor's degree in Computer Science

Tools

Azure

AWS

GCP

Snowflake

Power BI

Job description

Position: Principal Consultant Data & Analytics

Datacom Location: UPDATE - Wellington Only

Security Requirements: NZ Citizens and Residents Only

Full Time, Permanent Position.

Our Why

Datacom works with organisations and communities across Australia and New Zealand to make a difference in people’s lives and help them to use the power of tech to innovate and grow.

About the Role (Your Why)

As a Principal Consultant, you will not only lead technical delivery but also play a key role in shaping client solutions that drive business outcomes and support pre‑sales engagements.

You will be asked to design, implement and own the delivery of robust Data Platform solutions and end‑to‑end components. This is a client focused role, so you'll need to be an excellent communicator and good with people. The Principal Consultant works closely with practice leads, project managers, and client stakeholders and teams.

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.

What You’ll Do

• Collaborate with sales and account teams to shape proposals and solution designs during pre‑sales engagements.
• Lead client presentations and solution walkthroughs to articulate value and differentiation.
• Identify opportunities for upselling and expanding service offerings within existing accounts.
• Facilitate stakeholder workshops to gather and clarify business requirements.
• Lead the technical architecture, design and delivery for new Modern Data Platform solutions.
• Provide overall thought leadership to our clients regarding data profiling and integration recommendations.
• Provide thought leadership around the effective use of AI in the data platform landscape.
• Data modelling (relational and dimensional and Snowflake schema).
• Perform performance tuning/optimisation, and feature audits on data platform solutions.
• Provide detailed documentation, end user training and knowledge‑transfer services to clients, and internal teams.
• Mentor developers, acting as an SME in data platform/warehouse architectures and data modelling.

What You’ll Bring

• Proven ability to engage with senior stakeholders and influence buying decisions.
• Experience in pre‑sales solutioning, proposal development, and client presentations.
• Commercial acumen and ability to align technical solutions with business value.
• Strong consultation and client management skills.
• Advanced skills and a proven track‑record of building data solutions in cloud platforms such as Azure, AWS & GCP.
• Advanced skills in one or more data platforms such Azure, Fabric, Snowflake and Databricks.
• Advanced ETL/ELT process design and implementation with tools such as Synapse Analytics, Azure/Fabric Data Factory, Snowflake, Coalesce, Fivetran, Matillion, dbt and AWS Glue.
• Advanced data modelling skills (Star schema, Snowflake schema, data vault).
• Advanced skills in performance tuning, query plan, query plan analysis, indexing, table partitioning.
• Experience using Informatica IDMC or on‑prem solutions.

Experience and Qualifications

• Bachelor's degree in Computer Science or related discipline.
• Minimum 8+ years’ experience in EDW design and implementation.
• Minimum 8+ years’ experience in ETL architecting and design.
• Minimum 8+ years’ experience in data modelling (Star schema & Snowflake schema).
• Minimum 8+ years’ experience in various Microsoft SQL server technologies including SSIS, SSRS, SQL Server Analysis Services.
• Minimum 5+ years’ experience in semantic layer development.
• Minimum 3+ 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.