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: Dynamic role 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.
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.
Locations
Pension Data Migration Implementation Consultant in Cheshire, Warrington 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 Cheshire, Warrington
✨Tip Number 1
Network like a pro! Reach out to your connections in the pensions and financial services sector. Attend industry events or webinars, and don’t be shy about introducing yourself. You never know who might have a lead on that perfect role!
✨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 bring to the table.
✨Tip Number 3
Prepare for interviews by brushing up on your technical knowledge and soft skills. Be ready to discuss your experience with ETL processes and how you’ve ensured data integrity in past projects. Practice common interview questions with a friend to boost your confidence!
✨Tip Number 4
Don’t forget to apply through our website! We’re always on the lookout for talented individuals like you. Plus, it’s a great way to ensure your application gets the attention it deserves. Let’s get you that dream job!
We think you need these skills to ace Pension Data Migration Implementation Consultant in Cheshire, Warrington
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 experience with SQL, data migration, and any relevant software implementation projects. We want to see how your skills align with what our client is looking for!
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 job description, especially around data integrity and client communication. We love a good story that showcases your skills!
Showcase Your Technical Skills:Since this role involves a lot of technical work, make sure to highlight your T-SQL proficiency and any experience with SQL Server. If you've worked on pension administration systems before, shout about it! We want to see your technical prowess front and centre.
Apply Through Our Website:We encourage you to apply through our website for a smoother application process. It helps us keep track of your application and ensures you don’t miss out on any important updates. Plus, it’s super easy – just a few clicks and you’re done!
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 ready to discuss your experience with SQL Server and how you've used it in 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 basics of pension schemes and the software used in the industry. Knowing terms like Defined Benefit and Defined Contribution will help you communicate effectively and show that you’re genuinely interested in the role.
✨Prepare for Client Interaction Scenarios
Since this role involves liaising with clients, think of examples where you’ve successfully gathered requirements or handled client feedback. Be ready to demonstrate your communication skills and how you build credibility with stakeholders.
✨Showcase Your Problem-Solving Skills
Be prepared to discuss past experiences where you had to analyse data issues or optimise workflows. Highlight your analytical capabilities and how you approach problem-solving, especially in a fast-paced environment like data migration.
