Job Overview
At BW Legal, data drives better decisions and smarter ways of working. We are looking for a Senior BI Developer to build scalable BI solutions that improve reporting, strengthen data accuracy and add real value across the business. This role requires strong automation capability, excellent SQL and ETL expertise, and a genuine passion for data and continuous improvement.
What You’ll Be Doing
- Design, develop, and enhance data warehousing solutions that support changing business needs.
- Build, maintain and optimise automated ETL processes.
- Collaborate with the BI team on strategic projects and development initiatives.
- Respond to changing priorities and deliver solutions that support business and client requirements.
- Gather and translate stakeholder requirements into meaningful MI and reporting solutions.
- Handle ad‑hoc data requests accurately and within agreed timescales.
- Analyse and optimise SQL queries and data processes to improve performance.
- Maintain and enhance MI reporting for internal and external stakeholders.
- Create reports, dashboards and automated outputs using BI and reporting tools.
- Champion data quality, automation and best practice to improve scalability and reduce manual effort.
- Support wider team and business goals, including during peak delivery periods and key deadlines.
- Build strong stakeholder relationships to encourage effective use of MI and BI across the organisation.
What We’re Looking For
Essential
- Strong commercial experience using Microsoft SQL Server Management Studio (typically five years or more).
- Strong T‑SQL skills, including query development, troubleshooting and performance optimisation.
- Exceptional understanding of ETL, automated data processing and workflow orchestration.
- Experience delivering data warehousing solutions, including extraction, transformation and integration.
- Ability to take projects from requirements through to build, testing and delivery as part of a wider team.
Desirable
- A degree in a relevant subject such as Maths, Physics, Computer Science or a related scientific discipline.
- Experience using Python or similar tools to support data automation and development.
- Working knowledge of data warehouse design and implementation.
- Experience with Power BI or similar tools for reporting, dashboards and self‑service insight.
How We Work
Our BI team is collaborative, ambitious and focused on building data solutions that make a measurable difference. You’ll work across the full BI lifecycle, from requirements and build through to delivery, enhancement and continuous improvement.
Working Hours and Salary
Your working week will be 35 hours (7 hours per day, Monday to Friday, 8:30‑4:00 pm). The role offers a starting salary of £46,000 + depending on experience, with annual reviews and performance‑based increases. Overtime is paid for any additional hours required.
Benefits
- 35‑hour working week
- Free off‑site parking
- 27 days annual leave plus bank holidays (plus extra paid leave on birthday, Christmas Eve and New Year’s Eve when they fall on a weekday)
- Flexible holiday policy – buy/sell leave, hourly flexibility for part of the allowance
- Extra holiday for length of service – one additional day after years two, three and four
- Enhanced maternity, paternity and adoption pay
- Business‑casual dress code
- Financial wellbeing package – tax and NI free bonus, death in service cover, income protection
- Discounted shopping and travel (parking, bus, cycle storage) and financial services (Leeds Credit Union, Money4U)
- Contributory pension scheme
Learning and Development
- Industry‑leading training delivered by our in‑house Learning and Development team
- Mentoring, study support and professional qualifications sponsorship
- Learn and Earn – up to £720 per year for external learning
- Paid time to learn during working hours
Health and Wellbeing
- Free gym membership or discount on over 3,600 gyms nationwide
- On‑site GP and virtual GP services
- On‑site physiotherapist (10% discount)
- Health cashback plan — up to £3,700 on dental, optical, physiotherapy and prescriptions
- Discounted dentistry and reduced dental plans
- Employee assistance programme (24/7 helpline, up to 8 free counselling sessions)
- Wellbeing ambassadors and early intervention support
Culture and Community
- Colleague events – darts, bowling, quizzes, parties, etc.
- Regular charity fundraising activities
Equal Opportunities
We are a proud Disability Confident employer and commit to equal opportunities for all. If you require any reasonable adjustments during the recruitment process, please let us know at recruitment@bwwomenlegal.co.uk.
#J-18808-Ljbffr…