At a Glance
- Tasks: Develop and optimise Excel workbooks, dashboards, and automated reporting solutions.
- Company: Dynamic company in Uxbridge focused on data-driven decision-making.
- Benefits: Competitive salary, excellent healthcare, 33 holiday days, and enhanced parental leave.
- Other info: Fully office-based role with opportunities for professional growth.
- Why this job: Join a fast-paced environment and make an impact with your analytical skills.
- Qualifications: Expert in Excel, Power BI, and automation tools; strong analytical skills required.
The predicted salary is between 36000 - 60000 € per year.
Location: Uxbridge
Purpose of the Role
We are seeking a highly skilled Excel Expert with advanced experience in Power BI, Power Pivot, and automation tools. The ideal candidate will be responsible for developing robust data models, building automated workflows, and delivering insightful reporting solutions that support business decision-making.
Key Responsibilities
- Develop, maintain, and optimize complex Excel workbooks, dashboards, and data models.
- Design and implement automated processes using VBA, macros, and other scripting tools.
- Build interactive and visually compelling Power BI dashboards and reports.
- Use Power Pivot to create data models, manage relationships, and write DAX calculations.
- Collaborate with stakeholders to gather reporting requirements and translate them into actionable solutions.
- Clean, transform, and analyse large datasets from various sources.
- Ensure data accuracy, integrity, and consistency across reports and tools.
- Troubleshoot existing Excel, BI, or automation solutions and recommend improvements.
- Document processes, workflows, and technical specifications.
Skills & Experience Required
- Expert-level proficiency in Microsoft Excel, including formulas, pivot tables, advanced data manipulation, and statistical functions.
- Strong experience designing and deploying Power BI dashboards (including DAX).
- Proficiency with Power Pivot and data modelling concepts.
- Proven ability to develop and maintain VBA scripts and complex automation macros.
- Ability to work with large datasets and connect to external data sources.
- Strong analytical and problem-solving skills.
- Excellent attention to detail and commitment to data accuracy.
- Ability to communicate technical concepts to non-technical stakeholders.
- Comfortable working in a fast-paced environment with high levels of complexity and variability.
Why Join Us?
- Very competitive salary
- Excellent healthcare benefits, including access to a 24/7 GP service and physio sessions.
- 33 holiday days each year (25 days flexible booking with 8 bank holidays).
- Additionally we offer a holiday purchase scheme
- Free will writing service
- Enhanced maternity and paternity leave
Please note: This role is fully office-based with no hybrid or remote working options.
Performance and Analytics Analyst in Uxbridge employer: Pilgrim's Europe
Join our dynamic team in Uxbridge as a Performance and Analytics Analyst, where you will thrive in a supportive work culture that values innovation and collaboration. We offer a competitive salary, comprehensive healthcare benefits, and generous holiday allowances, ensuring a healthy work-life balance while providing ample opportunities for professional growth and development. Experience the unique advantage of working in a fully office-based environment that fosters teamwork and engagement among colleagues.
StudySmarter Expert Advice🤫
We think this is how you could land Performance and Analytics Analyst in Uxbridge
✨Tip Number 1
Network like a pro! Reach out to people in your industry on LinkedIn or at local meetups. We all know that sometimes it’s not just what you know, but who you know that can help you land that Performance and Analytics Analyst role.
✨Tip Number 2
Prepare for those interviews by brushing up on your Excel and Power BI skills. We recommend creating a portfolio of your best work to showcase your expertise. It’s a great way to demonstrate your capabilities and stand out from the crowd!
✨Tip Number 3
Don’t forget to tailor your approach! When you apply through our website, make sure to highlight your experience with VBA, macros, and data modelling. We want to see how you can bring value to our team with your unique skills.
✨Tip Number 4
Follow up after your interviews! A quick thank-you email can go a long way. We appreciate candidates who show enthusiasm and professionalism, so let us know you’re keen on joining our team as a Performance and Analytics Analyst!
We think you need these skills to ace Performance and Analytics Analyst in Uxbridge
Some tips for your application 🫡
Show Off Your Excel Skills:Make sure to highlight your expert-level proficiency in Excel. We want to see your experience with formulas, pivot tables, and advanced data manipulation. Don’t hold back on showcasing any complex workbooks or dashboards you've created!
Power BI is Key:Since we're looking for someone who can design and deploy Power BI dashboards, include specific examples of your work with Power BI. Tell us about the DAX calculations you've written and how you've used Power Pivot to manage data models.
Automation is Your Friend:We love a good automation story! Share your experience with VBA scripts and macros. If you've developed automated processes that improved efficiency, let us know how you did it and the impact it had.
Tailor Your Application:Take a moment to tailor your application to our job description. Use the same language and keywords we’ve included. This shows us you understand what we’re looking for and helps your application stand out. And remember, apply through our website!
How to prepare for a job interview at Pilgrim's Europe
✨Master Your Excel Skills
Before the interview, brush up on your Excel skills, especially advanced functions, pivot tables, and data manipulation techniques. Be ready to discuss specific examples of how you've used these skills in past roles, as this will show your expertise and confidence.
✨Show Off Your Power BI Knowledge
Prepare to talk about your experience with Power BI, including any dashboards you've created. Bring along examples or screenshots if possible, as visual aids can help illustrate your capabilities and make a lasting impression.
✨Demonstrate Your Problem-Solving Skills
Think of a few challenging scenarios you've faced in data analysis or automation and how you resolved them. This will highlight your analytical skills and ability to troubleshoot, which are crucial for the Performance and Analytics Analyst role.
✨Communicate Clearly with Non-Technical Stakeholders
Practice explaining complex technical concepts in simple terms. During the interview, you may need to demonstrate your ability to collaborate with stakeholders who might not have a technical background, so showcasing this skill will be key.
