Hybrid Data Migration Specialist – Functional and Data Analyst

at Foster International

• Job title: Data Migration Specialist – Functional and Data Analyst
• Job type: Full Time
• Experience level: Mid level, Senior
• Salary: Not specified
• Degree requirement: Bachelor's Degree
• Tech skills: ETL, NoSQL, Postgres, SQL
• Location requirements: Hybrid, Auckland Central, New Zealand

About the role

• Data Migration Specialist responsible for driving data mapping and rules definition. Join a skilled team to execute complex migration projects that drive business transformation.

Responsibilities

• Gaining and understanding the source system and data model and target solution and data model
• Defining and maintaining data migration mapping and rules documentation
• Investigation of source data anomalies discovered during ETL develop and managing resolution of data quality issues
• Customer meeting facilitation and decision log management
• Compiling, assigning, communicating and managing the list of pre and post go-live tasks
• Testing data migrated per mapping and rules is fit-for-purpose on the target solution and where migrated data cannot be migrated to be fit-for-purpose, work with development team consultants and developers to identify possible changes to target solution
• Managing the triaging and assignment of customer testing questions and bugs

Requirements

• 3–5 years’ experience in data migration and functional analysis roles, including 2–4 years in a hands-on data migration analyst or developer role
• Understanding of ETL and other data migration processes
• Strong experience in data modelling
• Experience in SQL (preferably Postgres) in writing moderately complex SQL queries to analyse the source data
• Understanding of Mongo (or other noSql/docDB) or other json structures
• Good understanding of acceptance testing processes
• A solid understanding of data security, data validation, and quality assurance best practices
• Proven stakeholder management, communication, and documentation skills, with the ability to communicate at both a functional and technical level
• Prior experience working in a vendor organisation
• Ideally prior experience within a registry industry

Benefits

• Ongoing learning and development support
• Employee referral bonuses and recognition initiatives
• Paid birthday leave — because your day matters
• Discounted medical insurance and free flu vaccinations
• Access to our Employee Assistance Program (EAP)
• Excellent commuter facilities, including on-site e-bike chargers at no cost
• A vibrant team culture with regular social events