Programmer Analyst

Teksystems; City Of London; On-site; GBP 80,000 - 100,000; Full time

Job summary

A leading technology solutions firm in London is seeking an Excel Programmer Analyst for a 6-month contract role. Responsibilities include building reports, ensuring optimal fleet allocation plans, and conducting User Acceptance Testing (UAT). The ideal candidate has advanced Excel skills, critical thinking abilities, and a strong understanding of data analysis. This role offers a competitive daily rate and hybrid working arrangements.

Qualifications

• Advanced level of MS Excel required.
• Strong understanding of User Acceptance Testing (UAT).
• Experience in application support and data analysis.

Responsibilities

• Build reports and fix complex problems in Excel.
• Create, test, and analyse UAT scenarios.
• Develop and evaluate UAT scenarios using real data.
• Implement and test UAT scenarios for optimisation models.

Skills

MS Excel

UAT understanding

Critical thinking

SQL knowledge

Python knowledge

Data analysis

Effective communication

Proficiency in automation

Job description

Overview

Excel Programmer Analyst - 6 Month Contract - INSIDE IR35

No Sponsorship Available

Job Description

We are seeking a talented Programmer Analyst who will be collaborating with the execution of an automation roadmap. This role is pivotal in generating optimal allocation plans and streamlining end-to-end scheduling operations. You will be part of a team responsible for our client's fleet allocation plans, ensuring that Delivery Stations and Delivery Service Partners have the right number of vehicles to complete last mile delivery routes. This team works with multiple stakeholders to ingest required data signals to create a weekly allocation plan and is building automation tools and science models to automate and streamline fleet allocation and scheduling operations, with a focus on User Acceptance Testing (UAT). A strong understanding of UAT is required, but the key skill needed is an advanced level of MS Excel.

Responsibilities

• You will be building reports, correcting corrupted data, and fixing complex problems in Excel before putting your findings into models for the company.
• Maintain expert knowledge in Excel.
• Create, test, and analyse User Acceptance Test (UAT) scenarios to enable the completion of the science optimisation model development.
• Develop, test, and evaluate UAT scenarios using real business data to test the science optimisation model.
• Implement, test, and assess UAT scenarios to operationalise the science optimisation model within the scheduling tools.

Essential Skills

• Understanding of UAT to understand the project; MS Excel is the essential skill for this role.
• Critical thinker with the ability to think independently.
• Expertise in Microsoft Excel.
• Knowledge of SQL.
• Python knowledge.
• Experience in application support.
• Strong data analysis skills.
• Effective communication abilities.
• Proficiency in automation processes.

Contract & Location

This is an initial 6 month contract role operating INSIDE IR35. You will also work in a hybrid way out of their central London office.

Location

London, UK

Rate / Salary

480.00 GBP Daily

Company Information

Trading as TEKsystems. Allegis Group Limited, Maxis 2, Western Road, Bracknell, RG12 1RT, United Kingdom. Allegis Group operates as an Employment Business and Employment Agency. Privacy notices apply for personal data processing as described in the Allegis Group Online Privacy Notice.