FNZ Group Logo

FNZ Group

Data Migration Specialist (ETL/SSIS, Data Mapping)

Reposted 2 Days Ago
Be an Early Applicant
In-Office
Toronto, ON, CAN
Entry level
In-Office
Toronto, ON, CAN
Entry level
Designs and supports complex data migration solutions, including data mapping, modeling, validation, SSIS packages, and ETL workflows. Collaborates with internal and client subject matter experts to implement migration requirements, resolve technical and data issues, conduct testing, document processes, and provide post-implementation support. The role requires strong SQL Server, ETL, data profiling, relational database design, analytical, communication, and workload-management skills.
The summary above was generated by AI

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

Salary Transparency


 Transparency matters to us. The salary range for this position is CAD$126,000-170,000 per year. Actual compensation within this range will be based on a variety of factors, including relevant experience, knowledge, skills, and applicable certifications. This range reflects what we reasonably expect to offer based on current market data.


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 the world’s leading financial institutions, with over US$2.5 trillion in assets on platform (AoP).
Together with our clients, we empower nearly 30 million people across all wealth segments to invest in their future.


FNZ Group Toronto, Ontario, CAN Office

Floor 15, 250 Yonge Street, Toronto, Canada, M5B 2L7

Similar Jobs

11 Hours Ago
Hybrid
Niagara-on-the-Lake, ON, CAN
Junior
Junior
eCommerce • Fashion • Retail • Sales • Wearables • Design
Serves as a front-line Coach brand ambassador by delivering personalized luxury retail experiences, building client relationships, styling customers, and achieving sales goals. Responsibilities include cross-selling, clienteling, social selling, POS transactions, inventory processing, replenishment, visual merchandising, cash wrap, online pickup support, and maintaining organized sales and stock areas. The role requires flexible scheduling, teamwork, customer focus, and the ability to lift merchandise and work actively on the sales floor.
Top Skills: Clienteling ToolsIpadLaptopMobile PosPos SystemsSocial Selling PlatformsWalkie-Talkie
11 Hours Ago
Hybrid
Niagara-on-the-Lake, ON, CAN
Junior
Junior
eCommerce • Fashion • Retail • Sales • Wearables • Design
Serves as a front-line Coach brand ambassador by delivering personalized luxury retail experiences, building client relationships, achieving sales goals, and using POS, clienteling, and social selling tools. Responsibilities include styling customers, cross-selling, processing transactions, managing inventory, replenishing merchandise, supporting visual merchandising, maintaining sales floor and stockroom standards, and collaborating with teammates. Requires flexibility for nights, weekends, holidays, and peak retail periods, along with the ability to lift and maneuver merchandise.
Top Skills: Clienteling ToolsIpadLaptopMobile PosPoint-Of-Sale (Pos) SystemsShort-Form Video PlatformsSocial Selling Platforms
11 Hours Ago
Hybrid
Niagara-on-the-Lake, ON, CAN
Junior
Junior
eCommerce • Fashion • Retail • Sales • Wearables • Design
Serves as a front-line Coach brand ambassador by delivering personalized luxury retail experiences, meeting sales goals, styling customers, and building client relationships. Uses POS, mobile selling, clienteling, and social selling tools to drive purchases and repeat business. Supports cash wrap, inventory, replenishment, visual merchandising, online pickups, and stockroom operations while maintaining brand and asset protection standards. Requires flexible scheduling, physical mobility, and collaboration in a fast-paced store environment.
Top Skills: IpadLaptopMobile PosPosSocial Selling Platforms

What you need to know about the Toronto Tech Scene

Although home to some of the biggest names in tech, including Google, Microsoft and Amazon, Toronto has established itself as one of the largest startup ecosystems in the world. And with over 2,000 startups — more than 30 percent of the country's total startups — Toronto continues to attract new businesses. Be it helping entrepreneurs manage their finances, simplifying business operations by automating payroll or assisting pharmaceutical companies in launching new drugs, the city's tech scene is just getting started.

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account