At a Glance
- Tasks: Develop and maintain software systems for efficient pensions management.
- Company: Join Trafalgar House, a dynamic company focused on innovation and collaboration.
- Benefits: Enjoy competitive pay, flexible working options, and opportunities for professional growth.
- Other info: Fast-paced environment with great potential for career advancement.
- Why this job: Make a real difference in the pensions sector with your technical skills.
- Qualifications: Experience in SQL development and a passion for problem-solving required.
The predicted salary is between 54000 - 66000 £ per year.
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.
Key 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 Intelli Pen using Intelli Feed 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 Intelli Pen 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
- 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.
- Understanding of pensions administration and/or payroll.
- Experience with Intelli Pen.
- 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.
- 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.
Pensions Developer in London employer: Trafalgar House
Trafalgar House is an excellent employer, offering a collaborative work culture that values innovation and technical expertise. As a Pensions Calculation Developer, you will have access to continuous professional development opportunities, allowing you to grow your skills in SQL and data analysis while contributing to meaningful projects in a supportive environment. Located in a dynamic sector, the company prioritises employee well-being and fosters a sense of community among its staff.
StudySmarter Expert Advice🤫
We think this is how you could land Pensions Developer in London
✨Join Local Tech Meetups
Get out there and mingle with fellow developers by joining local tech meetups. It’s a fantastic way to meet people who might be working at Trafalgar House or know someone who does. Plus, you can pick up some trendy tech skills and trends while you're at it!
✨Contribute to Open Source Projects
Show off your coding chops by jumping into open-source projects. Not only does this give you practical experience, but it also gets you noticed in the dev community. You'll create a killer portfolio that speaks volumes about your skills to Trafalgar House.
✨Tap into Online Developer Communities
Don’t underestimate the power of online developer communities like GitHub, Stack Overflow, and even Reddit. Participate in discussions, share your projects, and build your visibility. We can often find opportunities through these channels that can lead to a full-time gig at companies like Trafalgar House.
✨Explore Job Boards Specifically for Tech Roles
Keep your eyes peeled on job boards that focus on tech roles. Sites like TechCareers or Stack Overflow Jobs can often have listings for companies like Trafalgar House that might not show up on broader job sites. Make it a habit to check these regularly, and don’t hesitate to apply directly through our website!
We think you need these skills to ace Pensions Developer in London
Some tips for your application 🫡
Show off your coding skills:When applying for a software engineering role, it's super important to showcase your coding skills. Make sure your CV includes your tech stack, any relevant programming languages you’re comfortable with, and examples of projects you've worked on. If you have a GitHub profile, link it up! We love to see code in action.
Tailor your portfolio:For a full-time role, we’d expect to see some solid examples of your work in your portfolio. Make sure to include at least two or three projects that highlight your problem-solving skills and your ability to work with different technologies. Focus on the projects that are most relevant to the position at Trafalgar House.
Craft a killer cover letter:Your cover letter is your chance to stand out—make it personal! Explain why you want to work at Trafalgar House and how your skills align with the role. Show us your passion for software development. We dig enthusiastic candidates who understand the value of collaboration and continuous learning!
Be clear and concise:When it comes to writing your CV and cover letter, clarity is key. Avoid jargon that could confuse us and stick to simple, direct language. Highlight your achievements with quantifiable results where possible, and keep everything easy to read. A well-organised application goes a long way!
How to prepare for a job interview at Trafalgar House
✨Brush Up on Your Coding Skills
For a full-time software engineering role, it's crucial that we stay sharp with our coding abilities. Expect technical questions that might involve solving problems on the spot or discussing algorithms. Practise on platforms like LeetCode or HackerRank to get comfortable with the types of questions that often come up.
✨Know Your Tools and Frameworks
Make sure we’re well-acquainted with the tools and technologies listed in the job description. Familiarise ourselves with any specific frameworks or programming languages mentioned. If Trafalgar House uses React or Node.js, for instance, be ready to discuss how we’ve used them in previous projects or coursework.
✨Showcase Your Projects
Bring along a portfolio that highlights our best work. This could be code samples, GitHub repositories, or any side projects we’ve built. Make sure we can talk through our thought process for each project, especially the challenges we faced and how we solved them—this shows our problem-solving skills in action.
✨Prepare for Behavioural Questions
While technical skills are key, full-time positions also require cultural fit. Be ready to discuss our previous experiences and how we handle teamwork, conflict, and deadlines. Brush up on the STAR method—Situation, Task, Action, Result—to clearly articulate our past experiences when discussing how we've contributed to a team.