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 Milton Keynes employer: EQ Hazell Carr
Our client is an exceptional employer, offering a dynamic work culture that prioritises employee growth and development within the pensions and financial services sector. With a focus on innovation and collaboration, employees benefit from competitive remuneration, flexible remote working arrangements, and opportunities to engage in meaningful projects that enhance their skills and career progression.
StudySmarter Expert Advice🤫
We think this is how you could land Pension Data Migration Implementation Consultant in Milton Keynes
✨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 Milton Keynes
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 this role and how your skills align with our client's needs. Don't forget to mention your experience in pensions or financial services software – it’ll make you stand out to us!
Showcase Your Problem-Solving Skills:In your application, give examples of how you've tackled challenges in past roles, especially related to data migration and system configuration. We love seeing analytical and problem-solving capabilities in action, so share those success stories with us!
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’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 queries or managed database performance.
✨Understand the Pensions Landscape
Familiarise yourself with the basics of pension schemes, especially Defined Benefit and Defined Contribution plans. Knowing the terminology and processes will help you communicate effectively and show that you understand the industry, which is crucial for this role.
✨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 build credibility with stakeholders.
✨Showcase Your Problem-Solving Skills
Be prepared to discuss specific instances where you've encountered data migration challenges and how you resolved them. Highlight your analytical capabilities and your approach to ensuring data integrity during migrations, as this will be key to their operations.
