Data Warehouse Consultant

Data Warehouse Consultant job description

The Data Warehouse Consultant designs, implements, and optimises data warehousing solutions to support enterprise reporting, analytics, and business intelligence needs. This role ensures data integrity, performance, and security, while aligning with New Zealand data governance and regulatory standards.

Data Warehouse Consultant duties and responsibilities of the job

Key responsibilities of a Data Warehouse Consultant include:

Designing and building scalable data warehouse architectures to support business intelligence and reporting

Developing ETL processes to extract, transform, and load data from multiple sources

Ensuring data models support performance, flexibility, and accurate analytics outputs

Collaborating with stakeholders to understand reporting requirements and translate them into data warehouse solutions

Implementing data governance, access control, and audit mechanisms in compliance with the NZ Privacy Act and ISO 27001

Optimising query performance and monitoring system health to ensure uptime and data availability

Supporting data validation, cleansing, and transformation to ensure consistent and reliable datasets

Documenting technical architecture, data lineage, and operational procedures for transparency and audit readiness

Data Warehouse Consultant job qualifications and requirements

A degree in data science, computer science, or information systems is required.

Requirements include:

5+ years’ experience in data warehousing or data engineering roles

Strong experience with data warehouse platforms (e.g. Snowflake, SQL Server, Amazon Redshift, Google BigQuery)

Proficiency in ETL tools and scripting languages (e.g. Azure Data Factory, SSIS, Python)

Solid understanding of dimensional modelling, star/snowflake schemas, and data architecture principles

Familiarity with New Zealand data privacy and compliance frameworks

Strong SQL and performance tuning skills

Excellent communication and stakeholder engagement abilities

Find data warehouse consultant talent. Find data warehouse consultant jobs.

Submit your resume or request talent now and our expert recruiters will be with you shortly.

Robert Half can assist you with your data warehouse consultant staffing needs.

Salary for Data Warehouse Consultant

110000 - 145000

25th percentile

110000

The candidate is new to the role or has limited experience and is building necessary skills.

50th percentile

130000

The candidate has moderate experience in the role, meets most requirements or has equivalent transferable skills, and may also have relevant certifications.

75th percentile

145000

The candidate has extensive experience and advanced skills for the role, and may also have specialised certifications.

Salary range based on three percentiles The starting salaries represent gross yearly salaries. They do not include bonuses, benefits or KiwiSaver.

Projected salaries for related positions

Job title

25th percentile

50th percentile

75th percentile

Data Architect

160000

170000

185000

Business Intelligence Analyst

95000

110000

130000

Business Intelligence Developer

120000

135000

145000

Business Intelligence Manager

140000

155000

180000

Database Administrator

100000

115000

125000

Data Scientist

120000

140000

160000

Senior Data Scientist

160000

180000

200000

Data Engineer

125000

135000

150000

Senior Data Engineer

160000

180000

200000

Explore more salaries

Newest jobs

Infrastructure Engineer

Software Developer (WPF)

Systems Engineer

Looking to hire? Start here.

Access the skilled permanent and contract talent you need, from support roles to C-suite, with precision matching powered by Robert Half recruiters leveraging their experience together with our industry-leading AI technology.

Hire talent

More to explore

2026 Salary Guide Explore our Salary Guide to confidently benchmark 100+ salaries, plan your budgets and better understand compensation trends.

How to successfully negotiate your salary this year Discover salary trends, key negotiation strategies, and a salary negotiation email sample to help you secure the pay you deserve.

What are non-monetary benefits and why do they matter? Discover why non-monetary benefits like flexibility, training, and recognition are essential for retaining top talent in New Zealand.

How to make a cover letter that stands out in New Zealand Standing out in New Zealand’s competitive job market requires a captivating a cover letter that complements your resume and grabs the hiring manager’s attention. This blog post will equip you with the essential steps to make a cover letter that stands out.

How to improve your adaptability skills Adaptability skills can be possessed both in both attitude and action. Learn how to improve your adaptability skills for your career.

Our starting salary projections come from a detailed, multistep process that ensures our numbers accurately reflect the marketplace. They’re based on real compensation data for job candidates our recruiters have matched with companies across the country.

The Salary Guide from Robert Half is the original. We’ve been publishing salary forecasts since 1950, and our guide has served as a trusted source for employers, job seekers, industry associations, government and educational institutions, and national and local media.