At a Glance
- Tasks: Analyse sales data, identify trends, and present findings to clients.
- Company: Join a respected company with 35 years of experience in outsourced admin services.
- Benefits: Enjoy hybrid working, a competitive salary, and 30 days holiday plus perks.
- Why this job: Be part of a small team making impactful decisions for global brands.
- Qualifications: Advanced Excel skills and confidence in presenting to stakeholders required.
- Other info: Own transport needed due to office location; remote work two days a week.
JOB LOCATION: Basildon, Essex
JOB TYPE: Permanent
JOB SALARY: £27000 - £35000 depending on experience, industry background and Excel skills
JOB WORKING: Hybrid working - in the office 3 days per week, work from home 2 days per week
JOB NOTES: You must have your own transport as our client's site is quite a long walk from the train station and the nearest bus stop. You MUST be an advanced user of Excel (pivot tables, macros etc) and you will be tested as part of your selection and interview process. Our client uses Microsoft 365.
Your new company: Our client was established 35 years ago and works with globally respected companies. They have fantastic feedback from employees on sites like Glassdoor as a great place to work, and they provide outsourced admin services to their clients. This is a unique opportunity to join a great company in a small team where you'll work independently and in a very commercial, dynamic position.
Your new role: Your job will be to look at sales across the country, comparing and finding trends. Then you will present these trends to the clients, explaining how you found this data and why it is important. You will work on Excel all day, every day, so you'll need to be confident in using pivot tables, V lookups and count if statements. The data will need to be exact, and you'll explain, educate and defend your findings when you present them to your stakeholders, who could be senior management and directors, so you'll need to be a confident communicator and presenter. You will be based in the client's offices and there is no public transport to this office, so you will need your own vehicle to get to work.
What you'll need to succeed:
- Advanced Excel knowledge
- Brilliant time management skills
- PowerPoint skills
- Confidence when presenting to important stakeholders
- Able to work independently
- Attention to detail (make sure you don't have any spelling mistakes on your CV!)
What you'll get in return: This is a really fascinating job that provides the hard data for a global brand to make decisions on their production and sales strategies - how exciting is that?! You'll work in a small team so you won't feel like you're a tiny cog in a massive machine and, in return for your skills, you'll get a good salary, a company pension, travel insurance, life insurance, free eye tests, critical illness cover and 30 days holiday each year (including bank holidays).
If you're interested in this role, click 'apply now' to forward an up-to-date copy of your CV and we'll come back to you as quickly as we can.
Sales Data Analyst - Excel Expert employer: CV-Library
Contact Detail:
CV-Library Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Sales Data Analyst - Excel Expert
✨Tip Number 1
Brush up on your Excel skills, especially pivot tables and macros. Since you'll be tested on these during the selection process, consider taking an online course or watching tutorial videos to ensure you're fully prepared.
✨Tip Number 2
Familiarise yourself with Microsoft 365, as this is the platform used by the client. Understanding its features and functionalities will give you an edge in demonstrating your capability during the interview.
✨Tip Number 3
Practice your presentation skills, as you'll need to confidently present your findings to senior management. Consider rehearsing with friends or family to get comfortable explaining complex data in a clear and engaging way.
✨Tip Number 4
Plan your commute ahead of time since you'll need your own transport. Make sure you know the best routes to the office to avoid any delays, as punctuality will reflect your time management skills.
We think you need these skills to ace Sales Data Analyst - Excel Expert
Some tips for your application 🫡
Highlight Excel Skills: Make sure to emphasise your advanced Excel skills in your CV and cover letter. Mention specific functions you are proficient in, such as pivot tables, VLOOKUPs, and macros, as these are crucial for the role.
Tailor Your CV: Customise your CV to reflect the job description. Focus on relevant experience that showcases your ability to analyse data and present findings effectively, especially in a sales context.
Craft a Strong Cover Letter: Write a compelling cover letter that explains why you are a great fit for the role. Include examples of how you've used your Excel skills to drive results in previous positions and your confidence in presenting to stakeholders.
Proofread Your Application: Before submitting, carefully proofread your CV and cover letter to eliminate any spelling or grammatical errors. Attention to detail is key, especially since the role requires precision in data analysis.
How to prepare for a job interview at CV-Library
✨Show Off Your Excel Skills
Since this role requires advanced Excel knowledge, be prepared to demonstrate your skills during the interview. Brush up on pivot tables, VLOOKUPs, and macros, as you may be tested on these. Practising common scenarios can help you feel more confident.
✨Prepare for Data Presentation
You'll need to present data trends to stakeholders, so practice explaining your findings clearly and confidently. Use PowerPoint or other visual aids to enhance your presentation skills, making sure you can articulate why the data is important.
✨Know the Company and Its Clients
Research the company and its clients before the interview. Understanding their business model and the industries they serve will help you tailor your responses and show that you're genuinely interested in the role.
✨Demonstrate Time Management Skills
This position requires excellent time management. Be ready to discuss how you prioritise tasks and manage deadlines, especially when working independently. Providing examples from past experiences can illustrate your ability to handle multiple responsibilities effectively.