Office for Legal Complaints (OLC) / Legal Ombudsman

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 can't 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. 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. 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. Role purpose The BI Developer role exists to maintain and develop our BI solution and automated tools, helping us to produce management information from telephony, finance, HR and other systems. Working with other technical and data specialists to improve our reporting capability, the BI Developer will enable effective distribution of relevant management information appropriately within the organisation and to ensure that changes and developments to reporting solutions are controlled with any changes to the business process clearly documented. 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. Skills & Experience Essential skills A great communicator, able to communicate effectively with all levels of the organisation. Good understanding of best practice in Data Warehouse Implementation Strong critical thinking/problem solving/troubleshooting and decision making with the ability to work to deadlines. Adapt to changes and re-evaluate priorities to meet changing priorities. Advanced ETL, SQL programming and DBA skills. Skills in data mapping and modelling. Organised Desirable skills Ability to present and translate technical data into meaningful insights. Able to accept constructive feedback. Desire to learn new skills and improve knowledge and understanding. Good team player able to work with the team effectively. Work efficiently and to a timely manner. Advanced Excel skills. Essential experience 3-5 years' experience in SQL language and DBA. Knowledge of Kimball methodology and Star Schema modelling in Data Warehousing. Experience of SSIS and SSMS. Good understanding and experience of building ETL processes including extracting data via APIs. Advanced understanding and ability to build and develop PowerBI reports and dashboards to a high standard fulfilling business needs. Preparing and communicating reports and management information Desirable experience Management of Azure PaaS and IaaS instances. Experience of Azure Data Factory. Experience developing ad hoc reporting tools by using extracted data from core business systems. Experience of SSRS Experience of PowerApps and Power automate About us and why we matter People rely on legal services at key times in their lives - whether it's buying a home, dealing with bereavement, having issues at work, ending a marriage, or being involved in legal action. These things really matter - and that's why the Legal Ombudsman really matters. If people can't sort out a problem with a legal provider, we're here to resolve things fairly and as quickly as possible. And as we resolve individual complaints, we share learning and insight into what we've seen - helping prevent the same issues arising again. And we are Family Friendly with enhanced maternity leave and pay, paternity leave, shared parental leave, adoption leave. Money friendly with access to a discount's platform including thousands of discounts for supermarkets, eating out, leisure, holidays, theatre tickets etc Community friendly offering Special Leave - if you're an active member of your community, you can get extra paid leave for public duties, volunteering activities and reserve forces duties. Inclusive of all communities and we encourage applications from the widest possible range of backgrounds and circumstances.