New Job Opening: KPI Developer in London

KPI Developer

Our client is recruiting a KPI Developer who will report to the Solution Technical Lead. The contract will be for an initial 8 months based in our clients’ offices in Surrey. The engagement will be Outside of IR35 with hybrid working available.
 

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

• 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.