2 of 2 Power Query Jobs in Bedfordshire

pivotal in supporting our sales and service functions by providing accurate, insightful, and visually engaging reports. You will work with data from multiple sources, using advanced Excel skills, Power BI dashboards and Macros to help managers and teams monitor performance and identify opportunities.This is a full-time role where you’ll be at the heart of GEM, ensuring … have the insights they need to make informed decisions. Key Responsibilities Develop and maintain Excel-based reports and dashboards, using advanced functions (PivotTables, VLOOKUP/XLOOKUP, IF statements, Power Query, conditional formatting). Build and automate Power BI dashboards to provide real-time visibility of KPIs and performance trends. Use Macros to streamline and … reporting processes to enhance accuracy, efficiency and impact. Skills, Knowledge and Experience Advanced Excel expertise (PivotTables, formulas, VLOOKUP/XLOOKUP, IF statements, graphs, conditional formatting). Experience with Power BI – developing and maintaining dashboards and reports. Knowledge of Macros Strong analytical skills, with the ability to interpret data and present insights clearly. IT literate with proficiency in Microsoft More ❯

Reporting Analyst, Power BI and Advanced Excel (VBA), Dunstable, c£37,000 per annum We are delighted to be working with an instantly recognisable brand in Dunstable. We’re on the hunt for a Reporting Specialist to join our clients fast-paced contact centre. Supporting over 1,200 offices across the UK. This role is all about delivering … data into action. You’ll create smart, visual reports that help our managers and directors make informed decisions—fast. The Job: Build slick Excel reports and dashboards (PivotTables, Power Query, VLOOKUP/XLOOKUP, IFs). Automate insights with Power BI and Macros. Deliver daily, weekly, and monthly KPIs, league tables, and performance reports. Support … teams with ad-hoc reporting and tailored insights. Continuously improve how we report and what we learn from our data. Your skills: Advanced Excel skills (VBA) Solid Power BI experience Macro knowledge Sharp analytical thinking Organised, proactive, and ready to juggle priorities A flexible, can-do attitude You’ll be at the centre of a high-energy team More ❯