At a Glance
- Tasks: Transform complex KPI models into actionable insights using SQL and Microsoft technologies.
- Company: Join a forward-thinking company in Surrey with a hybrid work culture.
- Benefits: Competitive pay, flexible working options, and opportunities for professional growth.
- Other info: Dynamic role with potential for career advancement in a supportive environment.
- Why this job: Make a real impact by developing innovative KPI solutions that drive business success.
- Qualifications: Experience in SQL development and strong collaboration skills required.
The predicted salary is between 50000 - 60000 € per year.
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.
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 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.
- 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.
KPI Developer in London employer: Evolve Technical Recruitment
Our client offers a dynamic and supportive work environment in Surrey, where innovation and collaboration are at the forefront of their culture. As a KPI Developer, you will benefit from hybrid working arrangements, competitive remuneration, and opportunities for professional growth, all while contributing to impactful projects that drive business success. Join a team that values your expertise and fosters a culture of continuous learning and development.
Contact Detail:
Evolve Technical Recruitment Recruiting Team
StudySmarter Expert Advice🤫
We think this is how you could land KPI Developer in London
✨Tip Number 1
Network like a pro! Reach out to your connections in the industry, attend meetups, and engage with professionals on LinkedIn. You never know who might have the inside scoop on a KPI Developer role or can refer you directly.
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your previous KPI development projects, SQL queries, and any relevant technical documentation. This will give potential employers a clear view of what you can bring to the table.
✨Tip Number 3
Prepare for interviews by brushing up on your technical knowledge and problem-solving skills. Be ready to discuss your experience with ETL procedures and how you've tackled complex data challenges in the past.
✨Tip Number 4
Don't forget to apply through our website! We make it easy for you to find and apply for roles that match your skills. Plus, it shows you're serious about joining our team!
We think you need these skills to ace KPI Developer in London
Some tips for your application 🫡
Tailor Your CV:Make sure your CV is tailored to the KPI Developer role. Highlight your experience with SQL, ETL procedures, and any relevant projects that showcase your skills in developing KPI suites. We want to see how your background aligns with what we're looking for!
Showcase Your Technical Skills:Don’t hold back on showcasing your technical skills! Mention your advanced knowledge of T-SQL, SSIS, and any experience with C#. We love seeing candidates who can communicate complex solutions clearly, so make sure to include examples of how you've done this in the past.
Highlight Collaboration Experience:Since the role involves working closely with BAs and other team members, highlight your experience in building collaborative relationships. Share specific examples of how you’ve worked with others to deliver successful outcomes, as teamwork is key for us at StudySmarter.
Apply Through Our Website:We encourage you to apply through our website for a smoother application process. It’s the best way for us to receive your application and ensures you don’t miss out on any important updates. We can’t wait to see what you bring to the table!
How to prepare for a job interview at Evolve Technical Recruitment
✨Know Your SQL Inside Out
As a KPI Developer, you'll need to showcase your advanced knowledge of T-SQL. Brush up on complex stored procedures and be ready to discuss how you've optimised data extraction and cleaning in past projects. Prepare examples that highlight your experience with SQL Server processors.
✨Demonstrate Your ETL Expertise
Be prepared to talk about your experience developing ETL procedures from multiple data sources. Think of specific instances where you successfully integrated structured and unstructured data. This will show your ability to handle the complexities of data flows as outlined in the job description.
✨Collaboration is Key
Since you'll be working closely with BAs and Test Managers, emphasise your ability to build collaborative relationships. Share examples of how you've effectively communicated technical solutions to both technical and non-technical colleagues. This will demonstrate your teamwork skills and adaptability.
✨Prepare for Testing Discussions
Testing is a crucial part of the role, so be ready to discuss your experience with testing techniques. Highlight how you've ensured that development meets quality requirements and how you've contributed to testing strategies in previous roles. This will show that you understand the importance of quality assurance in KPI development.
