At a Glance
- Tasks: As a Contracts Analyst, you'll analyze data and streamline processes using Excel and SQL.
- Company: Join a well-respected, growing company with a strong brand in the market.
- Benefits: Enjoy a salary of £30k-£35k, pension, and 25 days holiday plus bank holidays.
- Why this job: Be part of a dynamic team, drive change, and enhance your career with excellent progression opportunities.
- Qualifications: Proficiency in Excel and Macros is essential; experience with SQL is a plus.
- Other info: Work from home one day a week and enjoy socializing with a thriving team.
The predicted salary is between 30000 - 35000 £ per year.
The Job The Company: • Leading supplier within market sector. • Extremely well established and well-respected brand • Growing company, with clearly defined strategies. • Excellent career progression opportunities. • Working in a team environment. Benefits of the Contracts Analyst • Basic salary £30k-£35k • Pension • 25 days holiday + Bank Holidays The Role of the Contracts Analyst • 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. The Ideal Person for the Contracts Analyst • 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. If you think the role of Contracts Analyst is for you, apply now! Consultant: Sarah Dimmock Email: Tel no. 0208 397 4114 Candidates must be eligible to work and live in the UK. About On Target At On Target, we specialise in sales, technical and commercial jobs in the Engineering, Construction, Building Services, Medical & Scientific, and Commercial & Industrial Solutions sectors, enabling our consultants to become experts in their market sector. We place all levels of personnel, up to Director across the UK and internationally. JBRP1_UKTJ
On Target Recruitment | Contracts Analyst employer: On Target Recruitment
Contact Detail:
On Target Recruitment Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land On Target Recruitment | Contracts Analyst
✨Tip Number 1
Familiarize yourself with Microsoft Excel, especially Macros, as this is a key requirement for the Contracts Analyst role. Consider taking online courses or tutorials to enhance your skills and demonstrate your proficiency during the interview.
✨Tip Number 2
Show your enthusiasm for process improvement by preparing examples of how you've successfully automated tasks or improved workflows in previous roles. This will highlight your ability to drive change, which is crucial for this position.
✨Tip Number 3
Brush up on your data interpretation skills. Be ready to discuss how you have collected and analyzed data trends in the past, and think about how you would present these findings to stakeholders at different levels.
✨Tip Number 4
Since teamwork is emphasized in this role, prepare to share experiences where you've collaborated effectively with others. Highlight any mentoring or leadership roles you've taken on to show that you're a great fit for their team-oriented culture.
We think you need these skills to ace On Target Recruitment | Contracts Analyst
Some tips for your application 🫡
Highlight Relevant Skills: Make sure to emphasize your proficiency in Microsoft Excel and Macros in your CV and cover letter. Mention any experience you have with SQL databases and data tools, as these are crucial for the Contracts Analyst role.
Showcase Problem-Solving Abilities: In your application, provide examples of how you've identified and implemented process improvements in previous roles. This will demonstrate your ability to drive change and enhance efficiency, which is a key aspect of the job.
Communicate Clearly: Since the role involves presenting complex data findings to stakeholders, ensure that your application materials reflect your ability to convey technical information concisely. Use clear language and structure your thoughts logically.
Express Team Spirit: Mention your experience working in team environments and your enthusiasm for mentoring others. Highlight any instances where you've contributed to team success or social activities outside of work, as this aligns with the company culture.
How to prepare for a job interview at On Target Recruitment
✨Show Your Excel Skills
Since the role requires proficiency in Microsoft Excel and Macros, be prepared to discuss your experience with these tools. Bring examples of how you've used Excel to automate processes or analyze data effectively.
✨Demonstrate Your Analytical Mindset
The Contracts Analyst position involves interpreting data trends and presenting findings. Be ready to explain how you approach data analysis and provide a specific example where your insights led to actionable changes.
✨Highlight Your Teamwork Experience
As you'll be joining a team of estimators, emphasize your ability to work collaboratively. Share experiences where you mentored others or contributed to a team project, showcasing your interpersonal skills.
✨Prepare for Change Management Questions
The company is looking for someone excited about driving change. Think of instances where you've successfully implemented new processes or technologies, and be ready to discuss how you managed any challenges that arose.