We launched recruiters.rip, let your AI apply for you. First month free with code onemonthfree

Data Migration Specialist (ETL/SSIS, Data Mapping)

FNZ is a global wealth management platform provider.

Distributed
About FNZ

FNZ describes itself as 'wealth's growth platform', providing a global, end-to-end wealth management platform that integrates modern technology, business operations, and investment operations within a regulated financial institution connected to a universe of investment products. The company serves banks, wealth managers, insurance companies, and asset managers, with over US$2.5 trillion in assets on platform and nearly 30 million end investors served through its clients. Its offerings span wealth management platforms, advisor tools and productivity solutions, asset management distribution, and trade and post-trade securities services, along with a data platform combining an Operational Data Store, Analytical Data Warehouse, and Aggregated Data Warehouse to power analytics, machine learning, and generative AI insights. FNZ has notable clients including Santander, Colonial First State (CFS), Vanguard, Aviva, and Swedbank, and in 2025 announced a global five-year strategic partnership with Microsoft to integrate Azure AI Foundry, Microsoft Fabric, GitHub Copilot, and Microsoft 365 Copilot across its platform and operations. FNZ is backed by major institutional shareholders including Caisse de dépôt et placement du Québec (CDPQ), CPP Investments, Generation Investment Management, and Motive Partners.

View jobs by FNZ

Skills

Candidate Availability

About the Role

You will design and implement complex client-focused data mapping in line with the migration SDLC. You will produce data models, mapping definitions and validation rules, build and maintain SSIS packages and ETL workflows, resolve data and technical issues, complete unit testing and documentation, and provide post-implementation support.

Requirements

  • Confident and able to take initiative in a client and delivery-focused environment
  • Good team communication skills with internal and external clients
  • Highly developed written and oral communication skills
  • Strong relational database design experience with MS SQL Server
  • Proficient in data mapping and profiling techniques
  • Experience using ETL tools such as SSIS or Informatica
  • Experience working on Business Intelligence projects
  • Superior analytical thinking
  • Able to prioritise workload and meet aggressive deadlines with minimal supervision

Responsibilities

  • Work with internal and client SMEs to provide complex data mapping solutions
  • Produce data models, data mapping definitions and data validation rules
  • Design, create and maintain SSIS packages to migrate data to FNZ databases
  • Design and develop ETL workflows with re-usable components
  • Provide solutions and recommendations for technical issues
  • Support changes through testing, resolve data issues, complete unit testing and system documentation
  • Provide post implementation support