KPI Developer

A critical role within this team is the KPI Developer, who will report to the Solution Technical Lead

Role is for an experience 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 reps 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 calculation models.

·KPI Developer will develop e2e 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 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

Educational

Professional

Technical Staffing Resources (TSR) are the in-house agency and master vendor for KBR who are a leading global engineering, construction, and services company. KBR support the hydrocarbon and government services markets on six continents. Serving their customers through diverse business units, KBR offer 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 abond 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 each A - 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 client's portfolio. 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 - this is known as the 'Workplace Services Programme' or 'WPS', redesigning/repackaging contractual services into six new service lots, reimagining the service landscape and requiring KBR redesign and remobilise the current platform and a scale transition of current service to new service. This went live 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 have 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.