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 who are responsible for our client's fleet allocation plans, they also ensure that their Delivery Stations and Delivery Service Partners have the right number of vehicles to complete the last mile delivery routes. This team works closely with multiple stakeholders for ingesting required data signals to create an allocation plan on a weekly level. This team is also in the process of building automation tools and science models to automate and streamline their fleet allocation plans and end-to-end fleet scheduling operations. This automation focuses heavily on User Acceptance Testing. You will need to have an understanding of UAT so you understand the project you are working on, but the key skill our client needs is an advanced level of MS Excel
Responsibilities
1. You will be building reports, correcting corrupted data, and fixing complex problems in Excel before putting your findings into models for the company.
2. You will Have expert knowledge in Excel
3. Create, test, and analyse User Acceptance Test (UAT) scenarios to enable the completion of the science optimisation model development.
4. Develop, test, and evaluate UAT scenarios using real business data to test the science optimisation model.
5. Implement, test, and assess UAT scenarios to operationalise the science optimisation model within the scheduling tools.
Essential Skills - Please ensure your CV reflects these skills when applying
6. Understanding of UAT purely so you understand the project you are working on. MS Excel is the essential skill for this role
7. Critical thinker and able to think for themselves.
8. Expertise in Microsoft Excel
9. Knowledge of SQL
10. Python knowledge
11. Experience in application support
12. Strong data analysis skills
13. Effective communication abilities
14. Proficiency in automation processes.
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
- GBP Daily
Trading as TEKsystems. Allegis Group Limited, Maxis 2, Western Road, Bracknell, RG12 1RT, United Kingdom. No. 2876353. Allegis Group Limited operates as an Employment Business and Employment Agency as set out in the Conduct of Employment Agencies and Employment Businesses Regulations 2003. TEKsystems is a company within the Allegis Group network of companies (collectively referred to as "Allegis Group"). Aerotek, Aston Carter, EASi, Talentis Solutions, TEKsystems, Stamford Consultants and The Stamford Group are Allegis Group brands.