Power BI Data Analyst

Market Financial Solutions (MFS) is a leading independent bridging finance provider based in the United Kingdom. With a strong presence in the market, we specialise in offering fast and flexible bridging loans and buy-to-let mortgages to our valued intermediaries and clients. Role Purpose: The purpose of the Market & Data Analyst role is to design, develop and maintain business intelligence solutions using Microsoft Power BI. The ideal candidate will have a strong analytical mindset, proficiency in data visualisation, and experience in handling large datasets. We are looking for an Excel and Power B.I. allrounder to obtain and model data into actionable insights to make real change. In addition, they will work with our main funder analyst team to exchange data, work with third parties to accurately represent our products, and have the drive to develop data warehouses to provide regular MI. Key Responsibilities: * Develop, publish, and schedule interactive Power BI reports and dashboards based on business requirements. * Document processes, models, designs, and solutions, and ensure availability of these documents to all relevant stakeholders * Identify weaknesses, risks, and opportunities, and present data-driven recommendations to management to support business cases. * Work closely with Compliance and Funding teams to ensure we adhere and report on funding line eligibility, loan book attributes, underwriting pipeline, and loan concentrations. * Maintain forecasts vs actuals for a wide variety of metrics and budgetary purposes. * Deliver tasks to aid in the introduction of IT systems to benefit both BTL and Bridging, introducing efficiencies, scale capability, better data, and better customer/broker journeys. * Monitor conversion of enquiries and speed of processing, to uncover actionable insights for improvement. * Analyse competitor products, investor reports, property company data (e.g. house prices), and Bank of England data to provide insights that aid MFS management and decision-making. Role Requirements: * Strong interpersonal and communication, both written and verbal, skills, and the ability to build and maintain relationships. * Knowledge of data modelling, cleansing and analysis techniques. * Ability to produce graphical representations and data visualisations. * Advantageous: Negotiation skills, Financial and accounting analysis, Hubspot CRM, and specialist mortgage market (buy to let and bridging). * Proficiency in Power BI, including DAX (Data Analysis Expressions) and M language is preferred. * Experience with SQL and relational databases (e.g., SQL Server, Oracle). * Strong understanding of data warehousing concepts, ETL processes, and data modelling. Why Work for us? * Annual salary review & regular appraisals * Bonuses and Incentives * Enhanced Maternity and Paternity Leave Package * Private Medical Health Care with Vitality * Life Insurance Coverage * Engaging Work Networking and Team Building Event Next Steps: Ready for an exciting career move? Hit ‘apply’ to express your interest, and if your CV aligns with our requirements, expect a call from one of our team soon to discuss this fantastic opportunity further