My job Job Title: Performance and Analytics Analyst 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. The company Pilgrim's Europe produces some of the best-known and most iconic brands in the UK and Ireland, including Fridge Raiders, Rollover, Denny, Richmond, Oakhouse and Moy Park, alongside a diverse range of industry leading own-label products in categories including fresh pork, lamb and chicken, working with all the major retailers and food service outlets. Our portfolio extends to authentic chilled and frozen ready meals, snacking ranges, added value and food service products. Across Pilgrim's Europe we combine 20,000 of the best people in the industry, united by a shared set of core values and a passion for producing the highest quality, most delicious and innovative food, which is enjoyed by millions of people in the UK, Ireland and Europe every day. Our Pilgrim's Europe team are based in our Pilgrim's UK, Moy Park, Pilgrim's Food Masters and Pilgrim's Shared Services businesses. What we'll bring to the table Competitive Salary Competitive Holiday Entitlement Pension Contribution Family Friendly Policies Learning and Development Opportunities Life Assurance People matter Previous Next Our values Determination Simplicity Availability Humility Discipline Sincerity Ownership