The Vacancy Business Performance Team Leader - Harrogate & Home - ARD937600 We have an exciting opportunity to join our team as a Business Performance Team Leader. This role will be to provide ongoing MI & Reporting support for the UK Commercial MGA division, managing a team of MI analysts, ensuring reporting is kept line with existing strategy and future goals. In return we will make sure you get all the training and development you need to progress with us, and you will be rewarded with all the great benefits of working for a market-leading, fast-growing company. What you will do as a Business Performance Team Leader: Produce reports and analysis summarising the performance of offices, individuals, branches, areas and regions within the UK Commercial MGA division Translating business needs into reporting solutions/rich visuals/apps. Creating ETL solutions to capture data from multiple sources and map/structure into either QVD files or SQL databases depending on the solution required. Optimize SQL server queries to efficiently and quickly retrieve data. Development of key transactional reports using SSRS, both data from the PAS and Data Warehouse. Analyse individual business Data, making recommendations to improve performance for each business. Creating self-service reporting apps through Power BI Qlik Sense & Developing complex Qlik Sense data models. Provide ongoing monthly reporting within a timely manner for exec pack production. Collate, manage and respond to queries from Senior Stakeholders, Power BI and Qlik Sense Licence Holders. Understand and be able to explain the reporting infrastructure used in the production of Power BI, Qlik reporting and be able to apply this knowledge to arrive at the desired outcome. Ability to manage external data sources and escalate issues affecting report delivery. Interpret MI requirements and produce varying reports depending on the target end user. Understands project plans and can clearly articulate roles, project goals, and timelines. Takes input from supervisor and it able to appropriately apply comments/feedback. Responsibility for leading a team of MI Analysts Delivery of BAU and project activity from a business performance/MI perspective What we are looking for in a Business Performance Team Leader: Power BI Experience Qlik Sense Experience at a development level (QMC Knowledge) Experience using the Microsoft BI Stack (SSRS, SSIS, Visual Studio) Advanced Excel and Reporting Capabilities with a high level of accuracy Knowledge of the general insurance market and general insurance products Experience with MI Reporting and data analysis In return you will be welcomed and supported by the Ardonagh family, with opportunities to learn and grow your career. You will also be joining an organisation that cares about you as a person and your wellbeing. Some notable benefits include: Holiday entitlement of 26 days plus bank holidays. Opportunity to progress your career across the entire Ardonagh family. Gain CII or ACII qualifications to boost your knowledge and career prospects. Pensions scheme for when you feel it's time to retire. 24-hour support for physical and mental wellbeing. 1 days paid volunteering day to give back to our communities. The Spotlight Awards, where we shine a light on the brightest talent across our group. So, what are you waiting for? Apply today and come and be a key part of a market-leading, fast-growing company. If your application is successful, we will conduct relevant employment checks prior to you commencing employment with us. These will include verifying your recent employment, address, credit history and a standard criminal record check. Please note: We may close a vacancy prior to the publish end date if the required quality or number of applications has been received. No agencies please. LI-HC1 GEO The Company Geo Underwriting is one of the UK's largest, full service managing general agent's (MGA) encompassing Commercial Lines, Personal Lines, Agriculture and our London Market business, Geo Specialty. With 11 regional offices, we offer a wide underwriting footprint, diverse product range and A-rated capacity. GEO