Sign up to access all features of our service.
  • Job search
  • Favorites
  • Create a CV
    New
  • Salaries
  • Subscriptions

Data Migration Specialist (ETL/SSIS, Data Mapping)

$126k - $170k per year

FNZ

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.

Vacancy posted 2 days ago
Similar jobs that could be interesting for youBased on the Data Migration Specialist (ETL/SSIS, Data Mapping) in Toronto, ON vacancy
  • $108k - $135k per year

     ...members belong and have the opportunity to thrive. As a Data Scientist on the Mapping team, you will collaborate with our world class team of scientists...  ...routes, fastest travel estimates and process real-time map data signals to detect traffic, closures and slowdowns.  Working... 
    Suggested
    Hourly pay
    Work at office
    Flexible hours
    3 days per week

    Lyft

    Toronto, ON
    5 days ago
  • $136k - $170k per year

     ...have the opportunity to thrive. As a Senior Software Engineer, Data on the Mapping team, you will collaborate with our world-class team of...  ...tools that support self-service management of data pipelines (ETL) and schema evolution, and perform hands-on SQL tuning to optimize... 
    Suggested
    Hourly pay
    Long term contract
    Full time
    Work at office
    Flexible hours
    3 days per week

    Lyft

    Toronto, ON
    14 days ago
  • $114k - $136.8k per year

     ...About This Role We are looking for an IT Data Specialist for our Financial Crime & Risk Management...  ...Data Controls (including Data Quality and ETL controls), Investigating data issues...  ...Management process, Data sourcing and further mapping to various interface across our Financial... 
    Suggested
    Full time
    Immediate start
    Work from home

    TD

    Toronto, ON
    2 days ago
  • $100k - $110k per year

     ...We are seeking a Application Developer (Data Specialist) to design, develop, support, and continuously...  ...Oracle Database. Build and maintain ETL processes and data integrations to ensure...  ...with ETL and integration tools such as SSIS, Azure services, APIs, or similar technologies... 
    Ssis
    Work at office
    Immediate start
    Remote work
    Flexible hours
    Shift work
    Toronto, ON
    2 days ago
  •  ...seeking an experienced Senior Software Developer - ETL to lead and oversee the end-to-end data and document migration strategy for enterprise modernization initiatives....  ...Attachment Migration: Lead the extraction, mapping, and transfer of legacy document attachments and binary... 
    Suggested
    Contract work

    Randstad Canada

    Toronto, ON
    11 days ago
  • $93.5k - $119.27k per year

     ...an internal web application and data platform used by hundreds of...  ...and responsibilities of the Data Specialist position. Date: Friday, November...  ...of interactive charts and maps, developed using a mature data...  ...optimization (e.g. NGINX) Knowledge of ETL pipelines and workflow... 
    Full time
    Temporary work
    Part time
    For contractors
    Internship
    Monday to friday
    Shift work

    City of Toronto

    Toronto, ON
    4 days ago
  • $95k - $145k per year

     ...for a skilled and collaborative Azure Data Engineering Specialist to help design, build, and scale data...  ...Pipeline Development Design and implement ETL/ELT workflows using Azure Data Factory...  ...Skills: Data Engineering Data Migration Data Modeling Data Validation... 
    Full time

    CGI

    Toronto, ON
    14 days ago
  • $136k - $170k per year

     ...team members belong and have the opportunity to thrive. For us, maps aren't just background graphics—they’re the core of the driver’s...  ...feature ~ Close, effective partnership with product, engineering, data science and content design, including owning the details through... 
    Hourly pay
    Work at office
    Local area
    Flexible hours
    3 days per week

    Lyft

    Toronto, ON
    5 days ago
  •  ...JOB PURPOSE Accurate, comprehensive data is essential to maintaining our competitive position in the marketplace. The Automotive...  ...with automotive product catalogs, application data, or ACES & PIES mapping. ~ Proficiency with PIM systems (e.g., PartCat) and a working... 
    Full time
    Work at office

    Mevotech

    Toronto, ON
    15 days ago
  • $95k - $145k per year

     ...CGI is seeking an experienced Senior Data Platform Engineering Specialist to join our growing Data Platform Engineering...  ...(e.g., Snowflake), and robust ETL/ELT pipelines. Develop reusable data...  ...contributing to data modernization, cloud migration, or enterprise BI/AI initiatives.... 
    Long term contract
    Permanent employment
    Full time

    CGI

    Toronto, ON
    14 days ago
  • $80k - $105k per year

     ...mobility worldwide, connecting cities as we reduce carbon and replace cars.     Could you be the full-time Industrial Data Management Specialist in Toronto, ON we’re looking for?   Your future role Take on a new challenge and apply your data management and ERP expertise... 
    Long term contract
    Full time
    Work at office
    Local area
    Worldwide
    Flexible hours

    Alstom

    Toronto, ON
    12 hours ago
  •  ...oriented Intermediate Software Developer - ETL for an enterprise-level contract opportunity...  ...will take on a key business intelligence, data modeling, and reporting enablement capacity...  ...dictionaries, metadata catalogs, and data lineage mapping. Provide user support, troubleshoot... 
    Contract work

    Randstad Canada

    Toronto, ON
    11 days ago
  • $112k per year

     ...meaningful and enduring. The Opportunity We are currently seeking a Specialist, Data Developer (Microsoft) to join our Data Platforms & Foundation...  ...data across multiple systems Build and maintain ETL processes to prepare, cleanse, and transform data from diverse... 
    Permanent employment
    Full time
    Work at office

    Vale Base Metals

    Toronto, ON
    11 days ago
  • $55.5k - $120k per year

     ...Street Job Family Group: Data Analytics & Reporting...  ...are seeking a Data Governance Specialist (Data Analytics) to join our Data...  ...data flows, and source-to-target mappings. Identify, investigate, and...  ...management. Experience working with ETL processes, data integration,... 
    Full time
    Contract work
    Part time

    Bank of Montreal

    Toronto, ON
    5 days ago
  •  ...Responsibilities: Analyze data and design semantic models Transform raw data into silver/gold data for reporting consumption...  ...including technical assistance in implementation conversion and migrations. Provide specialized skills for developing data access queries... 
    Full time

    Maarut

    Toronto, ON
    10 days ago
  •  ...Job Description: Job Description We are hiring for a Data Center Sales Specialist or Pre-Sales Technical Support (with a potential transition to Sales), focusing on products such as UPS, power modules, micro-modules, and AHUs. Location and Business Scope (we are hiring... 
    Full time
    Relocation

    SPECIALIZED RG

    Toronto, ON
    1 day ago
  •  ...a Senior ServiceNow Discovery & Service Mapping Engineer, you’ll play a pivotal role in designing...  ...teams to transform raw infrastructure data into actionable insights, enabling...  ...: ServiceNow Certified Implementation Specialist (CIS) – Discovery ServiceNow Certified... 
    Flexible hours

    Royal Bank of Canada

    Toronto, ON
    11 days ago
  • $70k - $150k per year

     ...office) About the team Data and AI Technology (DAT) Engineering...  ...~ Hands on experience with ETL/ELT development/testing and data...  ...Spark, Scala ~ Experience with SSIS, Glue, cloud storage and...  ...Experience with data analysis, data mapping and data profiling ~... 
    Ssis
    Permanent employment
    Full time
    Contract work
    Part time
    Work at office
    2 days per week

    BMO

    Toronto, ON
    10 days ago
  •  ...Oracle AWS Cloud DBA – Migration & Amazon RDS Specialist Location: Toronto, ON Work Arrangement: Hybrid (3 Days WFO) Experience Required...  ...Collaborate with application development teams on data modeling, schema design, and deployment of complex PL/SQL packages... 
    Permanent employment
    Internship
    Manual labor
    Work at office
    Weekend work
    Weekday work

    Astra North Infoteck Inc.

    Toronto, ON
    18 days ago
  • $70k - $150k per year

     ...Application Deadline: 12/14/2026 Address: 33 Dundas Street West Job Family Group: Data Analytics & Reporting #AIJobsBFUTR The Data Management & Governance Specialist is responsible for supporting the effective management, governance, quality, and use of data across... 
    Permanent employment
    Contract work
    Part time

    BMO

    Toronto, ON
    1 day ago
  • $20 - $80 per unit

    About the job Mercor connects elite creative and technical talent with leading AI research labs. Headquartered in San Francisco, our investors include Benchmark , General Catalyst , Peter Thiel , Adam D'Angelo , Larry Summers , and Jack Dorsey . Position...
    Remote job
    Contract work
    Summer work
    Flexible hours

    Mercor

    Toronto, ON
    6 days ago
  • $73.5k - $123.5k per year

     ...The Opportunity  Reporting to the Data Governance Tooling and Reporting Manager, this role will be a key member of the EDO, accountable...  ...is an individual contributor and also a self-starter. The Data Specialist is empowered to work independently with teams and projects... 

    Definity

    Toronto, ON
    8 days ago
  • $23 - $37 per hour

     ...What You’ll Do: In this 6-month contract, as the Specialist, Merch Data Governance, you will help ensure product data remains accurate and flows reliably across critical business systems. You will manage daily operations, database runs, reporting, and the team mailbox while... 
    Contract work
    Work at office
    Flexible hours

    Canadian Tire Corporation

    Toronto, ON
    11 days ago
  • $90k - $180k per year

     ...Company: Marsh Description: We are seeking a talented individual to join our Data Solutions team, part of our people and investments business at Marsh. This role will be based in Boston. This is a hybrid role that has a requirement of working at least three days a week in... 
    Minimum wage
    Long term contract
    Full time
    Manual labor
    Work at office
    Local area
    Immediate start
    Remote work
    Flexible hours
    3 days per week
    1 day per week

    Marsh McLennan

    Toronto, ON
    14 days ago
  •  ...Role Overview: The Government of Ontario is undertaking a large-scale Data & AI transformation initiative with the Ontario Data Platform (ODP) serving as the enterprise technology ecosystem for data-driven decision-making analytics and artificial intelligence. ODP provides... 
    Full time

    Maarut

    Toronto, ON
    10 days ago
  •  ...core operations enabling the delivery of automation products and data management processes. Understands the implications of various...  ...monitoring. • Lead/support UiPath installation, upgrades, patching, migrations, and platform configuration changes. • Administer and... 
    Contract work
    Work at office
    2 days per week

    Astra North Infoteck Inc.

    Toronto, ON
    more than 2 months ago
  •  ...The Senior Software Developer - ETL will design, build, and maintain scalable data pipelines, integrations, and reusable data services that enable enterprise AI, analytics, and data initiatives. The role will help improve access to trusted data across enterprise systems... 

    P@thlion Staffing Careers

    Toronto, ON
    17 days ago
  •  ...our planet and its people. The Data, AI & Advanced Analytics team delivers...  ...primary keys, business keys, mapping rules, source-to-target...  ...maintainability improvements, and migration toward Microsoft Fabric. Pipeline...  ...Data Lake Storage Gen2. ETL/ELT, orchestration, incremental... 
    Internship
    Flexible hours

    AtkinsRéalis

    Toronto, ON
    5 days ago
  • $95k - $145k per year

    Senior Data Platform Engineering Specialist Position Description Location: Toronto/Montreal Preferred...  ...Warehouses (e.g., Snowflake), and robust ETL/ELT pipelines. Develop reusable data...  ...to data modernization, cloud migration, or enterprise BI/AI initiatives.... 
    Long term contract
    Permanent employment
    Full time
    Toronto, ON
    a month ago
  • $115k - $135k per year

     ...fill an opening for a Portfolio Manager, Managed Assets Program (MAP) to join our Asset Management team. Reporting to the Senior Manager...  ...’s Managed Account platform through innovation, automation and data-driven insights Support financial advisors with their client meetings... 
    Full time
    Internship

    Aviso Wealth

    Toronto, ON
    more than 2 months ago

Do you want to receive more vacancies?

Subscribe and receive similar vacancies to Data Migration Specialist (ETL/SSIS, Data Mapping). Be the first to apply!