Implementation Consultant - Data Migration

Procentia; Bristol; On-site; GBP 45,000 - 60,000; Full time

Job summary

A leading software and technology firm in Bristol is seeking an experienced Implementation Consultant. The role involves leading data migration projects, designing data mapping strategies, and ensuring data integrity. The ideal candidate has strong skills in T-SQL and SQL Server, alongside experience in large-scale data migrations. Attractive benefits include generous holiday, private medical insurance, and an electric car leasing scheme.

Benefits

25 days holiday plus public holidays

Buying and Selling holiday

Volunteer day

5% Employer contribution pension

Life Assurance

Private Medical Insurance

Employee Assistance Programme

Health care cash plan

Electric Car Leasing scheme

Qualifications

• Proven experience in implementing software systems.
• Strong understanding of database design principles and normalization.
• Ability to troubleshoot queries for improved performance.

Responsibilities

• Lead the planning and movement of data from client legacy systems.
• Design data mapping and transformation logic.
• Develop automated migration scripts and validate data integrity.

Skills

T-SQL proficiency

XML proficiency

Data migration experience

Analytical skills

Customer service skills

ETL processes

Data cleansing

Tools

SQL Server

Job description

About us

Proventia is an award-winning software and technology company specialising in the Pensions and Bulk Purchase Annuities market. We design intelligent solutions that put administrators and members at the heart of any pension scheme.

Established in 2002, we’re renowned for our web-based pensions administration and management system, IntelliPen. Our platform helps clients meet the demand for self-serve technology and provide meaningful consumer-like experiences expected from online platforms.

Trusted by administrators, employers and trustees, our software is widely regarded as the most comprehensive and feature-rich platform for modern pensions management.

IntelliPen comprises a suite of integrated modular systems that streamline processes from new member registration to online self-serve retirement, and enables collaboration on the same workflows. It delivers up to 90% time and cost efficiencies by automating member retirements, validation, benefit calculations, reporting and pensioner payroll.

With offices in the UK and North America, we support some of the largest pension schemes and plans across the private and public sectors.

We've been named 'Pension Technology Firm of the Year 2024' at the Pensions Age Awards, and voted ‘No.1 UK Pension Administration Software Provider’ in 2022 and 2023.

Procentia People are a community of passionate specialists dedicated to developing best-in-class software solutions and client service. We’re a vibrant assortment, everyone is welcome here.

We’re proud of our welcoming and open culture, and our Values. They’re not just words on paper – we’re dedicated to living them every day

The job:

As part of our continuing growth we are seeking to recruit an Implementation Consultant with Data Migration experience into Procentia. The purpose of this role is to lead the planning and movement of data from clients legacy systems to our IntelliPen suite of products. This will involve designing data mapping and transformation logic, developing automated migration scripts, and validating the integrity of the migrated data.

Responsibilities

• Proficient in the use of T-SQL, XML and able to work well as part of a team. Demonstrate strong knowledge and experience in the area, with sound technical knowledge and exceptional analytical, communication, and customer service skills.
• Design and implement data migration solutions, including data mapping, transformation, reconciliations and validation.
• Strong understanding of database design principles, data modelling, and normalisation.
• Strong understanding of database structures and practices, with experience in relational databases such as SQL Server.
• Ability to troubleshoot and optimise queries and database structures for improved performance and resource management.
• Proven experience in large-scale data migration projects, preferably within the pensions or financial services industry.
• Skilled in ETL processes, data cleansing, and mapping strategies. Experience in implementing software systems.
• Adaptable and agile with a consultative approach.

Key skills and experience

• Proven track record in designing and implementing data migration solutions, including data mapping, transformation, reconciliations and validation.
• Strong understanding of database design principles, data modelling, and normalisation.
• Strong understanding of database structures, principles, and practices, with experience in relational databases such as SQL Server.
• Ability to troubleshoot and optimise queries and database structures for improved performance and resource management.
• Proven experience in large-scale data migration projects, preferably within the pensions or financial services industry.
• Skilled in ETL processes, data cleansing, and mapping strategies.
• Experience in implementing software systems.
• Adaptable and agile; Be a responsible and reliable professional, with a consultative approach.

What’s in it for you

• 25 days holiday (plus public holidays) increasing with length of service up to a maximum of 28 days, with carry over of up to 1 week
• Buying and Selling holiday (up to 1 week)
• Volunteer day
• 5% Employer contribution pension
• Life Assurance
• Private Medical Insurance
• Employee Assistance Programme (EAP)
• Health care cash plan
• Tusker – Electric Car Leasing scheme
• And many more..