Job description
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
- 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
- Good team communication skills, confident in dealing with internal and external clients
- Highly developed written and oral communication skills
- Able to prioritise own workload and work to aggressive deadlines with minimal supervision
About FNZ
FNZ is the market leading provider of technology and administration services to major financial institutions in the platform and wealth management sectors across the globe. We partner with life companies, banks, asset managers and discretionary wealth managers to enable them to develop and distribute financial products and services to their customers across all major distribution channels.
FNZ has a strong blue-chip customer base including Standard Life, Axa Wealth, JP Morgan, HSBC, AMP, National Australia Bank, Bank of New Zealand, Friends Life, UBS, Zurich Financial and Close Brothers Asset Management. It has helped these customers grow to over £30 billion of platform assets in aggregate. FNZ now employs over 1 000 people with offices in UK (London, Bristol, Edinburgh), Czech Republic (Brno), Australia (Sydney), New Zealand (Wellington), Singapore and China (Hong Kong, Shanghai).
Opportunities
- Be part of a highly successful, rapidly growing, global business that is leading the delivery of financial services via cloud computing and partners with some of the world’s largest companies;
- Remuneration and career advancement is based on individual contribution and business impact rather than tenure or seniority;
- We provide significant financial rewards for high performing individuals; and
- We provide global career opportunities for our best employees at any of our offices in the UK, Czech Republic, Australia, New Zealand or China.
Commitment to equal opportunities
At FNZ, we recognise that diversity, inclusion, and accessibility are important factors for our success. We embrace the unique perspective and capabilities of our current and future employees, which will help us continue to drive innovation and achieve our business goals. Recruitment decisions at FNZ are made in a non-discriminatory manner where all employees are valued and respected. In particular, we want to ensure accessibility needs are well supported thus, ensuring our recruitment process is fair and equitable for all applicants.
#LI-PD1