KPI Developer in Guildford

Technical Staffing Resources (TSR) are the in-house agency and master vendor for KBR, a leading global engineering, construction, and services company. Ensure you read the information regarding this opportunity thoroughly before making an application. KBR supports the hydrocarbon and government services markets on six continents. Serving their customers through diverse business units, KBR offers challenging assignments on some of the world's largest and most complex projects.

KBR's Estates Intelligence division specialise in enabling clients to make informed decisions about strategic management of their estates and asset portfolios, including the external supply chain retained to deliver asset management and maintenance services. Estates Intelligence teams utilise the 6 As Methodology to deliver business benefit by deploying their Viaverse platform to enable:

• Aggregation of data
• Automation of transactional processing and operational data flows
• Assurance of process and data integrity to promote sanctity of management information
• Audit of processing and data to better refine business outcomes
• Analytics to offer management information and insight

All to enable enhanced asset management across clients' portfolios. KBR's latest platform was deployed for the Department of Work & Pensions Estates (DWP-E) to deliver the Integrator2 platform in May 2022. This platform acts as the single source of truth for DWP Estates teams in ensuring consistent, performant, and efficient lifecycle management of assets across their public-facing and back-office sites. The platform manages real-time transactional flows to DWP Estates supply chain partners and delivers reliable management information and insight to DWP Estate stakeholders.

In 2023, DWP-E embarked on a major programme of re-procurement of the asset management services delivered from the KBR Integrator2 platform, known as the Workplace Services Programme or WPS, redesigning/repackaging contractual services into six new service lots, reimagining the service landscape and requiring KBR to redesign and remobilise the current platform and scale transition of current service to new service. This went live in October 2025, and there is now a multi-organisational Programme underway of hypercare, stabilisation, and optimisation of platforms and services.

Led by the senior team that mobilised the platform, KBR has in place a multi-disciplinary technology team deployed to deliver this programme. This team is being restructured and extended in 2026 to conclude hypercare exit and deliver deferred design items into a full steady state context.

A critical role within this team is the KPI Developer, who will report to the Solution Technical Lead. The role is for an experienced SQL and Microsoft developer who will be responsible for translating and systemising complex KPI calculation models from data warehouse through calculation engine to client output, working with Programme BAs and client representatives to understand and capture business logic, code the calculation model, and develop outputs, working to develop, test, and commission into live use.

Responsibilities:

• KPI Developer will be required to work alongside BAs in the programme team to understand inbound/outbound data flows resulting from detailed business requirements and functional designs and develop these into pass/fail logic into a developed and documented KPI calculation model.
• KPI Developer will develop end-to-end KPI solutions from data warehouse to output format (may be .xls, POWERBI or other report format), working with BA and client to test the calculation logic for operational use.
• KPI Developer may be required to contribute toward more detailed solution designs for the wider platform, including KPI technical specifications and amendments to data warehouse technical documentation.
• KPI Developer will be required to work alongside Test Managers in the programme to ensure KPI calculation testing meets the testing strategy and acceptance criteria for promotion to live environment.
• KPI Developer will be required to work closely with Programme Technical Project Manager and Project Coordinator to ensure development critical path is reasonable, deconflicted and achievable, task progress is reported to meet reporting timeframes, and advise where there is actual over/under-utilisation on tasks so action can be taken to mitigate.

Experience Requirements:

• Experience developing KPI suites and/or Paymech suites.
• Experience developing ETL procedures from multiple data sources to one data source.
• Adept at building collaborative technical and business working relationships to deliver outputs and outcomes.
• Experienced in authoring technical documentation, able to write clear and maintainable artefacts to support developments.
• Experienced in testing techniques to ensure development meets quality requirements.

Technical Skills/Knowledge:

• Advanced Knowledge of T-SQL to deliver complex stored procedures, and other SQL Server processors for optimised data extraction, cleaning, conforming, and delivering data into a SQL Server Data Warehouse (PL-SQL and My-SQL may also be considered if other criteria met).
• Advanced Knowledge of SSIS including MPP, advanced error management and integration with structured, semi-structured and unstructured data sources.
• Experience of developing in C# within SSIS and for advanced integration.
• Experience of working in a DevOps Agile Environment with differing skill levels.
• Experience of implementing advanced DW techniques, including but not limited to SCD, index strategies, dimensional modelling, performance optimisation.
• Able to communicate a technical solution to a wide audience of technical and non-technical colleagues and clients.

Qualifications/Certifications Requirements:

• Essential: Microsoft Certified.
• Desirable: Degree Educated preferably in a technical subject.