Overview
We are hiring a Reporting Specialist to join our busy contact centre in Dunstable, known as GEM. GEM stands for Generating Extra Market appraisals. We are a centralised sales centre with market leading technology where we provide support for our 1200+ offices that are based all over England, Scotland and Wales. Our main focus at GEM is to provide exceptional customer service whilst booking a high volume of valuations & mortgage appointments for our branches. This role is 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 our Directors and managers 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 automate repetitive reporting tasks.
* Produce league tables, performance reports and KPIs on a daily, weekly and monthly basis.
* Generate ad-hoc reports to support our Sales, Lettings and Customer Service teams.
* Collaborate with managers across departments to understand reporting requirements and provide tailored insights.
* Continuously improve reporting processes to enhance accuracy, efficiency and impact.
* 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 Office (Word, Excel, Outlook).
* Highly organised, proactive, and able to manage multiple priorities.
* Flexible working approach with a strong "can-do" attitude.
Qualifications
* Proven experience in reporting and data analysis, Excel (PivotTables, formulas, VLOOKUP/XLOOKUP), Power BI, and Macros.
* Strong analytical ability and attention to detail.
* Effective communication and collaboration across departments.
#J-18808-Ljbffr