BI Analyst

Blue Light Card; Greater London; Hybrid; GBP 48,000 - 60,000; Full time

Benefits offered by this job

Bonus scheme

Private medical

Pension scheme

Hybrid working

EV charging

On-site gym

Birthday day off

Job summary

Blue Light Card is seeking a BI Analyst for a 12-month fixed-term contract. You’ll report to the BI Lead and collaborate with colleagues across functions to define what our key measures mean and who owns them, then build data models and self-serve analytics for confident use.

You’ll work primarily with SQL, dbt and Lightdash, leveraging AI-assisted development to deliver insights efficiently and accurately.

Qualifications

• Hands-on experience building and maintaining data models in a modern analytics stack (dbt, SQL).
• Strong SQL and data modelling skills with ability to deliver end-to-end work.
• Experience building dashboards in Lightdash, Looker or Tableau.

Responsibilities

• Support metrics governance by helping stakeholders agree definitions and ownership of measures.
• Build end-to-end data models and dashboards from questions to finished products.
• Scope, test and deliver dbt and SQL work, using AI-assisted development where helpful.

Skills

SQL

dbt

Lightdash

Data modelling

Stakeholder management

AI-assisted development

Tools

Looker

Tableau

Job description

Blue Light Card. Individually great, together unstoppable

The Role and the Team

We're looking for a BI Analyst to join us on a 12-month fixed-term contract, focused on metrics governance and enablement. Reporting to the BI Lead, you'll be part of a small, closely connected team and work with colleagues across every function, including senior stakeholders, to agree what our key measures mean and who owns them. You'll then build the data models and reporting that bring those measures to life and help people use self-serve analytics with confidence.

It's a hands-on role for someone who loves building, and who equally enjoys working with people to turn business questions into clear answers. You'll work mainly in SQL, dbt and Lightdash, alongside Claude and other AI-assisted development, in a fast-paced, supportive, AI-first environment with plenty of room to take ownership.

What You'll Do

• Support our metrics governance programme by helping stakeholders agree consistent definitions and clear ownership of key measures
• Build and maintain data models and dashboards end to end, from the first business question to a finished product colleagues can use with confidence
• Scope, build, test and deliver dbt and SQL work, using AI-assisted development where it helps and checking the output carefully
• Document and test the data behind each key measure, and keep definitions and supporting documentation current so knowledge is shared rather than held by one person
• Deliver regular business reporting with accuracy and care, and keep our analytics tools reliable and easy to use
• Coach colleagues who are not data specialists, explaining concepts simply and sharing good practice so teams can act on data without waiting on the Data team
• Partner with stakeholders across the business, including senior stakeholders, to understand their priorities and turn them into clear, reliable measures and reporting
• Turn open-ended business problems and ad hoc questions into clear analysis and recommendations that guide next steps, and keep people informed of progress, risks and any support needed

What You'll Bring

• Hands-on experience building and maintaining data models in a modern analytics stack, such as dbt, in a professional setting
• Strong SQL and data modelling skills, with the ability to scope, build, test and deliver your own work
• Experience building dashboards and reports in a BI tool, such as Lightdash, Looker or Tableau
• Comfort working with stakeholders at all levels, including senior stakeholders: asking the right questions, explaining clearly and building agreement together
• The ability to turn an open-ended business problem into clear analysis and a recommendation others can act on, while managing multiple priorities
• Experience of coaching or building confidence in colleagues who are not data specialists
• Use of AI tools to work faster and more accurately, with good judgement on checking the output
• Experience of metrics governance, working with data in a digitally native or fast-paced environment, or working in an AI or machine learning setting would be a bonus

Our Culture

Our mission is simple: make heroes happy. Our members are real-life heroes who keep us all safe, cared for, and thriving. It's what gets us up in the morning, what makes us want to think bigger, and create something that truly matters. By focusing on their happiness, we create amazing experiences, deliver unrivalled discounts, innovative products, and world-class service.

We don't just follow the usual path - we look for smarter, bolder ways to deliver real impact. We take ownership, move fast, and work shoulder to shoulder to build something special.

We promote hybrid working, and value in-person collaboration so encourage time in our offices – either the HQ in Leicestershire, or London, Holborn office. The frequency and office location will vary depending on the role and team. We aim to be flexible, but we aren't able to offer fully remote working.

Blue Light Card is an equal opportunities employer. We're committed to building a diverse and inclusive team where different perspectives and experiences help us grow, innovate, and better reflect the communities we serve. We make recruiting decisions based on your experience and skills. In the event of a high number of applications, we'll prioritise candidates who meet both the essential and desirable criteria for the role.

What We Offer

• 25 days annual leave plus public holidays and an additional day off for your birthday
• A Moments that Matter day – one extra day of leave each year to use for something that matters to you
• Buy and sell holiday scheme of up to 5 days
• A volunteering/fundraising day – one paid day each year to give something back to the community
• Annual company bonus scheme – linked to both company and individual performance
• Your own Blue Light Card and exclusive access to thousands of discounts
• Personal growth fund of £450 per year to invest in your development
• Private Medical Insurance that includes cover for pre-existing conditions
• Auto-enrolment pension scheme via salary sacrifice, with 100% of employer NI savings reinvested into your pension
• Enhanced Maternity, Partner, Adoption and Shared Parental Leave
• Healthcare cash-back plan
• Colleague Assistance Programme – 24/7 confidential support whenever you need it
• Hybrid working and flexible hours
• EV charging and free parking onsite at HQ
• Relaxed dress code and modern office space (games area, chill-out areas, book club, free drinks and well stocked snack drawers!)
• On-site gym including free HIIT and stretch classes at HQ

#LI-Hybrid