Databricks Data Platform Engineer - Power BI & ELT Expert

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

Benefits offered by this job

Wellbeing allowance

Free nurse consults

Free annual flu vaccinations

Fresh fruit baskets

Leave support

Job summary

Tonkin + Taylor in Auckland is seeking an experienced Data Platform & Analytics Engineer to develop and enhance our Databricks Enterprise data platform. You will work within the BI team to engineer scalable, well-governed data pipelines using Databricks and dbt, delivering trusted datasets for reporting and decision-making.

This engineering-focused role involves collaborating with BI Developers, Data Analysts and Technology teams to establish standards and patterns, ensure data quality, and help

Qualifications

• 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

Advanced SQL

Enterprise data warehouse

Dimensional modelling

Delta Lake

Azure data services

Python for data eng

Data quality testing

Git & CI/CD

Analytics-ready datasets

Analytical & problem-solving

Documentation & mentoring

Education

Tertiary qualification in data engineering or related

Tools

Databricks

dbt

Power BI

Git

CI/CD tooling

Job description

Tonkin + Taylor in Auckland is seeking an experienced Data Platform & Analytics Engineer to develop and enhance our Databricks Enterprise data platform. You will work within the BI team to engineer scalable, well-governed data pipelines using Databricks and dbt, delivering trusted datasets for reporting and decision-making.

This engineering-focused role involves collaborating with BI Developers, Data Analysts and Technology teams to establish standards and patterns, ensure data quality, and help