Data Migration Consultant

We are seeking an experienced Data Migration Consultant to join our Local Government data migration team. Our team migrates new customers from third party revenues and benefits systems into the NEC revenues and benefits system as well as merging data for current NEC customers who wish to become Unitary authorities. The successful candidate will play a key role in designing developing maintaining and executing migration and merge solutions to ensure data is transferred accurately securely and efficiently into the target environment.

This role requires a hands-on Consultant with strong SQL expertise particularly in Oracle who can take ownership of migration tasks proactively identify risks and collaborate closely with technical and business stakeholders as well as end users.

Key Responsibilities

Design develop maintain and execute ETL processes to migrate data from legacy systems to target platforms.    

Data profiling data structure analysis and modelling for new migration solutions where necessary using data manipulation tools.

Maintain design write and optimise PLSQL and SQL solutions (preferably Oracle) to support data migration(ETL) and merge.

Apply a strong data quality framework in solutions to ensure accuracy reconciliation timeliness data integrity and efficiency.

Collaborate with migration team consultants and revenues and benefits consultants to ensure migration quality integrity accuracy and efficiency are maintained

Engage with end users to assess needs and concerns regarding migration/merge progress and issues.

Providing solutions and feedback to migration issues raised by the customer after each test migration.

Provide clear documentation of migration processes data mappings and data quality checks.    

Qualifications :

Essential:

Solid understanding of data transformations and ETL workflows.

Experience in data migration projects.

Knowledge and application of data analysis and quality processes in migration processes.

Strong SQL development skills preferably within Oracle environments.

Experience in engaging with customers/end users as well as collaborating with colleagues.

Strong problem-solving mindset with the ability to take ownership and work independently.

Desirable Skills

Experience in local government data migration projects.

Experience with other databases (Ingres Postgres MySQL).

Knowledge of data modelling data warehousing or data integration tools.

Additional Information :

We pride ourselves in offering an excellent benefits package including an above average pension scheme. When you join the team at NEC Software Solutions you are provided with the following:

• Private Medical Cover funded by NEC for Employees (with the option to add family members at an additional cost) 
• 25 days paid holiday with the option to buy/sell 
• 4 x basic salary life assurance cover funded by NEC (with the option to increase cover at an additional cost)
• A Group Pension Plan with fantastic employer contributions up to a maximum of 8.5%
• A selection of flexible benefits to suit your individual needs
• All colleagues get free access to LinkedIn Learning. Over 15000 courses covering a huge breadth of subjects. Learn about what you like when you like how you like. 

OTHER INFORMATION

• Candidates must be able to demonstrate a pre-existing right to work and travel within the UK. Documentary evidence will be required.
• All offers are subject to satisfactory vetting and reference checks. Depending on the nature of the role a Disclosure Barring Service (DBS) check may also be required.

NEC Software Solutions is an equal opportunities employer welcoming applications from all communities. If you require any reasonable adjustments or have specific accessibility needs during the recruitment or interview process please feel free to share these with us. We are committed to ensuring an inclusive and accommodating experience for all candidates.

Who We Are:

Were NEC Software Solutions (part of global tech giant NEC Corporation). While you read this ad our software is helping to dispatch ambulances support families keep trains on the move locate missing people and even test the hearing of newborn babies.

Working with us youll be helping our 3000 employees push the boundaries of whats possible and support amazing public services.

We work with governments hospitals police forces housing providers local authorities and more. We help them pay financial support faster speed up treatments for patients and respond to emergencies in the right way. The more we do the more our customers can do for others. And together we make a world of difference.

Wed love your help. And well support you all the way.

Remote Work :

Yes

Employment Type :

Full-time