At a Glance
- Tasks: Lead data migration from legacy systems to our client's innovative platform.
- Company: Join a forward-thinking company in the pensions and financial services sector.
- Benefits: Competitive day rate, remote work, and potential for contract extension.
- Other info: Flexible working hours and a dynamic team environment await you.
- Why this job: Make a real impact by ensuring data integrity and supporting client transitions.
- Qualifications: Proficient in T-SQL with experience in data migration and software implementation.
The predicted salary is between 45000 - 60000 £ per year.
Our client provides digital administration and management software for pension schemes, including a cloud-based platform designed to support administration, calculation, and workflow processes. They operate within the pensions and financial services sector, supporting administrators, actuaries, and pension scheme stakeholders such as members, employers, and trustees. Their platform is designed to enable online access, automation, and self-service functionality for managing pension scheme activities.
Role Summary
This role exists to lead the planning and movement of data from clients' legacy systems into the our clients product suite. It supports client delivery and software implementation activities, including gathering requirements, configuring systems, and ensuring that migrated data is accurate and fit for use. You will be responsible for successful data migration and system configuration, enabling clients to transition to the our clients platform while maintaining data integrity and supporting ongoing system use.
Core Duties/Responsibilities
- Design, implement, and optimise SQL-based data solutions to support data migration and reporting needs
- Develop data migration plans and processes, ensuring minimal disruption and data integrity
- Perform ETL operations to migrate data between systems
- Collaborate with team members to gather data requirements and design solutions
- Monitor and improve database performance, including indexing, partitioning, and query optimisation
- Ensure compliance with data protection and privacy standards
- Configure workflows, data maintenance screens, interfaces, pensioner payroll, data migrations and reports
- Communicate with clients to obtain feedback and approval during software customisation
- Customise software systems based on client needs and specifications
- Educate clients on system use and customised features
- Create documentation for clients and internal use
- Support software release and upgrade processes when required
- Build credibility with team members and clients
- Record time
- Liaise with clients to gather requirements and produce specifications
- Manage multiple parallel tasks and prioritise workload effectively
Skills, Capabilities and Attributes
- T-SQL proficiency
- Experience working with SQL Server and Microsoft SQL Server Management Studio
- Data migration experience including ETL, data mapping, transformation, reconciliation, and validation
- Database design and data modelling
- Query optimisation and database performance management
- Software implementation experience
- Configuration or development of pensions or financial services software
- Pension calculations experience (Defined Benefit and Defined Contribution)
- Experience working on pension administration systems (e.g. IntelliPen, Equiniti Compendia, Aquila Administrator, Profund oPen)
- Requirements gathering and specification production (including client liaison)
- Client communication, customer service, and stakeholder interaction
- Analytical and problem-solving capability
- Workload prioritisation and task management
- Understanding of business processes and workflows
- Technical adaptability and learning new systems and technologies
- XML knowledge
Core Hours - 37.5 per week, Monday–Friday
Location - Remote
Day Rate - Competitive D.O.E via umbrella
Duration - 6 months with possibility to extend
Please note any offer is subject to satisfactory pre-employment screening checks. These consist of employment, activity & GAP verification, DBS or Access NI, Credit, Sanctions & CIFAS checks.
We are committed to equality of opportunity for all hires and applications from individuals are encouraged regardless of age, disability, sex, gender reassignment, sexual orientation, pregnancy and maternity, race, religion or belief and marriage and civil partnerships.
Pension Data Migration Implementation Consultant in Hull employer: EQ Hazell Carr
Our client is an exceptional employer, offering a dynamic work culture that prioritises innovation and collaboration within the pensions and financial services sector. Employees benefit from competitive remuneration, flexible remote working arrangements, and ample opportunities for professional growth through hands-on experience with cutting-edge technology and client engagement. Join a team that values diversity and fosters an inclusive environment, ensuring every voice is heard and every contribution is recognised.
StudySmarter Expert Advice🤫
We think this is how you could land Pension Data Migration Implementation Consultant in Hull
✨Tip Number 1
Network like a pro! Reach out to people in the pensions and financial services sector on LinkedIn. Join relevant groups, participate in discussions, and don’t be shy to ask for informational interviews. You never know who might have a lead on your dream job!
✨Tip Number 2
Show off your skills! Create a portfolio or a personal website showcasing your SQL-based data solutions and any successful data migrations you've led. This gives potential employers a tangible look at what you can do and sets you apart from the crowd.
✨Tip Number 3
Prepare for interviews by brushing up on common questions related to data migration and software implementation. Practice explaining your past experiences with ETL processes and client communication. Confidence is key, so rehearse until you feel ready to impress!
✨Tip Number 4
Don’t forget to apply through our website! We’ve got loads of opportunities that might just be perfect for you. Plus, applying directly shows your enthusiasm and commitment to joining our team. Let’s get you started on this exciting journey!
We think you need these skills to ace Pension Data Migration Implementation Consultant in Hull
Some tips for your application 🫡
Tailor Your CV:Make sure your CV speaks directly to the role of Pension Data Migration Implementation Consultant. Highlight your T-SQL proficiency and any relevant experience with SQL Server, as well as your data migration skills. We want to see how your background fits into our client's needs!
Craft a Compelling Cover Letter:Your cover letter is your chance to shine! Use it to explain why you're the perfect fit for this role. Mention specific experiences that relate to the core duties, like your work with ETL operations or client communication. Let us know what excites you about the opportunity!
Showcase Your Problem-Solving Skills:In your application, don’t forget to highlight your analytical and problem-solving capabilities. Share examples of how you've tackled challenges in past roles, especially those related to data migration or software implementation. We love seeing how you think on your feet!
Apply Through Our Website:We encourage you to apply through our website for a smoother process. It helps us keep track of your application and ensures you get all the updates. Plus, it shows us you're keen on joining our team at StudySmarter!
How to prepare for a job interview at EQ Hazell Carr
✨Know Your SQL Inside Out
Since the role heavily relies on T-SQL and SQL Server, make sure you brush up on your SQL skills. Be prepared to discuss your experience with data migration, ETL processes, and how you've optimised queries in past projects.
✨Understand the Pensions Landscape
Familiarise yourself with pension administration systems and the specific software mentioned in the job description. Knowing the ins and outs of Defined Benefit and Defined Contribution calculations will give you an edge and show that you're serious about the role.
✨Prepare for Client Interaction Scenarios
This position involves a lot of client communication, so think of examples where you've successfully gathered requirements or customised solutions based on client feedback. Practising these scenarios can help you articulate your experience effectively during the interview.
✨Showcase Your Problem-Solving Skills
Be ready to discuss how you've tackled challenges in previous roles, especially related to data integrity and system configuration. Highlighting your analytical skills and ability to manage multiple tasks will demonstrate your capability to thrive in this role.
