Data Migration Specialist (ETL/SSIS, Data Mapping)

Posted 2 Days Ago
Be an Early Applicant
2 Locations
In-Office
Mid level
Fintech • Payments • Financial Services
The Role
Design, develop and maintain ETL workflows and SSIS packages to migrate client data into FNZ systems. Produce data models, mapping definitions and validation rules, support testing and post-implementation issue resolution, and collaborate with client and internal SMEs to meet migration requirements.
Summary Generated by Built In

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

FNZ Intends to comply to the EU Pay Transparency Directive. Salary ranges will be provided upon request.


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.


Skills Required

  • Design and implement complex client-focused data mapping
  • Designing, creating and maintaining SSIS packages
  • Experience using ETL tools (e.g., SSIS, Informatica)
  • Strong relational database design experience with MS SQL Server
  • Proficient in data mapping and profiling techniques
  • Experience working on Business Intelligence projects
  • Experience working with big data and ETL processes
  • Superior analytical thinking and attention to detail
  • Highly developed written and oral communication skills; client-facing confidence
  • Ability to prioritise workload and meet aggressive deadlines with minimal supervision

FNZ Group Compensation & Benefits Highlights

The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about FNZ Group and has not been reviewed or approved by FNZ Group.

  • Parental & Family Support FNZ is described as offering 26 weeks of fully paid parental leave for both primary and secondary caregivers, alongside expanded bereavement and emergency care leave. These policies can materially increase the perceived value of the overall rewards package beyond base salary.
  • Fair & Transparent Compensation Base pay is frequently characterized as “good salary” or “nice compensation” in several markets. Paid overtime in delivery roles is also described as a meaningful boost to total earnings.
  • Flexible Benefits A flexible benefits menu is described, including options such as EV leasing, retailer discounts, and cycle-to-work offerings. This supports tailoring benefits to local needs and individual preferences where available.

FNZ Group Insights

Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: London
4,252 Employees
Year Founded: 2003

What We Do

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.5 trillion in assets under administration (AUA). Together with our customers, we help over 20 million people from all wealth segments to invest in their future

Similar Jobs

ServiceNow Logo ServiceNow

Dir, Expert Services Mgmt

Artificial Intelligence • Cloud • HR Tech • Information Technology • Productivity • Software • Automation
Remote or Hybrid
Toronto, ON, CAN
29000 Employees

ServiceNow Logo ServiceNow

Enterprise Account Executive

Artificial Intelligence • Cloud • HR Tech • Information Technology • Productivity • Software • Automation
Remote or Hybrid
Toronto, ON, CAN
29000 Employees
143K-213K Annually

Dynatrace Logo Dynatrace

Commercial Account Executive

Artificial Intelligence • Big Data • Cloud • Information Technology • Software • Big Data Analytics • Automation
Remote or Hybrid
Toronto, ON, CAN
5600 Employees

Magna International Logo Magna International

Industrial Engineer

Automotive • Hardware • Robotics • Software • Transportation • Manufacturing
Hybrid
2 Locations
171000 Employees

Similar Companies Hiring

Hanover Park Thumbnail
Artificial Intelligence • Fintech • Software • Financial Services
New York, New York
42 Employees
Kepler  Thumbnail
Fintech • Software
New York, New York
6 Employees
Onshore Thumbnail
Artificial Intelligence • Fintech • Software • Financial Services
New York, New York
60 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account