Senior Data Engineer

Senior Data Engineer

Location: Halifax - Hybrid

Department: IT

Contract type: Permanent

About the role 

We’re looking for a Senior Data Engineer to join our team, and play a key role in creating a scalable, secure and future-ready data warehouse to enable robust analytics, self-service reporting and data-driven decision making across the organisation. 

Activate Group is a growing UK business with 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 

• Lead the design, architecture and build of a new enterprise data warehouse on Microsoft Fabric.
• Develop robust data pipelines, orchestration processes and monitoring frameworks using Fabric components (Data Factory, Data Engineering, Lakehouse).
• Create scalable and high-quality data models to support analytics, Power BI reporting and self-service data consumption.
• Establish and enforce data governance, documentation and best practices across the data ecosystem.
• Collaborate with cross-functional teams to understand data needs and translate them into technical solutions.
• Provide technical leadership, mentoring and guidance to junior team members where required.

Skills and experience 

• Proven experience as a Senior Data Engineer, BI/Data Warehouse Engineer, or similar.
• Strong hands-on expertise with Microsoft Fabric and related services.
• End-to-end DWH development experience, from ingestion to modelling and consumption.
• Strong background in data modelling, including star schema, dimensional modelling and semantic modelling.
• Experience with orchestration, monitoring and optimisation of data pipelines.
• Proficiency in SQL and strong understanding of database principles.
• Ability to design scalable data architectures aligned to business needs.

Desirable (but not essential): 

• Experience with Databricks, Azure Synapse, Azure Data Lake, or equivalent cloud platforms.
• Knowledge of data governance and security frameworks.
• Exposure to DevOps/DataOps practices (e.g., CI/CD, Git, environments, testing).
• Experience supporting self-serve analytics programmes.

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.