Our Benefits Our total reward package includes a basic salary and a potential to earn rewards for excellent contribution to LeO. Stakeholder pension scheme, whereby LeO will double your contribution up to 10%. Annual Leave of 26 days per year (plus bank holidays) (pro rata for part time staff), plus you can buy or sell 4 days leave each year. Flexible hours driven by work life balance and operated between 7am and 9pm each day, this also includes hybrid working of 80% at home and 20% in the office each week. Group Income Protection if you cant work due to long term absence or injury, this protection can provide a regular income. Life assurance of 6 times your annual salary Legal Information Service offering free advice and support with debt management, tax related matters, consumer disputes. Season ticket loans interest free loans for travel between your home and the office. Employee Assistance programmes Online health, fitness, and wellbeing resources Wellbeing champions Investment in your career development through learning and development, talent management, coaching, mentoring and on the job experience. About the Role The Legal Ombudsman have a Business Intelligence (BI) service for the organisation to help us make better use of new case management tools, support data analysis, and transition remaining legacy systems. A flexible role offering hybrid working, the BI developer plays a key role in producing management information, collating data from a variety of sources to help the Legal Ombudsman make data driven decisions. You will build and test end to end reporting solutions for analysis by both internal and external stakeholders. Primarily a technical role working with the BI team, the BI developer will also collaborate with stakeholders, data and technology specialists and management, good communication skills are as essential. Who are we looking for? As a BI Developer, you will play a crucial role in maintaining and enhancing our BI solutions and automated tools. You will work with telephony, finance, HR, and other systems to generate valuable management information. Collaborating with a diverse team of technical and data specialists, you will improve reporting capabilities and ensure thorough documentation of any changes to reporting solutions. Your role will be vital in developing and delivering accurate, reliable, and effective management information to support the organisations needs. Do you have experience with SSIS and SQL? Are you familiar with data warehousing using the Kimball methodology? Can you ensure that best practices are followed to maintain the highest standards in developing our BI solutions? If you have experience identifying opportunities for improving data storage and sourcing within a data warehouse, and hands-on experience designing ETL solutions using SSIS and Azure Data Factory, we want to hear from you. You will also have the opportunity to shape the future of reporting capabilities within the organisation, empowering business users with enhanced query and reporting tools while ensuring data quality standards are met. Key Responsibilities: You will be an authoritative voice identifying opportunities for improving the way data is sourced and stored in the data warehouse. Work closely with the Performance Analysts, lead BI Developer, CRM and SharePoint specialists to ensure that new and changed reporting requirements are properly captured prior to analysis and development. Lead in the design and support of robust routines for the production and delivery of reliable, accurate, agreed Management Information from key systems (case management, telephony, finance and HR) Assess requirements, design solutions, document models, and deliver ETL solutions using SSIS and Azure Data Factory. Develop and modify existing ETL models to support changes to the business process or emerging business needs. Maintain and develop further the data warehouse in line with changing business MI needs. Identify and articulate opportunities to put further query and reporting capabilities in the hands of business users. Support data quality across LeO by working with users to identify and rectify data capture errors. About us and why we matter: People rely on legal services at key times in their lives whether its buying a home, dealing with bereavement, having issues at work, ending a marriage, or being involved in legal action. These things really matter and thats why the Legal Ombudsman really matters. If people cant sort out a problem with a legal provider, were here to resolve things fairly and as quickly as possible. And as we resolve individual complaints, we share learning and insight into what weve seen helping prevent the same issues arising again.