We are looking for an experienced Data Migration Consultant with pension calculations capability to join a dynamic pension services client.
You will lead the planning and delivery of projects for pensions clients, ensuring legacy system data is transitioned accurately into new environments. Youll design mapping frameworks, build transformation logic, develop automated migration scripts, and rigorously test outputs to validate integrity, using tools such as T-SQL, SQL, Excel macros and XML.
Bringing strong financial services and migration expertise, youll combine technical knowledge with a sharp analytical approach to deliver compliant, accurate outcomes, working within the client delivery team to gather requirements, produce frameworks, configure migrations, and occasionally travel to client sites where needed.
What youll be doing as a Data Migration Consultant:
1. Design, implement, and optimize SQL-based solutions to support migration and reporting needs.
2. Develop plans and processes, ensuring minimal disruption to existing services and integrity.
3. Perform ETL operations to migrate data between systems, ensuring accuracy and completeness.
4. Collaborate with other team members to gather requirements and design solutions that meet project and company goals.
5. Monitor and improve performance, managing indexing, partitioning and query optimization.
6. Ensure complianc...