Data and BI Analyst

Data and BI Analyst

Location: Halifax / hybrid

Company: Activate Group

Department: IT

Contract type: Permanent / Full-time

About the role

We're looking for a Data and BI Analyst to join our IT team at Activate Group.

The BI Analyst is a key role within the central Data & BI function, focused on delivering high-quality reporting and analysis to support business decision-making across the Group.

The role is responsible for developing Power BI dashboards, supporting analytics initiatives, and working with stakeholders to understand requirements and deliver clear, actionable outputs. The BI Analyst will work closely with Senior BI Analysts and Data Engineering to ensure reporting is accurate, consistent, and aligned to business needs.

This is a hands-on delivery role, contributing to both project work and BAU activity, with opportunities to develop broader analytical and stakeholder management capability over time.

Activate Group is a growing UK business approaching 1,000+ team members nationwide. This is an exciting opportunity to build a long-term career with a company that values its people and offers genuine development and progression opportunities.

Key responsibilities

• Develop and maintain Power BI dashboards and reports aligned to business requirements.
• Translate stakeholder requirements into clear reporting outputs, with support from senior team members where needed
• Support delivery of analytics initiatives, contributing to data preparation, modelling and visualisation.
• Work with Data Engineering to ensure data is accurate, structured and available for reporting.
• Perform data validation and quality checks to ensure accuracy and consistency of outputs.
• Apply agreed BI standards, including data modelling, naming conventions and report design.
• Support the migration of legacy reporting (Excel, Tableau) into Power BI.
• Collaborate with stakeholders across the business to understand reporting needs and provide appropriate solutions.
• Support continuous improvement of reporting and analytical processes.
• Document datasets, reports and business logic to support transparency and reuse.

Skills and experience

• Experience in a BI Analyst, Data Analyst, or similar role.
• Strong Power BI skills, including report development and basic data modelling.
• Good understanding of DAX and ability to create calculated measures.
• Strong SQL skills and ability to work with structured datasets.
• Good analytical and problem-solving skills.
• Ability to work with stakeholders to understand and deliver requirements.
• Strong attention to detail and focus on data accuracy.
• Ability to manage multiple tasks and deliver to deadlines.

Desirable (but not essential):

• Experience migrating reports from Excel or Tableau into Power BI.
• Exposure to modern data platforms (e.g. Microsoft Fabric, Azure).
• Understanding of data modelling concepts (e.g. star schema).
• Experience working within a centralised data or BI function.
• Interest in developing stakeholder management and analytical capability further.

Benefits

We believe in rewarding our people for the great work they do. When you join Activate Group, you can expect:

• 33 days holiday, including bank holidays
• Personal health cash plan – claim back the cost of everyday healthcare such as dental and optical check-ups
• Enhanced maternity, paternity, adoption and shared parental pay
• Life assurance at three times your basic salary
• Free breakfasts and fresh fruit
• A birthday surprise for everyone

What you can expect from us

At Activate Group, we want everyone to have the tools and support they need to do their best work. We're an innovative business that continuously reviews and improves our systems, processes and ways of working, making sure they support our teams to do their jobs effectively.

Every role at Activate Group is aligned to our wider business vision and purpose – making someone's bad day better. You'll understand how your role contributes to the bigger picture and how your work helps deliver excellent outcomes for customer and partners.

We believe work should be enjoyable. We make time to celebrate success, recognise achievements and bring people together at team events and company-wide celebrations. We'll also support your ongoing development through regular feedback and career planning.

Whether you're based in one of our contact centres in Halifax, Peterborough or Huddersfield, working at an Activate Accident Repair (AAR) site, or working from home, you'll be part of a supportive culture where people are encouraged to succeed.

A bit about us

Activate Group is a fast-growing business approaching 1,000 team members nationwide.

We work with some of the UK's largest fleets and insurance companies, supporting drivers that have been involved in road incidents through our contact centres in Halifax, Peterborough and Huddersfield.

We manage every step of the repair journey - repairing vehicles at our own Activate Accident Repair (AAR) body shops, as well as through a UK-wide network of trusted independent repair partners.

We also work with the UK's largest vehicle manufacturers, supporting their approved repair programmes, and deliver innovative technology solutions to fleets, vehicle repair centres and dealerships.

Our purpose & values

Our purpose underpins everything we do: Make someone's bad day better

Our values define how we work with our team members, customers and suppliers:

• Make it happen – Be accountable. Take the initiative, work fast, and do a great job.
• Strive for better – Be bold. Challenge the norm - make small improvements often.
• Win together – Be a team player. Win together, learn together, respect each other.