Data Integration Engineer

Location: Auckland, Auckland, nz

Company Description

Abano Healthcare is the largest dental support organisation (DSO) across Australia and New Zealand, with more than 220 practices and over 700 clinicians. As the engine behind well‑known brands such as Lumino the Dentists, Maven Dental, and 1300SMILES Dentists, our Support Office teams play a critical role in enabling high‑quality patient care across the network.

Job Description

You’ll be the primary engineer responsible for building and supporting integrations between HR/Workforce systems, Recruitment, Entra ID, CRM platforms, and internal applications. You’ll also maintain Fabric‑based pipelines, lakehouse structures, and data transformations.

This role is key to ensuring data consistency, automation, and system integrity across People & Culture, Finance, Recruitment, Marketing, and Risk.

Key Responsibilities

Azure Integrations & Automation

• Build and maintain Azure Logic Apps and PowerShell‑based integrations.
• Implement and support Power Automate workflows (including dentist commission processes).
• Monitor, troubleshoot, and improve integration reliability and logging.
• Work with HR, Recruitment, Finance, and IT to refine integration needs.

Microsoft Fabric & Data Platform

• Maintain and enhance Fabric assets: lakehouse/warehouse structures, tables, views, stored procedures, pipelines, and notebooks.
• Develop ingestion and transformation processes for systems such as CRM platforms.
• Support commission‑related data processing and light Power BI tasks.

Platform Ownership

• Act as the SME for Fabric‑based integrations and Logic Apps.
• Document data flows and integration processes.
• Identify opportunities to simplify and modernise integrations.
• Own integrations end‑to‑end, including production support.

Qualifications

Essential 

• Strong experience with Microsoft Fabric (Lakehouse, Data Warehouse, Pipelines, Notebooks) 
• Solid SQL skills, including stored procedures and data modelling 
• Hands-on experience with Azure Logic Apps 
• Experience integrating SaaS platforms via APIs and event-based workflows 
• Familiarity with Power Automate 
• Experience with PowerShell for automation and integration support 
• Experience designing resilient, idempotent integrations (retry logic, error handling, reprocessing) 
• Strong troubleshooting and problem-solving skills in production environments 

Desirable 

• Experience integrating HR or recruitment platforms 
• Exposure to Entra ID / Azure AD identity integrations 
• Experience with CRM data integrations 
• Basic Power BI experience 
• Understanding of data governance, security, and operational monitoring 

Additional Information

Why join our  Abano Healthcare

• Hybrid working model – enjoy flexibility with 3 days in the office and 2 days working from home.
• Purpose‑driven organisation – your work directly supports clinicians delivering essential healthcare across Australia and New Zealand.
• Professional growth – opportunities to work with modern Microsoft technologies and influence the evolution of our data and integration platforms.
• Supportive team culture – collaborate with passionate, skilled professionals across digital, data, HR, finance, and operations.
• Career development – access to learning opportunities, cross‑functional exposure, and the chance to shape best‑practice integration standards.
• Employee perks – discounts across our dental network, wellbeing initiatives, and access to employee assistance programmes.
• Stable, growing organisation – be part of a large, established healthcare group with long‑term investment in digital transformation.