Business Intelligence Developer in Birmingham

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.

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.

Are you a BI Developer looking for an opportunity to design, develop, and enhance enterprise BI solutions, working with data from telephony, finance, HR, and other core systems to deliver meaningful management information? Do you thrive in a data-driven environment where you can identify opportunities to improve data warehousing, ETL processes, and reporting capabilities, while supporting organisational growth and change? Do you have strong technical and communication skills, enabling you to collaborate with technical specialists and business users alike, ensure data quality, and deliver accurate, trusted insights that support decision-making?

What you will be doing:

• Maintaining and enhancing the organisations BI solutions and automated tools to deliver accurate and meaningful management information from telephony, finance, HR, and other key systems.
• Working collaboratively with technical and data specialists, including Performance Analysts, BI Developers, CRM and SharePoint teams, to improve reporting capability across the organisation.
• Acting as an authoritative voice in identifying opportunities to improve how data is sourced, structured, and stored within the data warehouse.
• Designing, developing, and supporting robust processes to produce and deliver reliable, accurate, and agreed management information.
• Gathering and assessing reporting requirements, designing solutions, documenting data models, and delivering ETL solutions using SSIS and Azure Data Factory.
• Enhancing and modifying existing ETL models to support changes in business processes and emerging organisational needs.
• Maintaining and further developing the data warehouse to meet evolving management information requirements.
• Identifying opportunities to empower business users with enhanced self-service query and reporting capabilities.
• Ensuring changes to reporting solutions are controlled and clearly documented in line with business process changes.
• Supporting data quality across the organisation by working with users to identify, investigate, and resolve data capture issues.

About you:

• Proven experience working as a BI Developer or in a similar data-focused role, supporting the delivery of accurate, reliable management information.
• You have strong experience using SQL and designing, developing, and supporting ETL solutions, particularly with SSIS and Azure Data Factory.
• You have hands-on experience of data warehousing, ideally using the Kimball methodology, and understand best practices for data modelling and storage.
• You are confident identifying opportunities to improve how data is sourced, structured, and stored within a data warehouse.
• You have experience working with data from multiple systems, such as telephony, finance, HR, case management, or CRM platforms.
• You are comfortable gathering and analysing reporting requirements, translating business needs into well-designed technical solutions.
• You have experience developing, maintaining, and enhancing data warehouses to support changing business and management information needs.
• You can design and support robust routines that deliver consistent, accurate, and trusted management information.
• You understand the importance of data quality and have experience working with users to identify, investigate, and resolve data capture issues.

And we are:

• Family Friendly with enhanced maternity leave and pay, paternity leave, shared parental leave, adoption leave.
• Money friendly with access to a discounts 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.
• A disability Confident employer, welcoming applications from disabled people. We operate the offer an interview scheme for all disabled applicants who meet the essential criteria.

If you are successful, it's key to know all offers of employment are subject to satisfactory completion of our pre-employment checks which include:

• Right to work check, (applicants must be eligible to live and work in the UK).
• Employment History references.
• DBS criminal record check.
• Fit for work questionnaire (for all) followed by a medical check (if applicable).
• Qualifications and/or professional membership check (if applicable).