Data Migration Engineer

Randstad Group; Auckland; On-site; NZD 120,000 - 180,000; Full time

Job summary

Randstad Group in Auckland seeks an experienced Data Migration Engineer to manage end-to-end data delivery and design scalable cloud migration strategies. You will translate business requirements into data models and actively implement migrations on cloud platforms.

You will build and maintain ELT pipelines, develop Snowflake schemas, and implement data quality, testing, and governance frameworks while engaging with stakeholders at all levels.

Qualifications

• Proven end-to-end data solutions delivery on enterprise platforms.
• Advanced SQL with Snowflake and dbt experience.
• Experience implementing modern ELT frameworks and dimensional models.
• Strong stakeholder engagement and communication skills.
• Ability to design data quality, testing, and reconciliation frameworks.

Responsibilities

• Migration Delivery: develop ingestion, transformation, and presentation layers for data migration to cloud platforms.
• Data Transformation: build dbt models and Snowflake schemas for ELT processes.
• Data Quality & Governance: profile data quality and implement validation frameworks.
• Stakeholder Engagement: run discovery workshops and document mappings.
• Technical Quality: provide technical leadership and practice CI/CD.

Skills

SQL

Snowflake

dbt

ELT

Data Modeling

Education

Bachelor Degree

Tools

Git

CI/CD

Job description

Data Migration Engineer

The Role

We are seeking an experienced Data Migration Consultant to manage end-to-end data delivery for a leading data solutions company in Auckland. This hands-on role involves translating business requirements into scalable cloud data migration strategies. You will engage with stakeholders to design conceptual and physical data models, while remaining actively involved in the technical implementation of migrating and modernising data on cloud platforms.

Key Duties

• Migration Delivery: Develop ingestion, transformation, and presentation layers to support enterprise data migration to modern cloud platforms.
• Data Transformation: Build and maintain scalable dbt models, Snowflake schemas, and modern ELT transformation pipelines.
• Data Quality & Governance: Profile source system data quality, identify data issues, and implement data validation and reconciliation frameworks for the migration.
• Stakeholder Engagement: Run requirements discovery workshops, document data mapping specifications, and manage executive-level business expectations.
• Technical Quality: Provide practical technical leadership across projects and apply software engineering best practices, including version control and CI/CD processes.

Skills & Experience Required

• Experienced Professional: Proven track record of delivering end-to-end data solutions, including managing enterprise data platforms, cloud data warehouses, and complex data migration projects.
• Technical Stack: Advanced SQL development skills combined with extensive hands-on experience using Snowflake and dbt.
• Data Architecture: Practical experience implementing modern ELT frameworks, dimensional models, and robust data testing/quality principles.
• Stakeholder Management: Effective consulting and communication skills to engage both technical and non-technical audiences.
• Analytical Mindset: Pragmatic approach to problem-solving, identifying underlying data patterns, and implementing remediation strategies.

Please Note:

We are unfortunately unable to offer work visa sponsorship for this position, for overseas applicants. To be considered, you must currently reside in New Zealand and hold valid working rights.

At Randstad, we are passionate about providing equal employment opportunities and embracing diversity to the benefit of all. We actively encourage applications from any background.

experience

6 years

skills

Analytics Engineer, Snowflake, dbt, SQL, BI, Data Modelling, ELT, Consulting, Auckland, Data Migration

qualifications

• Bachelor Degree

education

Bachelor Degree