Data Integration Specialist

Ac3 Australia; Wellington; Hybrid; NZD 83,000 - 124,000; Part time

Benefits offered by this job

Hybrid work arrangement

6-month fixed-term contract

Job summary

Ac3 Australia in Wellington seeks a Data Integration Specialist for a 6-month fixed-term contract. You will design and implement data integration solutions across cloud and on-prem environments using Azure Integration Services, Azure Data Factory and SQL Server.

The role covers API integrations, ETL design, and data quality improvements, with hybrid work flexibility (2 days in-office, 3 days remote). Applicants based in Wellington or willing to relocate are welcome.

Qualifications

• Hands-on data integration in large, complex enterprise environments.
• Strong experience with Microsoft Azure Integration Services and Azure Data Factory.
• Solid SQL Server expertise including SSIS/SSRS/SSAS and ETL development.
• Experience designing and supporting REST and SOAP APIs.
• Knowledge of data transformation, migration, and quality.

Responsibilities

• Design, develop, deploy and support enterprise data integration solutions.
• Build and maintain integrations using Azure services and Azure Data Factory.
• Develop SQL Server integrations including SSIS/SSRS/SSAS.
• Design, develop and maintain secure REST/SOAP APIs.
• Develop and optimise ETL processes and data movement.
• Support automation, cloud migration and platform improvements.
• Troubleshoot complex data integration issues and performance problems.
• Collaborate with architects and stakeholders on scalable, secure integrations.
• Support data migration, validation and testing; maintain docs and standards.

Skills

Azure Integration Services

Azure Data Factory

SQL Server

SSIS

API integration

REST APIs

SOAP APIs

ETL

Data transformation

C# / .NET

T-SQL

PowerShell

Azure DevOps

GitHub

Tools

Azure Data Factory

Azure Integration Services

Azure API Management

SQL Server

SSIS

SSRS

SSAS

REST

SOAP

GitHub

Azure DevOps

Job description

• IT & Telecomms
• IT - Other
• Wellington, New Zealand
• Contract or Temp
• Data Integration Specialist | Azure & SQL
• Wellington, New Zealand
• 6 month Fixed-term contract

We are seeking an experienced Data Integration Specialist to join a large, complex enterprise technology environment on a 6 month Fixed-term contract based in Wellington.

This is a hands-on technical role suited to someone with strong experience in Microsoft Azure Integration Services, Azure Data Factory, SQL Server, SSIS and API integration.

You will be responsible for designing, developing, maintaining and supporting application and data integration solutions across multiple enterprise systems, ensuring reliable data movement, system connectivity and integration performance.

Working closely with solution architects, infrastructure teams and business stakeholders, you will contribute to integration projects, cloud initiatives, automation and ongoing improvements to enterprise data platforms.

This opportunity is ideal for someone who enjoys solving complex integration challenges and has experience working across both cloud and on-premises environments.

Key Responsibilities

• Design, develop, deploy and support enterprise application and data integration solutions.
• Build and maintain integrations using Azure Integration Services, Azure API Management and Azure Data Factory.
• Develop and support SQL Server integration solutions, including SSIS, SSRS and SSAS.
• Design, develop and maintain secure APIs and integrations using REST, SOAP, JSON and XML.
• Develop and optimise ETL processes, data transformations and data movement between enterprise applications.
• Support integration automation, system enhancements and cloud migration initiatives.
• Investigate and resolve complex data integration issues, performance problems and system failures.
• Work with solution architects to design scalable, secure and reliable integration solutions.
• Support data migration, data quality, validation and integration testing.
• Maintain integration documentation, technical standards and operational procedures.
• Collaborate with internal technical teams, business stakeholders and external vendors to deliver integration projects.

What We're Looking For

• Strong hands-on experience in data integration and application integration within large, complex enterprise environments.
• Practical experience with Microsoft Azure, particularly Azure Integration Services, Azure API Management and Azure Data Factory.
• Strong SQL Server expertise, including SSIS, SSRS, SSAS and ETL development.
• Experience designing, developing and supporting REST and SOAP APIs.
• Strong understanding of data transformation, data migration, integration architecture and data quality.
• Development or scripting experience with C#, .NET, T-SQL, PowerShell, JSON and XML.
• Experience integrating multiple enterprise applications, databases and cloud platforms.
• Understanding of data warehousing, business intelligence and enterprise data management.
• Experience troubleshooting complex integration issues and supporting production environments.
• Familiarity with source control and development tools such as Azure DevOps or GitHub.
• Strong communication skills and the ability to work effectively with architects, developers and business stakeholders.

Experience with AWS, Oracle databases, IBM Cognos or CI/CD tools would be advantageous.

Why Consider This Opportunity?

• 6-month contract within a large-scale enterprise technology environment.
• Hybrid flexibility - just 2 days per week in the Wellington office.
• Work across Microsoft Azure, SQL Server and complex enterprise integration platforms.
• Opportunity to contribute to cloud integration, automation and data transformation initiatives.
• A hands-on technical role offering variety, ownership and exposure to enterprise-scale systems.

This is a Wellington-based hybrid role, requiring 2 days per week onsite in the Wellington office, with the remaining 3 days working from home.
Applicants must be based in Wellington or willing to relocate. Fully remote working is not available.