Data Platform & Analytics Engineer | Databricks | PowerBI

Tonkin & Taylor; Auckland; On-site; NZD 120,000 - 180,000; Full time

Benefits offered by this job

Wellbeing allowance

24/7 nurse consults

Free annual flu vaccinations

Fresh fruit baskets

Leave support for wellbeing

Job summary

Tonkin + Taylor is seeking an experienced Data Platform & Analytics Engineer to develop and continually improve our Databricks Enterprise data platform. You will engineer robust data transformation pipelines using dbt, integrate data from multiple systems, and build trusted enterprise data models to support reporting and analytics.

The role sits in the Business Intelligence team and partners with BI Developers, Data Analysts and Technology teams to establish engineering standards, optimise

Qualifications

• Strong experience developing data transformation pipelines using dbt (Data Build Tool) or an equivalent framework.
• Advanced SQL development skills, including complex transformations, query optimisation and performance tuning.
• Proven experience building enterprise data warehouses and cloud-based ELT pipelines.
• Strong knowledge of dimensional data modelling, including star schemas, fact tables, dimension tables and slowly changing dimensions.
• Practical understanding of Delta Lake, Medallion Architecture and layered data platforms.
• Experience working with Azure data services and modern cloud data warehousing technologies
• Working knowledge of Python for data engineering and automation.
• Experience implementing data quality testing, reconciliation, validation and monitoring processes.
• Experience using Git, CI/CD and version-controlled development practices.
• An understanding of how to develop trusted, analytics-ready datasets for Power BI and other reporting tools.
• Ability to work independently under broad direction and exercise sound technical judgement. Strong analytical, problem-solving and technical communication skills.
• Excellent attention to detail and a commitment to delivering reliable, tested, maintainable and well-documented solutions.
• A relevant tertiary qualification or equivalent practical experience in data engineering, computer science, information systems or a related discipline.

Responsibilities

• Develop and maintain data transformation pipelines using dbt within Databricks.
• Design and implement scalable ELT solutions using the Databricks Medallion Architecture (Bronze, Silver and Gold).
• Integrate data from multiple operational systems into a governed enterprise data warehouse.
• Build, optimise and support trusted enterprise data models using dimensional modelling best practices, including fact tables, dimension tables and conformed dimensions.
• Develop reusable, well-tested and documented transformation logic using dbt tests and other appropriate data quality frameworks.
• Optimise advanced SQL transformations for performance, scalability and maintainability.
• Implement incremental processing strategies and optimise Delta Lake performance.
• Ensure datasets are accurate, complete and aligned with business requirements through reconciliation and validation against source systems.
• Investigate and resolve data quality issues and transformation failures.
• Monitor data pipeline performance and identify opportunities for continuous improvement.
• Support the ongoing development of the enterprise semantic data layer.
• Play a key role in migrating existing Power BI transformation logic into Databricks.
• Partner with BI Developers, Data Analysts and Technology teams to provide trusted, analytics-ready datasets for reporting and analysis.
• Contribute to engineering standards and reusable patterns through code reviews, technical advice, documentation, knowledge sharing and informal mentoring.

Skills

dbt

Databricks

SQL

Python

Power BI

Dimensional modeling

Delta Lake

Cloud data warehousing

Git & CI/CD

Analytical thinking

Education

Bachelor's degree in data engineering or related

Tools

Databricks

dbt

Power BI

Delta Lake

Job description

Jora New Zealand will close on 16th September 2026. Thank you for being with us, we are cheering you on as you continue your career journey.

Tonkin + Taylor is New Zealand's leading engineering and environmental consultancy, renowned for our technical excellence in solving complex challenges. We are proudly a New Zealand, employee-owned company and our collective mission is to create and sustain a better world.

We are seeking an experienced Data Platform & Analytics Engineer to develop and continually improve our Databricks Enterprise data platform. Working within the Business Intelligence team, you will engineer robust, scalable and well-governed data transformation pipelines using Databricks and dbt, delivering trusted datasets for reporting, analytics and operational decision-making.

This is an engineering-focused role, with occasional support for reporting and insights development where required. You will work closely with BI Developers, Data Analysts and Technology teams to establish engineering standards and best practices that enable our analytical capability to scale sustainably.

Success in this role will be measured through the quality, reliability, maintainability and performance of the data models, transformation pipelines and reporting datasets delivered through the Databricks platform and Power BI environment

• Develop and maintain data transformation pipelines using dbt within Databricks.
• Design and implement scalable ELT solutions using the Databricks Medallion Architecture (Bronze, Silver and Gold).
• Integrate data from multiple operational systems into a governed enterprise data warehouse.
• Build, optimise and support trusted enterprise data models using dimensional modelling best practices, including fact tables, dimension tables and conformed dimensions.
• Develop reusable, well-tested and documented transformation logic using dbt tests and other appropriate data quality frameworks.
• Optimise advanced SQL transformations for performance, scalability and maintainability.
• Implement incremental processing strategies and optimise Delta Lake performance.
• Ensure datasets are accurate, complete and aligned with business requirements through reconciliation and validation against source systems.
• Investigate and resolve data quality issues and transformation failures.
• Monitor data pipeline performance and identify opportunities for continuous improvement.
• Support the ongoing development of the enterprise semantic data layer.
• Play a key role in migrating existing Power BI transformation logic into Databricks.
• Partner with BI Developers, Data Analysts and Technology teams to provide trusted, analytics-ready datasets for reporting and analysis.
• Contribute to engineering standards and reusable patterns through code reviews, technical advice, documentation, knowledge sharing and informal mentoring.

You will be an experienced Data Engineer with commercial experience delivering modern data solutions in enterprise or cloud environments. You will bring strong technical capability, sound judgement and a commitment to developing reliable, maintainable and well-governed data products.

• Strong experience developing data transformation pipelines using dbt (Data Build Tool) or an equivalent framework.
• Advanced SQL development skills, including complex transformations, query optimisation and performance tuning.
• Proven experience building enterprise data warehouses and cloud-based ELT pipelines.
• Strong knowledge of dimensional data modelling, including star schemas, fact tables, dimension tables and slowly changing dimensions.
• Practical understanding of Delta Lake, Medallion Architecture and layered data platforms.
• Experience working with Azure data services and modern cloud data warehousing technologies
• Working knowledge of Python for data engineering and automation.
• Experience implementing data quality testing, reconciliation, validation and monitoring processes.
• Experience using Git, CI/CD and version-controlled development practices.
• An understanding of how to develop trusted, analytics-ready datasets for Power BI and other reporting tools.
• Ability to work independently under broad direction and exercise sound technical judgement. Strong analytical, problem-solving and technical communication skills.
• Excellent attention to detail and a commitment to delivering reliable, tested, maintainable and well-documented solutions.
• A relevant tertiary qualification or equivalent practical experience in data engineering, computer science, information systems or a related discipline.

At T+T,you’llbe joining a people-focused business where learning, wellbeing, flexibility, and career development matter.

• Supporting wellbeing: An annual wellbeing allowance, access to 24/7 free nurse consults, free annual flu vaccinations, fresh fruit baskets, and additional leave support when you need it.
• Inclusion and sustainable by design:Cultural capability training, accessible ways of working, Gender Tick and Rainbow Tick accreditation, and a clear commitment to sustainability, including Net Zero Carbon certification.
• Investment in your growth:Access to mentoring and leadership development, exposure to a wide range of professional experts and projects, professional memberships, and funded training aligned to your development goals.
• Support through life’s big moments:Primary carer salarytop‑upsfor 26 weeks, paid partnerleaveup to 4 weeks,back‑to‑workcoaching, andlong‑serviceleave.

At T+T, you'll be part of a collaborative and supportive environment where people are encouraged to grow, innovate, and make an impact.

Our value ‘Everyone Matters’ is at the heart of what we do. We’re proud to be an Immigration New Zealand Accredited Employer and a member of Diversity Works. We warmly welcome all applicants, your voice and perspective are valued here.

If you want a role where your work has a visible impact,and where care, judgement, and continuous improvement are valued,we’dlove to hear from you.