Looking for your next BI role where you can turn complex data into clear insight, smarter reporting, and real business impact?
We welcome applications from experienced candidates and offer a starting salary from £46k+, depending on experience.
At BW Legal, data helps drive better decisions, stronger client outcomes and smarter ways of working. Were looking for a Senior BI Developer to join our Business Intelligence team and build scalable BI solutions that improve reporting, strengthen data accuracy and add real value across the business.
Youll bring strong automation capability, excellent SQL and ETL expertise, and a genuine passion for data and continuous improvement. Youll work on project-led development across data warehousing, extraction and transformation, partnering with stakeholders to deliver solutions that support business priorities and client needs.
From day one, youll make an impact by building automated data solutions, turning requirements into robust MI and reporting, and helping shape how BI is used across the organisation. If you enjoy ownership, collaboration and using data to drive better outcomes, this is a role where you can really grow.
What you'll be doing:
Working as part of the BI team, you will:
- Design, develop and enhance data warehousing solutions that support changing business needs.
- Build, maintain and optimise automated ETL processes.
- Work 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 to 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.
- Take ownership of your conduct and behaviours, aligned to the BW Way and wider business objectives.
What we're looking for:
Were looking for someone with strong automation capability, a collaborative mindset and a genuine enthusiasm for data and continuous improvement.
Essential:
- Strong commercial experience using Microsoft SQL Server Management Studio, typically around 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.
- Able 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.
Youll work across the full BI lifecycle, from requirements and build through to delivery, enhancement, and continuous improvement.
If youre curious, analytical and motivated by improving processes and influencing decisions, youll fit right in.
Working hours and salary:
Your working week will be 7 hours per day, Monday to Friday. 8.30 4pm but we can be flexible on agreed start time, and there may be times when additional hours are needed to support the team and meet business needs. Any extra hours worked would be paid as overtime.
Starting salary from £46,000+ depending on experience. We welcome more experienced candidates to apply. You will also benefit from annual salary reviews which recognise and reward your success.
What we can offer you:
We offer more than just a job. As a Gold-accredited Investors in People employer and a Platinum-accredited Investors in Wellbeing organisation, weve built a culture where people feel supported, valued and able to grow.
Youll benefit from ongoing, industry-leading training delivered by our in-house Learning and Development team, covering both technical and professional skills throughout your BW Legal career. That includes continued professional development, mentoring and study support.
Reward and recognition.
At BW Legal, we know people do their best work when they feel supported, recognised and able to thrive both professionally and personally.
Our Balance Within wellbeing strategy takes a holistic approach to support your health, development and lifestyle. In your first year alone, our benefits package is worth over £10,000, including all benefits costings.
Benefits include: - 35-hour working week
- Free off-site parking, saving up to £9 a day compared with local car parks
- 27 days annual leave, plus bank holidays
- Additional paid leave on your birthday, Christmas Eve and New Years Eve when they fall on a weekday
- Flexible holiday policy with the option to use, buy and sell leave within policy limits, including hourly flexibility for part of your allowance
- Extra holiday for length of service, with one additional day after your second, third and fourth year
- Enhanced maternity, paternity and adoption pay
- Business-casual dress code
Financial wellbeing
Be Here Living Our Values: a monthly and quarterly tax and NI free bonus based on attendance and punctuality, worth up to £828 in your first year, rising to a maximum of £4,194 by your sixth year of employment
Death in service cover: Financial protection worth six times your annual salary
Income protection: receive 75% of your salary for up to two years if you're unable to work (subject to eligibility criteria)
Discounted shopping: access discounts and savings at thousands of UK retailers with My Staff Shop (with the average user saving over £1,000 per year!)
Travel support: Free parking, bus discounts with First and Arriva, and secure cycle storage facilities.
Money4U with Leeds Credit Union: access to preferential savings and loans rates
Contributory pension scheme
British Gas discount: Access to an exclusive money-saving energy tariff for your gas and electricity
Discounted legal services: 10% off personal legal services with Chadwick Lawrence Solicitors, including conveyancing, family law and will writing
Learning and development
Learn and Earn: top up your income with up to £720 per year by investing in your personal and professional development outside of working hours
Learning and Development allowance: paid time to learn during working hours
Professional qualifications: financial and study support, from apprenticeships to specialist degree-level courses
Health and wellbeing
Free gym membership with our local partner, or discounted membership at over 3,600 gyms nationwide
On Site GP: access to a specialist prescribing GP who comes on-site fortnightly
Virtual GP: access to virtual 24/7 prescribing GP for you and your family
On-Site Physiotherapist: Support for aches, pains and injury prevention, whether you need treatment or proactive care, available at a 10% discount to our colleagues
Health cash back plan: Claim back up to £3,700 on dental, optical, physiotherapy, prescriptions and wellbeing treatments.
Discounted dentistry: Reduced rates on dental plans and 10% off treatments with Leeds Dental Clinic
Employee assistance: 24/7 helpline, including up to 8 free counselling
Wellbeing supported by colleague ambassadors: dedicated champions for wellbeing, learning and development, and menopause, who listen, gather feedback, and guide colleagues to the right support and resources.
Early intervention: support for colleagues who are experiencing health issues to support them staying in or returning to work
Culture and community
Colleague events: From darts and bowling to quizzes and parties, there are plenty of opportunities to connect and unwind together.
Regular charity fundraising for local causes through games, raffles and more
If you want a role where your expertise will be valued and your work will make a real impact, wed love to hear from you.
As a proud Disability Confident employer, we are committed to equal opportunities for all. If you require any reasonable adjustments during the recruitment process, please let us know at [email protected].
