Data Programmer

Xafinity Consulting Ltd; Manchester; Hybrid; GBP 40,000 - 65,000; Full time

Benefits offered by this job

Discretionary bonus

25 days holiday

Pension matching

Healthcare

Life assurance

Retailer discounts

Volunteer days

Referral bonuses

Job summary

XPS Group in Manchester is seeking a Data Programmer to design, build and maintain data systems powering analytics. You will work with SQL, ETL processes and Azure Data Factory to deliver reliable data solutions for pension administration clients.

The role sits in IST and involves collaboration with analysts and IT teams, producing documentation, testing strategies, and supporting data services across projects. A strong SQL background and experience with data modelling are required.

Qualifications

• Strong proficiency in SQL with complex joins, subqueries and window functions.
• Familiarity with ETL tools or frameworks.
• Understanding of relational database concepts and data modelling.
• Ability to work with large datasets and optimise query performance.
• Excellent organisational and planning skills.
• Able to work in a multi-disciplinary team and influence decisions.
• Ability to multi-task and adapt to changing priorities.
• Ability to create and manage documentation.
• Familiarity with software development methodologies (Agile, ITIL).

Responsibilities

• Develop, optimise, and maintain SQL scripts for ETL processes.
• Meet business requirements and client implementation needs.
• Collaborate with internal/external colleagues to expand knowledge.
• Analyse data queries to ensure correctness across workstreams.
• Gather requirements and document lifecycle of projects.
• Translate client requirements into formal documentation/specifications.
• Create testing strategies and perform thorough testing.
• Document and communicate changes to core products/processes.
• Provide guidance within the Data Services team and mentor colleagues.
• Support the Implementations Manager in driving best practices.

Skills

SQL expertise

ETL skills

Data modelling

Analytical thinking

Team collaboration

Education

A-Levels or equivalent qualifications

Tools

Azure Data Factory

Excel

PenScope

Compendia

ProFund Classic

Job description

At XPS, we don't just value the work you do – we value you. Your ambition, your ideas, your career goals and your life outside of work.Whether you're looking for your next challenge, greater flexibility, or a place where you can make a real impact, you'll find opportunities to thrive at XPS. We're built on collaboration, trust and expertise, giving our people the freedom to work their way, shape their path and be themselves.If you're looking for a career where you can grow, belong and make a difference, we'd love to hear from you.Find a career that's built for you.

The job requirements are detailed below. Where applicable the skills, qualifications and memberships required for this job have also been included.As disability confident committed, we will support all applicants throughout the recruitment process. Each stage of the process is inclusive and offers reasonable adjustments where required.If you need the job description in an alternative format or would like us to do anything differently during the application process, please let us know.

Job details

Contractual hours 36.25

Basis Full time

Job category/type - XPS Administration

Date posted 31/07/2026

Job reference REQ003744

Data Programmer

Location: Manchester

Employment Type: Permanent, Full Time

Grade: Consultant

Hybrid

REQ003744

About XPS Group:

XPS Group is a prominent and growing UK consultancy and administration firm within the pensions and insurance sectors. As a FTSE 250 company with over 2000 employees, we leverage expertise alongside advanced technology to serve over 1,400 pension schemes and their sponsors. Our goal is to foster a workplace where diverse talents thrive.

About the Role:

Our teams of pension administrators provide services to a wide range of trust-based company pension schemes, including defined benefit, defined contribution, career average revalued earnings, and hybrid schemes. Our range of pensions administration services include:

• Scheme administration
• Communication
• Scam identification
• Payroll services
• De-risking projects
• Technical consultancy

Our administrative approach is scheme-based; one team is responsible for every aspect of each client’s service, enabling us to build the best possible relationships and provide the clarity of focus each scheme deserves.

Ultimately, pension schemes are there for their members; we place just as much emphasis on delivering excellent customer service as we do on technical proficiency and quality control.

This role is within Implementation Services (IST). IST is comprised of specialist teams whose members support the XPS Administration business in a variety of areas. The teams provide technical, IT and specialist expertise to XPS Administration that underpins the quality solutions we provide to our administration clients. The teams are located across the XPS Administration national offices.

The key areas in which IST provide support are:

• New Client Implementations (Data & Calculations)
• Data and Calculation Support
• Business Interface with IT Services
• Management Reporting

Key Responsibilities:

The role is a skilled Data Programmer to help design, build, and maintain the systems that power our data operations. This role blends programming expertise with deep SQL knowledge to ensure data is accurate, accessible, and ready for analysis. You’ll work closely with analysts and business teams to create reliable data solutions that support decision making across the organisation.

• Develop, optimise, and maintain SQL scripts for data extraction, transformation, and loading (ETL).
• Meeting the business requirements and implementation needs of clients in an accurate and timely manner and in accordance with any agreed standards and procedures.
• Expanding knowledge within their discipline by working with internal and external colleagues.
• Identification and analysis of data queries to ensure data is held correctly for all workstreams.
• Requirements gathering and documentation from initiation phase and throughout the lifecycle of the project.
• Working with our internal and external clients to understand their requirements and help to translate them into formal documentation/specifications.
• Produce clear testing strategies and carry out sufficient testing to ensure a high-quality output
• Work with relevant stakeholders/teams to identify functional changes to our core products and processes that are required to ensure business needs are met and to ensure these are formally documented.
• Provide support and mentoring to colleagues within the Data Services team and wider teams.
• Support the Implementations Manager in driving best practice within Data Services team.
• Taking opportunities to lead analysis of solutions or standards, tools and framework through internal technical forums or client projects.

Due to the changing nature of the business, the job holder may from time to time be required to undertake other activities of a similar nature that fall within their capabilities.

Your Profile:

• Strong proficiency in SQL (Complex joins, subqueries, CTEs, window functions, and aggregations).
• Familiarity with ETL tools or frameworks.
• Understanding of relational database concepts and data modelling.
• Ability to work with large datasets and optimise query performance.
• Excellent organisational and planning skills.
• Able to work as part of a multi-disciplined team, influencing decisions where priorities and interests are often conflicting.
• Ability to multi-task and respond to changing priorities.
• Able to take ownership and responsibility, including contributing actively.
• Flexible approach to work pressures.
• Good problem-solving skills and ability to think laterally.
• A high degree of accuracy and attention to detail in technical documentation.
• Strong belief in adhering to deadlines and quality service.
• Able to recognise the need for a customer focused approach to deliveries both in terms of quality and exceeding customer expectations.
• IT proficient in MS Office, with an emphasis on using Excel.
• Azure Data Factory (ADF) Pipeline Development. Ability to create and configure pipelines, datasets, and integration runtimes.
• Proven experience of working within an administration team as a user, or a system support position in the pensions industry is required, covering but not limited to a diverse range of pension arrangements: DB/DC/CARE/Public Sector/Master Trust.
• Experience of working with common pension administration systems and third-party IT suppliers e.g. PenScope, Compendia, ProFund Classic.
• Proficient knowledge in benefit structures for DB, DC and Hybrid pension schemes.
• Candidates with strong A-Level qualifications (or equivalent qualifications)
• Strong written, verbal and presentation skills to all levels.
• Able to articulate complex messages with clarity and ease to all audiences and flex style as required.
• Ability to create and manage documentation.
• Effective interpersonal skills, ability to communicate and build long-term working relationships at all levels, both internal and external of the organisation.
• Understands the methodologies used in a software development and support environment e.g. Agile, Waterfall, ITIL.
• Driving Change & Improvement and adaptable, responding well to feedback and the need for change.

What We Offer:

• Enjoy a competitive salary, annual discretionary bonus, and 25 days' holiday with buy/sell flexibility.
• Benefits include pension matching, healthcare plans, life assurance, and retailer discounts.
• We support our team with a flexible benefits scheme, employee assistance, and digital GP service.
• Participating in volunteering events is encouraged with paid volunteer days available.
• Referral bonuses are offered for introducing suitable candidates to XPS.

XPS Group is committed to diversity and equal opportunities. We welcome applications from all candidates, irrespective of sex, race, disability, sexual orientation, religion, or belief. As a Disability Confident employer, we ensure accessible and supportive work settings for all employees.

Any employment offer made will be conditional upon you satisfying DBS Disclosure checks, Employment or educational references, Satisfactory credit checks and eligibility to work in the UK before an offer can be made. XPS Group is not able to provide sponsorship to employees.