At a Glance
- Tasks: Develop and systemise complex KPI models using SQL and Microsoft technologies.
- Company: Join KBR, a leading global engineering and services company with exciting projects worldwide.
- Benefits: Competitive salary, health benefits, and opportunities for professional growth.
- Other info: Dynamic team environment with excellent career advancement opportunities.
- Why this job: Make a real impact by optimising asset management through innovative technology solutions.
- Qualifications: Experience in SQL development and KPI suite creation is essential.
The predicted salary is between 50000 - 65000 £ per year.
Technical Staffing Resources (TSR) are the in-house agency and master vendor for KBR, a leading global engineering, construction, and services company. KBR supports the hydrocarbon and government services markets on six continents, offering challenging assignments on some of the world's largest and most complex projects.
KBR's Estates Intelligence division specialises in enabling clients to make informed decisions about the 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 benefits by deploying their Viaverse platform to enable:
- 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 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 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.
Locations
KPI Developer in Guildford, Surrey employer: Technical Staffing Resources Limited
Contact Detail:
Technical Staffing Resources Limited Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land KPI Developer in Guildford, Surrey
✨Tip Number 1
Network like a pro! Get out there and connect with people in the industry. Attend meetups, webinars, or even just grab a coffee with someone who works at KBR. You never know who might have the inside scoop on job openings or can put in a good word for you.
✨Tip Number 2
Show off your skills! Create a portfolio or a GitHub repository showcasing your projects, especially those related to KPI development or SQL. This gives potential employers a tangible look at what you can do and sets you apart from the crowd.
✨Tip Number 3
Prepare for interviews by practising common technical questions related to SQL and KPI development. We recommend doing mock interviews with friends or using online platforms to get comfortable with the format and types of questions you might face.
✨Tip Number 4
Don’t forget to apply through our website! It’s the best way to ensure your application gets seen by the right people. Plus, it shows you’re genuinely interested in joining the team at KBR.
We think you need these skills to ace KPI Developer in Guildford, Surrey
Some tips for your application 🫡
Tailor Your CV: Make sure your CV is tailored to the KPI Developer role. Highlight your experience with SQL, T-SQL, and any relevant projects you've worked on. We want to see how your skills match up with what we're looking for!
Craft a Compelling Cover Letter: Your cover letter is your chance to shine! Use it to explain why you're passionate about the role and how your background makes you a great fit. Don’t forget to mention your experience with KPI suites and ETL procedures.
Showcase Your Technical Skills: In your application, be sure to showcase your technical skills, especially in T-SQL and SSIS. We love seeing examples of how you've used these skills in past projects, so don’t hold back!
Apply Through Our Website: We encourage you to apply through our website for the best chance of getting noticed. It’s super easy, and we can’t wait to see your application come through!
How to prepare for a job interview at Technical Staffing Resources Limited
✨Know Your KPIs
Before the interview, make sure you understand the key performance indicators relevant to the role. Brush up on how they are calculated and their significance in asset management. This will show that you're not just familiar with the terminology but can also engage in meaningful discussions about them.
✨Showcase Your SQL Skills
Prepare to discuss your experience with T-SQL and any complex stored procedures you've developed. Be ready to provide examples of how you've used SQL to solve problems or improve processes. This is a technical role, so demonstrating your expertise here is crucial.
✨Understand the Business Logic
Familiarise yourself with the business logic behind KPI calculations. Think about how you would translate complex models into practical outputs. Being able to articulate this during the interview will highlight your analytical skills and understanding of the role's requirements.
✨Collaborate and Communicate
Since the role involves working closely with BAs and other team members, be prepared to discuss your experience in collaborative environments. Share examples of how you've effectively communicated technical solutions to both technical and non-technical audiences, as this will demonstrate your ability to work within a multidisciplinary team.