At a Glance
- Tasks: Lead data migration from legacy systems to a cutting-edge pension platform.
- Company: Join a forward-thinking company revolutionising pension administration with innovative software.
- Benefits: Enjoy a competitive day rate, remote work flexibility, and potential for contract extension.
- Other info: Work in a dynamic environment with opportunities for professional growth and skill development.
- Why this job: Make a real impact by ensuring data integrity for clients transitioning to modern solutions.
- Qualifications: Proficiency in T-SQL and experience with SQL Server and data migration processes.
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 Colchester employer: EQ Hazell Carr
As a leading provider of digital administration and management software for pension schemes, our client offers an exceptional work environment that prioritises employee growth and development. With a strong focus on collaboration and innovation, employees are encouraged to enhance their skills while contributing to meaningful projects that support the pensions and financial services sector. The remote working model provides flexibility, allowing team members to maintain a healthy work-life balance while being part of a dynamic and inclusive culture.
StudySmarter Expert Advice🤫
We think this is how you could land Pension Data Migration Implementation Consultant in Colchester
✨Tip Number 1
Network like a pro! Reach out to folks in the pensions and financial services sector on LinkedIn. Join relevant groups, participate in discussions, and don’t be shy about asking for informational interviews. You never know who might have the inside scoop on job openings!
✨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 is a great way to demonstrate your expertise and make a lasting impression on potential employers.
✨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 operations and client communication. The more confident you are, the better you'll perform!
✨Tip Number 4
Don’t forget to apply through our website! We’ve got loads of opportunities that might just be the perfect fit for you. Plus, applying directly can sometimes give you an edge over other candidates. So, what are you waiting for? Get your application in!
We think you need these skills to ace Pension Data Migration Implementation Consultant in Colchester
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 perfectly with what we're looking for!
Craft a Compelling Cover Letter:Your cover letter is your chance to shine! Use it to explain why you're passionate about the pensions and financial services sector. Share specific examples of your past experiences that align with the core duties of the role. Let us know why you’re the perfect fit!
Showcase Your Problem-Solving Skills:In your application, don’t forget to mention your analytical and problem-solving capabilities. We love candidates who can think on their feet and tackle challenges head-on, especially when it comes to data migration and system configuration.
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 don’t miss out on any important 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
Make sure you brush up on your T-SQL skills before the interview. Be prepared to discuss your experience with SQL Server and how you've used it in past data migration projects. They’ll likely want to hear about specific challenges you faced and how you optimised database performance.
✨Understand the Pensions Landscape
Familiarise yourself with the pensions and financial services sector, especially the software solutions used for pension administration. Knowing the ins and outs of systems like IntelliPen or Equiniti Compendia will give you an edge and show that you're genuinely interested in the role.
✨Prepare for Client Communication Scenarios
Since this role involves liaising with clients, think of examples where you've successfully gathered requirements or managed client expectations. Practise articulating how you would handle feedback during software customisation, as strong communication skills are key.
✨Showcase Your Problem-Solving Skills
Be ready to discuss specific instances where you've tackled complex data migration issues. Highlight your analytical capabilities and how you approached problem-solving in previous roles. This will demonstrate your ability to manage multiple tasks and prioritise effectively.
