Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Analyze contracts, automate processes, and present data insights to stakeholders.
- Company: Join a dynamic team focused on improving customer claims accuracy and efficiency.
- Benefits: Work from home one day a week and enjoy a collaborative team culture.
- Why this job: Drive change, enhance your Excel skills, and mentor others in a supportive environment.
- Qualifications: Proficient in Excel and Macros; experience with SQL and data tools preferred.
- Other info: Regular social events with the team to build connections outside of work.
The predicted salary is between 36000 - 60000 £ per year.
-
As the Contracts Analyst you’ll initially have a fair amount of manual work using Microsoft Excel, and you’ll look at processes to reduce this e.g Macros, PowerBI, PowerQuery etc.
-
Develop, maintain and enhance an existing pricing system on Excel with a reliance on macro programming.
-
You’ll facilitate and guide the transition from Microsoft Excel to a new SQL database system in 2025.
-
A key part of the role as Contracts Analyst is to collect and interpret data trends from customer claim back information.
-
You’ll present these findings in a concise manner to stakeholder of all levels.
-
Joining a team of 4 estimators, you’ll help and mentor the wider team to ensure customer claims are accurate, consistent and reliable.
-
Perform regular date profiling and quality checks.
-
Identify and act upon opportunities to automate existing manual processes.
-
Working hours: Monday to Friday 8:30am-5pm and Friday 8:30am- 4:30pm. Can work from home one day a week.
-
Must be proficient in using Microsoft Excel and Macros.
-
Confidence to review current procedures and suggest new ideas
-
Excited by the opportunity to enact and drive change.
-
Attention to detail, high standards of accuracy and the ability to easily convey complex and technical information in a concise manner.
-
Experience with database systems and other data tools, ideally SQL, in a medium to large size business.
-
Will want to join a thriving team who socialise outside of work.
Consultant: Sarah Dimmock
Contracts Analyst employer: on target talent
Contact Detail:
on target talent Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Contracts Analyst
✨Tip Number 1
Brush up on your Excel skills, especially in Macros and PowerQuery. Since the role involves a lot of manual work initially, demonstrating your proficiency in these areas will show that you're ready to hit the ground running.
✨Tip Number 2
Familiarize yourself with SQL databases. Since you'll be facilitating the transition to a new SQL system, having a basic understanding of how SQL works will make you stand out as a candidate who is prepared for future changes.
✨Tip Number 3
Prepare to discuss your experience with data analysis and how you've used it to drive change in previous roles. Being able to convey complex data trends in a simple manner is crucial, so think of examples where you've done this successfully.
✨Tip Number 4
Show your enthusiasm for teamwork and mentoring. Since you'll be joining a small team, expressing your excitement about collaborating and helping others will resonate well with the hiring team.
We think you need these skills to ace Contracts Analyst
Some tips for your application 🫡
Highlight Relevant Skills: Make sure to emphasize your proficiency in Microsoft Excel, especially with Macros. Mention any experience you have with PowerBI, PowerQuery, or SQL databases, as these are crucial for the role.
Showcase Problem-Solving Abilities: In your application, provide examples of how you've identified and automated manual processes in previous roles. This will demonstrate your ability to drive change and improve efficiency.
Communicate Clearly: Since the role involves presenting findings to stakeholders, ensure that your application is clear and concise. Use straightforward language to convey complex ideas, reflecting the communication skills required for the position.
Express Team Spirit: Mention your enthusiasm for working in a team environment and your willingness to mentor others. Highlight any past experiences where you contributed to team success or social activities outside of work.
How to prepare for a job interview at on target talent
✨Showcase Your Excel Skills
Since the role heavily relies on Microsoft Excel and Macros, be prepared to discuss your experience with these tools. Highlight specific projects where you've used Excel to automate processes or analyze data.
✨Demonstrate Data Interpretation Abilities
The ability to collect and interpret data trends is crucial. Prepare examples of how you've analyzed data in the past and how you presented your findings to stakeholders. This will show your capability to convey complex information clearly.
✨Discuss Automation Experience
Talk about any previous experiences where you've identified opportunities to automate manual processes. Share specific examples of how you implemented changes and the impact it had on efficiency.
✨Emphasize Team Collaboration
As you'll be joining a team of estimators, it's important to highlight your teamwork skills. Discuss how you've mentored others or contributed to a team environment in previous roles, especially in relation to ensuring accuracy and consistency in work.