Senior Data Engineer / Consultant – Microsoft Fabric

ICM Asia Pacific; Auckland; On-site; NZD 120,000 - 170,000; Full time

Job summary

Adaptiv in Auckland seeks a Senior Data Engineer / Data Consultant focused on Microsoft Fabric. You will design, build and deliver modern data platforms, working closely with clients to translate business needs into scalable data solutions.

You will lead engineering work across Lakehouses, Warehouses and OneLake, employing Python, PySpark and SQL to implement robust data pipelines and governance within the Microsoft Data ecosystem.

Qualifications

• 6+ years of experience in data engineering and platforms.
• Hands-on production data engineering in the Microsoft ecosystem.
• Experience with Fabric Lakehouse, Warehouse, OneLake, and Data Factory pipelines.
• Strong Python, PySpark and SQL capabilities.
• Experience designing ETL/ELT pipelines and modern data architectures.

Responsibilities

• Design, build and optimise modern data platforms using Microsoft Fabric.
• Develop Lakehouse and Warehouse solutions with OneLake.
• Create scalable data ingestion and transformation pipelines.
• Develop data engineering solutions using Python, PySpark and SQL.
• Implement modern architecture patterns and robust data models.
• Work with Azure Data Factory, Data Lake and Azure SQL where relevant.
• Apply DevOps practices: Git, CI/CD, automated deployment.
• Ensure data quality, testing, validation and monitoring in production.

Skills

Data Engineering

Data Platforms

Microsoft Fabric

Python

PySpark

SQL

DevOps practices

Client engagement

Education

Bachelor's in CS/SE or related field

Tools

Databricks

OneLake

Azure Data Factory

Azure Data Lake

Git

Job description

About Us

Adaptiv is a Kiwi success story with a growing presence across Australia and New Zealand. We specialise in integration, data and analytics, AI consulting and cloud solutions, helping organisations modernise their technology environments and unlock greater value from their data.

Our teams work with leading technologies including Microsoft Fabric, Microsoft Azure, Databricks, MuleSoft, Boomi and Solace to solve complex business and technology challenges.

What sets Adaptiv apart is our combination of deep technical capability and genuine consulting expertise. We work closely with our clients to understand their challenges, design pragmatic solutions and deliver technology that creates meaningful business outcomes.

As our Data Practice continues to grow, we're looking for an experienced Senior Data Engineer / Data Consultant – Microsoft Fabric to join our team in Auckland.

About the Role

This is a senior, hands-on consulting role for someone who combines strong Data Engineering capability with the confidence to work directly with clients.

You’ll help design, build and deliver modern data platforms and engineering solutions, with a particular focus on Microsoft Fabric and the wider Microsoft Data ecosystem.

You’ll work across client engagements, collaborating with architects, consultants and engineering teams to translate business requirements into scalable, production-ready data solutions.

This isn't a role where you'll simply provide technical oversight. You'll remain close to the technology designing solutions, building pipelines, working with Lakehouses and Warehouses, developing transformations, solving complex engineering problems and helping ensure the quality of what we deliver.

You’ll also play an important role in supporting and mentoring other engineers as our Data Practice continues to grow.

What You'll Be Doing

• Designing, building and optimising modern data platforms using Microsoft Fabric.
• Building and maintaining Fabric Lakehouse and Warehouse solutions using OneLake.
• Developing scalable data ingestion and transformation pipelines using Fabric Data Factory, notebooks and Spark.
• Developing data engineering solutions using Python, PySpark and SQL.
• Designing and implementing modern Lakehouse and Medallion architecture patterns.
• Building robust data models for analytics, reporting and downstream consumption.
• Working across the broader Microsoft Data ecosystem, including technologies such as Azure Data Factory, Azure Data Lake and Azure SQL where appropriate.
• Applying software engineering and DevOps practices including Git, CI/CD, automated deployment and environment management.
• Implementing testing, data validation, monitoring and performance optimisation to ensure reliable production data solutions.
• Applying appropriate security, governance and data management practices across Fabric environments.
• Working directly with clients to understand requirements and translate business needs into pragmatic technical solutions.
• Leading technical discussions and communicating engineering concepts to technical and non-technical stakeholders.
• Collaborating with architects and other consultants on solution design, estimation, scoping and delivery planning.
• Identifying delivery risks, communicating progress and helping resolve technical blockers.
• Conducting peer reviews and supporting high standards across code, documentation and engineering practices.
• Mentoring junior and intermediate engineers and contributing to knowledge sharing across the Data Practice.
• Helping improve Adaptiv's reusable frameworks, delivery patterns, templates and engineering standards.
• Staying current with developments across Microsoft Fabric, Azure, Databricks, AI/ML and the broader modern data ecosystem.

What You'll Bring

We're looking for someone with a strong Data Engineering foundation who is equally comfortable building solutions and engaging with clients.

Ideally, you'll bring:

• 6+ years' professional experience across Data Engineering, Data Platforms or a closely related discipline.
• Strong hands-on experience delivering production Data Engineering solutions within the Microsoft Data ecosystem.
• Commercial experience designing and delivering solutions using Microsoft Fabric.
• Practical experience across Fabric capabilities such as Lakehouse, Warehouse, OneLake, Data Factory pipelines, notebooks and Spark.
• Strong Python, PySpark and SQL capability.
• Experience designing and developing ETL/ELT pipelines and complex data transformations.
• A good understanding of modern data architecture patterns, including Medallion architecture and scalable Lakehouse design.
• Strong data modelling knowledge, including dimensional, Star and Snowflake modelling approaches.
• Experience with Microsoft Azure data services, such as Azure Data Factory, Azure Data Lake, Azure SQL or related technologies.
• Experience applying DevOps and software engineering practices including version control, Git, CI/CD and automated deployment.
• Experience implementing testing, data quality and validation practices within production data environments.
• An understanding of data governance, security and access control within modern enterprise data platforms.
• Familiarity with analytics and data consumption technologies such as Power BI, including how engineered data platforms support downstream analytics.
• Strong communication skills and the confidence to work directly with clients and senior stakeholders.
• Experience working within consulting, professional services or client-facing delivery environments, or demonstrable experience operating in a similar capacity.
• The ability to work autonomously while collaborating effectively across multidisciplinary delivery teams.

Exposure to Databricks and other modern cloud data platforms would be advantageous but isn't essential.

Relevant Microsoft certifications, particularly Microsoft Certified: Fabric Data Engineer Associate (DP-700), Azure Data certifications or equivalent, are highly regarded. However, we’re equally interested in candidates who can demonstrate strong hands-on commercial Fabric delivery experience.

The Person We're Looking For

Technical capability matters, but we’re looking for more than someone who knows Microsoft Fabric.

You’ll enjoy working with customers, asking the right questions and understanding the problem behind the technical requirement.

You’ll be comfortable moving beyond dashboards and reporting into the engineering foundations of modern data platforms designing how data is ingested, transformed, governed and made available for analytics and other downstream use cases.

You’ll be comfortable taking ownership of your work, making pragmatic engineering decisions and explaining those decisions clearly to others.

You’ll enjoy helping other engineers develop and won’t be afraid to challenge an approach when you believe there’s a better way.

Most importantly, you’ll want to remain hands-on while continuing to grow as a consultant and senior technical professional.

Why Adaptiv?

You’ll join a growing Data Practice where you’ll have the opportunity to influence how we deliver, not simply inherit established processes.

You’ll work with modern technologies, interesting clients and experienced people across Data, Integration, Cloud and AI.

We offer an environment where technical curiosity is encouraged, good ideas are heard and people are trusted to take ownership.

If you're an experienced Data Engineer looking for a role that combines hands-on Microsoft Fabric engineering, client engagement and genuine consulting responsibility, we'd love to hear from you.