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 has little or no prior experience in the position and is still developing relevant skills.

50th Percentile

130000

The candidate has an average level of experience and has most of the necessary skills.

75th Percentile

145000

The candidate has above-average experience, has most or all the necessary skills and may have specialised qualifications.

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

Position title

25th Percentile

50th Percentile

75th Percentile

Database Administrator

100000

115000

125000

Explore more salaries

Explore exclusive insights

Hiring? Start here.

Access hundreds of skilled contract and permanent candidates at every level from support roles to C-suite, and pinpoint the talent you need using our industry-leading matching technology.

Find your next hire