Migrations Analyst Developer

FNZ; Alberta; On-site; CAD 70,000 - 90,000; Full time

Job summary

A leading wealth management platform provider in Canada seeks a Migration Analyst Developer to manage data mapping and ETL processes within the Migration Team. The role emphasizes client-focused solutions and requires strong SQL Server experience. Ideal candidates will excel in analytical thinking and communication, ensuring high-quality data delivery. Join the team to drive complex migration projects and support clients in achieving their investment goals.

Qualifications

• Experience with complex data mapping solutions.
• Strong communication skills for internal and external clients.
• Ability to work independently and manage workloads effectively.

Responsibilities

• Design and implement data mapping in the FNZ Migration SDLC.
• Develop and maintain ETL processes.
• Provide technical outputs, including data models and migration workflows.

Skills

Client communication skills

Relational database design

Data mapping techniques

Experience with ETL tools

Analytical thinking

Tools

MS SQL Server

SSIS

Informatica

Job description

Role Description

This position is located within the Migrations Team at FNZ.

The Migration Team has accountability for managing the end-to-end delivery lifecycle for all Migration projects within FNZ. The Migration Analyst Developer role requires an individual who can design and implement complex Client focussed data mapping in line with the FNZ Migration SDLC.

The role involves working with big data, designing, developing, maintaining and supporting the Extract, Transform and Load (ETL) process. Reporting to the Migration Team Lead, you will work as an integral part of the team, analysing requirements before designing & implementing solutions.

This role is technical and focused on providing long term solutions. The data model and data population routines are a critical part of the migration process so accuracy and attention to detail are important characteristics.

Specific Role Responsibilities

• Working with Internal and Client SME resource to provide complex data mapping solutions in line with Client requirements, FNZ Solution and FNZ Migration SDLC

• Producing technical migration outputs, such as data models, data mapping definitions and data validation rules in line with the target FNZ Product and Client Migration requirements

• Designing, Creating and maintaining SSIS packages to migrate data to FNZ databases

• Designing and developing ETL workflows conforming to best practices and creating re-usable components

• Providing solutions and recommendations for the resolution of technical issues that arise, ensuring solutions meet the technical specs, design and non-functional requirements

• Supporting changes through the testing; resolving data issues, complete unit testing and system documentation for ETL processes

• Providing post implementation support once the migration is complete to support both the project and service & support teams in issue identification and resolution.

Experience required

• Confident, and able to take initiative given client and delivery-focused environment

• Good team communication skills, confident in dealing with internal and external clients

• Highly developed written and oral communication skills

• Strong relational database design experience working with MS SQL Server

• Proficient in data mapping and profiling techniques

• Experience in using ETL tools, e.g. SSIS, Informatica

• Experience in working on Business Intelligence projects

• Superior analytical thinking

• Able to prioritise own workload and work to aggressive deadlines with minimal supervision

About FNZ

FNZ is committed to opening up wealth so that everyone, everywhere can invest in their future on their terms. We know the foundation to do that already exists in the wealth management industry, but complexity holds firms back.

We created wealth’s growth platform to help. We provide a global, end-to-end wealth management platform that integrates modern technology with business and investment operations. All in a regulated financial institution.

We partner with over 650 financial institutions and 12,000 wealth managers, with US$1.7 trillion in assets under administration (AUA).

Together with our customers, we help over 26 million people from all wealth segments to invest in their future.