Migrations Analyst Developer

FNZ; Toronto; On-site; CAD 60,000 - 100,000; Full time

Job summary

Join a dynamic Migrations Team at a forward-thinking global financial services firm, where you'll design and implement complex data mapping solutions. This role is crucial in managing the end-to-end delivery lifecycle of migration projects, ensuring accuracy and attention to detail throughout the process. Collaborate with internal and client resources to produce technical outputs and provide post-implementation support. You'll thrive in a culture that values teamwork, innovation, and personal growth, making a significant impact on how millions invest. If you're passionate about technology and data, this opportunity is perfect for you.

Benefits

Competitive base salary

Bonus

Paid time off

Employer-paid medical insurance

Dental insurance

Vision insurance

Pension plan matching

Learning & development opportunities

Global career opportunities

Qualifications

• Experience in data mapping and ETL processes is essential.
• Strong communication and analytical skills are required.

Responsibilities

• Design and implement complex data mapping solutions for clients.
• Develop and maintain ETL processes and SSIS packages.

Skills

Client-focused data mapping

Analytical thinking

Communication skills

Relational database design

ETL process knowledge

Data mapping and profiling techniques

Team collaboration

Problem-solving

Tools

SSIS

Informatica

MS SQL Server

Job 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-focused 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

1. Working with Internal and Client SME resources to provide complex data mapping solutions in line with Client requirements, FNZ Solution and FNZ Migration SDLC.
2. 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.
3. Designing, creating and maintaining SSIS packages to migrate data to FNZ databases.
4. Designing and developing ETL workflows conforming to best practices and creating re-usable components.
5. Providing solutions and recommendations for the resolution of technical issues that arise, ensuring solutions meet the technical specs, design and non-functional requirements.
6. Supporting changes through the testing; resolving data issues, completing unit testing and system documentation for ETL processes.
7. 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

1. Confident, and able to take initiative in a client and delivery-focused environment.
2. Good team communication skills, confident in dealing with internal and external clients.
3. Highly developed written and oral communication skills.
4. Strong relational database design experience working with MS SQL Server.
5. Proficient in data mapping and profiling techniques.
6. Experience in using ETL tools, e.g. SSIS, Informatica.
7. Experience in working on Business Intelligence projects.
8. Superior analytical thinking.
9. Able to prioritise own workload and work to aggressive deadlines with minimal supervision.

What FNZ offers:

1. A competitive base salary, bonus, and paid time off.
2. FNZ will match pension plan contributions at 150%, up to 4% total Employee Contribution.
3. Employer-paid medical, dental and vision insurance, and more.
4. We are mission-led - work at the heart of a purpose-led organization where you can be proud of the impact you make, every day. Where you’ll transform the way over 20 million people invest, making wealth management more accessible, sustainable and transparent to more people.
5. Learning & development – Placing emphasis on a willingness to learn, to think differently, to be creative and to help drive innovation.
6. Be part of a highly successful, rapidly growing, Pre-IPO global business that is leading the delivery of financial services via cloud computing and partners with some of the world’s largest companies.
7. We provide global career opportunities for our best employees at any of our offices in the US, Canada, UK, Czech Republic, Asia, Australia or New Zealand.

About FNZ Culture

Our culture is what drives us. It's at the heart of who we are and everything we do. It's what inspires, excites, and moves us forward.

Our ambition is to create a culture for growth, one that opens up limitless opportunities for our employees, customers, and the wider world.

At FNZ we know that great impact is only possible with great teamwork.

That’s why we value the strength and diversity of thought in our global team.

The FNZ Way is the cornerstone of what we do. It comprises four values that set the standard for how everyone at FNZ interacts with each other, with our customers, and with all our diverse stakeholders worldwide.

1. Customer obsessed for the long-term.
2. Think big and make an impact.
3. Act now and own it all the way.
4. Challenge, commit and win together.

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.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.