Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Develop and maintain software systems for pensions administration using SQL and innovative technologies.
- Company: A leading third-party pensions administrator with a focus on quality and member experience.
- Benefits: Competitive salary, supportive work culture, and opportunities for professional growth.
- Why this job: Join a dynamic team and make a real impact in the pensions industry with your tech skills.
- Qualifications: Experience in SQL development and a passion for problem-solving and continuous learning.
- Other info: Fast-paced environment with excellent career advancement opportunities.
The predicted salary is between 36000 - 60000 £ per year.
We are a specialist third-party pensions administrator. Founded in 2006, our mission is to set the highest standard of pensions administration by any recognised measure. We aim to achieve this through sustained investment in our people, processes and systems. We started life as an in-house administrator. Our foundations are in quality and member experience. Since our creation, we have grown as a third-party administrator. Adopting technology and innovation from across the market, we have emerged as a business of administration experts. With offices in London and Farnborough, we hold internationally recognised accreditations for quality, security, development, customer service and environmental protection.
Main purpose of the role
The Pensions Developer is responsible for developing, configuring and maintaining systems and software used across Trafalgar House. The role ensures high quality, efficient and secure technical solutions that support business operations, data integrity and member experience. The postholder provides technical expertise in SQL, data manipulation and system configuration, supporting both project delivery and BAU activities. They work closely with Business Analysts, Developers and system users to translate requirements into robust technical solutions and ensure smooth implementation, testing and transition into live operation.
Responsibilities
- Service Delivery & Technical Expertise
- Develop, configure and support all software and systems used by Trafalgar House.
- Write secure, efficient SQL queries including select and update statements, stored procedures and views.
- Analyse, interrogate and manipulate data using SQL Server and coding skills.
- Map data feeds into IntelliPen using IntelliFeed and SQL, ensuring full understanding and documentation of data requirements.
- Produce development assets that adhere to technical standards and support high quality member and client experience.
- Translate functional and technical specifications into system solutions that are fit for purpose.
- Provide technical support to the business, resolving issues and enabling smooth system operation.
- Operational Coordination & Workflow Management
- Plan and prioritise development tasks to meet project timelines and operational needs.
- Work with Business Analysts and system users to scope requirements and coordinate development activity.
- Support integration of applications by collaborating with other developers and ensuring alignment with standards and processes.
- Ensure effective release planning and smooth handover into live service.
- Maintain structured, accurate reporting of development status, progress and issues.
- Quality Control, Compliance & Risk Management
- Ensure all development is fully documented and compliant with regulatory, architectural, security and operational standards.
- Support and perform appropriate testing processes, ensuring robust quality assurance prior to release.
- Maintain and update IntelliPen system components, including database updates, extracts, reports and change request testing.
- Monitor data accuracy, solution performance and adherence to standards, escalating risks as required.
- Demonstrate awareness of ISO22301 and relevant policies within the Business Continuity Management System, including required actions in an incident.
- Process Improvement & Change
- Contribute to process improvements by identifying opportunities to enhance efficiency, quality and the user experience.
- Lead or support small scale improvement initiatives within development or system processes.
- Maintain up to date documentation, identifying opportunities to streamline or standardise development activity.
- Support new business and onboarding activities through system analysis, data conversion routines and technical delivery.
Qualifications
Essential
- Technical experience in a SQL database development environment with strong understanding of relational databases.
- Skilled in coding SQL queries, including complex select and update logic, with commitment to continuous learning.
- Experience with one or more of: XML, VB.net, VBA, XSLT, HTML.
- Strong analytical and problem solving capability.
- Strong MS Office skills, particularly Excel.
- Ability to work independently or collaboratively with minimal supervision.
- High level of accuracy, quality focus and structured approach to work.
- Ability to manage multiple priorities effectively.
Desirable
- Understanding of pensions administration and/or payroll.
- Experience with IntelliPen.
- Exposure to data migrations, new client implementations or large scale data manipulation projects.
- Ability to communicate and build effective relationships with stakeholders.
- Comfortable working in a fast paced, small business environment.
Personal qualities
- Supportive, proactive and confident in technical decision making.
- Logical and structured in approach with strong organisational capability.
- Adaptable and calm when managing multiple or competing priorities.
- Collaborative, positive and committed to continuous improvement.
Other information
Reporting line: Reports to: Pension Systems Manager
Pensions Developer employer: Trafalgar House Pensions Administration
Contact Detail:
Trafalgar House Pensions Administration Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Pensions Developer
✨Tip Number 1
Network like a pro! Reach out to people in the pensions industry, especially those who work at companies you're interested in. A friendly chat can open doors and give you insider info that could help you stand out.
✨Tip Number 2
Show off your skills! If you’ve got a portfolio or examples of your SQL queries and projects, bring them along to interviews. It’s a great way to demonstrate your technical expertise and problem-solving abilities.
✨Tip Number 3
Prepare for the unexpected! Be ready for technical questions or practical tests during interviews. Brush up on your SQL skills and be prepared to discuss how you've tackled challenges in past projects.
✨Tip Number 4
Don’t forget to apply through our website! We love seeing candidates who take the initiative. Plus, it shows you’re genuinely interested in joining our team and contributing to our mission.
We think you need these skills to ace Pensions Developer
Some tips for your application 🫡
Tailor Your CV: Make sure your CV is tailored to the Pensions Developer role. Highlight your SQL skills and any relevant experience with data manipulation or system configuration. We want to see how your background aligns with our mission of quality and member experience.
Craft a Compelling Cover Letter: Your cover letter is your chance to shine! Use it to explain why you're passionate about pensions administration and how your technical expertise can contribute to our team. Keep it concise but impactful, showing us your personality and enthusiasm.
Showcase Your Problem-Solving Skills: In your application, don’t forget to mention specific examples where you've tackled complex problems using SQL or other coding skills. We love seeing how you approach challenges and find solutions that enhance efficiency and quality.
Apply Through Our Website: We encourage you to apply directly through our website for the best chance of getting noticed. It’s the easiest way for us to keep track of your application and ensures you’re considered for the role. Good luck!
How to prepare for a job interview at Trafalgar House Pensions Administration
✨Know Your SQL Inside Out
Make sure you brush up on your SQL skills before the interview. Be prepared to discuss complex queries you've written and how you've used them to solve problems. Practising writing select and update statements will help you feel more confident when discussing your technical expertise.
✨Understand the Pensions Landscape
Familiarise yourself with the basics of pensions administration and the specific systems used by the company, like IntelliPen. Showing that you have a grasp of the industry will demonstrate your commitment and interest in the role, making you stand out as a candidate.
✨Prepare for Scenario-Based Questions
Expect questions that ask you to solve hypothetical problems or describe past experiences. Think about times when you've had to analyse data or troubleshoot issues. Use the STAR method (Situation, Task, Action, Result) to structure your answers clearly and effectively.
✨Showcase Your Collaborative Spirit
Since the role involves working closely with Business Analysts and other developers, be ready to discuss how you've successfully collaborated in the past. Highlight any experiences where you’ve contributed to team projects or improved processes, as this will show you're a great fit for their collaborative culture.