Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Join the EU Fleet Planning team to enhance fleet scheduling through automation and UAT testing.
- Company: Be part of a leading tech company within the Allegis Group network.
- Benefits: Enjoy a hybrid work model and gain experience with a top-tier client.
- Why this job: Make a real impact by optimising fleet operations while developing your skills in a dynamic environment.
- Qualifications: Proficiency in UAT, SQL, and Excel is essential for this role.
- Other info: This is a contract position based in London, UK.
The predicted salary is between 28800 - 48000 £ per year.
Excel Programmer Analyst – 6 Month Contract – INSIDE IR35
Are you ready to apply Make sure you understand all the responsibilities and tasks associated with this role before proceeding.
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
You will be building reports, correcting corrupted data, and fixing complex problems in Excel before putting your findings into models for the company.
You will Have 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 – Please ensure your CV reflects these skills when applying
Understanding of UAT purely so you understand the project you are working on. MS Excel is the essential skill for this role
Critical thinker and able to think for themselves.
Expertise in Microsoft Excel
Knowledge of SQL
Python knowledge
Experience in application support
Strong data analysis skills
Effective communication abilities
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
480.00 – 480.00 GBP Daily
Trading as TEKsystems. Allegis Group Limited, Maxis 2, Western Road, Bracknell, RG12 1RT, United Kingdom. No. (phone number removed). 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. If you apply, your personal data will be processed as described in the Allegis Group Online Privacy Notice available at (url removed)>
To access our Online Privacy Notice, which explains what information we may collect, use, share, and store about you, and describes your rights and choices about this, please go to (url removed)>
We are part of a global network of companies and as a result, the personal data you provide will be shared within Allegis Group and transferred and processed outside the UK, Switzerland and European Economic Area subject to the protections described in the Allegis Group Online Privacy Notice. We store personal data in the UK, EEA, Switzerland and the USA. If you would like to exercise your privacy rights, please visit the \”Contacting Us\” section of our Online Privacy Notice at (url removed)/en-gb/privacy-notices for details on how to contact us. To protect your privacy and security, we may take steps to verify your identity, such as a password and user ID if there is an account associated with your request, or identifying information such as your address or date of birth, before proceeding with your request. If you are resident in the UK, EEA or Switzerland, we will process any access request you make in accordance with our commitments under the UK Data Protection Act, EU-U.S. Privacy Shield or the Swiss-U.S. Privacy Shield
Programmer Analyst employer: TEKsystems
Contact Detail:
TEKsystems Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Programmer Analyst
✨Tip Number 1
Familiarise yourself with User Acceptance Testing (UAT) processes. Understanding how to create and analyse UAT scenarios will be crucial for this role, so consider brushing up on best practices and methodologies.
✨Tip Number 2
Enhance your SQL skills, as they are essential for data manipulation and analysis in this position. Try working on sample projects or datasets to demonstrate your ability to extract insights from real business data.
✨Tip Number 3
Get comfortable with Excel, especially advanced functions and data analysis tools. Being able to efficiently manage and analyse data will set you apart during the interview process.
✨Tip Number 4
Research the company and its fleet planning operations. Understanding their specific challenges and how your skills can contribute to their automation roadmap will help you stand out as a candidate.
We think you need these skills to ace Programmer Analyst
Some tips for your application 🫡
Understand the Role: Make sure you fully understand the responsibilities of a Programmer Analyst, especially in relation to User Acceptance Testing (UAT) and automation. Tailor your application to highlight relevant experiences.
Highlight Relevant Skills: Emphasise your skills in UAT, SQL, and Excel in your CV and cover letter. Provide specific examples of how you've used these skills in previous roles or projects.
Craft a Strong Cover Letter: Write a compelling cover letter that connects your background with the job requirements. Mention your experience in creating and testing UAT scenarios and how it aligns with the company's goals.
Proofread Your Application: Before submitting, carefully proofread your CV and cover letter for any errors. A polished application reflects attention to detail, which is crucial for a Programmer Analyst role.
How to prepare for a job interview at TEKsystems
✨Understand UAT Fundamentals
Make sure you have a solid grasp of User Acceptance Testing (UAT) principles. Be prepared to discuss how you would create, test, and analyse UAT scenarios, especially in relation to the science optimisation model mentioned in the job description.
✨Showcase Your SQL Skills
Since SQL is a key skill for this role, be ready to demonstrate your proficiency. You might be asked to solve a problem or explain how you would use SQL to extract and manipulate data for testing purposes.
✨Excel Proficiency is Key
Highlight your experience with Excel, particularly in data analysis and reporting. Prepare examples of how you've used Excel in previous roles to support UAT or data-driven decision-making.
✨Familiarise Yourself with Fleet Scheduling Operations
Research fleet scheduling operations and understand the challenges involved. Being able to discuss how your skills can streamline these operations will show that you're not just technically capable but also understand the business context.
