Senior Data Engineer

Senior Data Engineer

Location:Halifax - Hybrid

Department:IT

Contract type:Permanent

About the role

Were looking for aSenior Data Engineer to join ourteam 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 1000 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 assuranceat three times your basic salary

• Free breakfasts and fresh fruit

• Abirthday surprisefor 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. Were 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 someones bad day better. Youll 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. Well also support your ongoing development through regular feedback and career planning.

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

A bit about us

Activate Group is a fast-growing business approaching1000 team members nationwide.

We work with some of the UKs largest fleets and insurance companies supporting drivers that have been involved in road incidents through our contact centres inHalifax Peterborough and Huddersfield.

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

We also work with the UKs 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 someones 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.