Data AnalystSalary: £25-35k DOELocation: Alcester - Hybrid - 2/3 days in the officeHL Partnership is the largest privately-owned mortgage network in the UK. Our goal is to continue to be the best home for mortgage advisers, protection specialists, equity release experts and general insurance professionals, whatever their size or location.The RoleTo assist the Finance Department in creating, maintaining and enhancing reporting solutionsKey TasksCreating, maintaining, and enhancing reporting solutions that deliver actionable insights to the business Working across departments to develop and maintain data quality and maintain up-to-date recordsThe ideal candidate should have the following experienceAbility to analyse complex data sets, identify trends, and draw meaningful conclusionsProficient MS Excel (Pivot tables, vlookups, nested if statements, etc)Utilising advanced tools to extract data from data sources SQL, Power BIDesign tools (including dynamic dashboards) to assist the business in monitoring business performance and supporting business goalsWorking with large datasets, ensuring reliability, accuracy, and optimisation of data delivery. It includes processes that acquire validate, store, protect, and process required data to ensure the accessibility, reliability, and timeliness of the data for internal users.Benefits:Company pensionHealth and wellbeing programmeSick payOptions to buy/sell holidayThe role will require occasional travel to other offices across the UK. ..... full job details .....