Job Description
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.
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 Office (Word, Excel, Outlook).
* Highly organised, proactive, and able to manage multiple priorities.
* Flexible working approach with a strong "can-do" attitude.
Don't meet every single requirement? Studies have shown that women and people of colour are less likely to apply to jobs unless they meet every single qualification. At Connells Group we are dedicated to building a diverse, inclusive and authentic workplace. So, if you're excited about this role but your experience doesn't fit perfectly with every aspect of the job description, we encourage you to apply anyway. You may be just the right candidate for this or other opportunities.
CC00656
Job Reference: CC00656