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 and supporting client transitions.
- Qualifications: Proficiency in T-SQL and experience with SQL Server and data migration.
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 Stoke-on-Trent 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 continuous learning and development. With a commitment to diversity and inclusion, the company fosters an environment where every team member can thrive and contribute meaningfully to impactful projects.
StudySmarter Expert Advice🤫
We think this is how you could land Pension Data Migration Implementation Consultant in Stoke-on-Trent
✨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 about asking 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 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 processes and how you’ve ensured data integrity. Confidence is key, so rehearse until you feel ready to shine!
✨Tip Number 4
Don’t forget to apply through our website! We’re always on the lookout for talented individuals like you. Plus, applying directly can sometimes give you an edge over other candidates. So, get your application in and let’s get you started on this exciting journey!
We think you need these skills to ace Pension Data Migration Implementation Consultant in Stoke-on-Trent
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 projects where you've successfully managed data migrations or implemented software solutions. Let us know how you can add value to our client's team.
Showcase Your Communication Skills:Since this role involves liaising with clients, it's crucial to demonstrate your communication skills in your application. Share examples of how you've effectively gathered requirements or educated clients on system use. We love seeing candidates who can build strong relationships!
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 past data migration projects. They’ll likely want to hear about specific challenges you faced and how you optimised queries or managed database performance.
✨Understand the Pensions Landscape
Familiarise yourself with the basics of pension schemes and the software used in the industry. Knowing the difference between Defined Benefit and Defined Contribution plans can give you an edge. It shows that you’re not just technically savvy but also understand the business context of your work.
✨Prepare for Client Interaction Scenarios
Since this role involves liaising with clients, think of examples where you’ve successfully gathered requirements or customised software based on client needs. Be ready to demonstrate your communication skills and how you handle feedback, as this will be crucial for building credibility with clients.
✨Showcase Your Problem-Solving Skills
Be prepared to discuss specific instances where you encountered problems during data migration or system configuration. Highlight your analytical approach and how you prioritised tasks to ensure minimal disruption. This will illustrate your capability to manage multiple parallel tasks effectively.
