Senior Data Engineer

We are looking for a highly skilled Senior Data Engineer to lead the design and build of our new enterprise data platform using Microsoft Fabric. This is a hands-on role focused on creating a scalable, secure and future-ready data warehouse to enable robust analytics, self-service reporting and data-driven decision making across the organisation.

You will work closely with business stakeholders, analysts and BI teams to define architecture, deliver high-quality data models, and ensure end-to-end orchestration, governance and monitoring of data pipelines. This is an exciting opportunity to shape a greenfield solution from the ground up using cutting-edge cloud technologies.

• 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.

Essential:

• 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:

• 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.

• 33 days holiday (including bank holidays)
• Personal health cash plan – claim back the cost of things like dentist and optical check ups
• Enhanced maternity / paternity / adoption / shared parental pay
• Life assurance: three times basic salary
• Free breakfasts and fruit
• Birthday surprise for everybody!

At Activate Group, looking after team members is a major priority. Whether you are at our smart Halifax or Peterborough offices, one of our AAR sites or working from home, we will make sure you have all the support you need to succeed. From benefits that put your health and wellbeing first, to impressive rewards for our employee of the month, and little perks like free fruit and cereal, we will go out of our way to show how much we appreciate you.

Named by the Sunday Times as one of the UK’s 100 fastest-growing private companies, we employ more than 700 team members nationwide. We work with some of the UK’s largest fleets and insurance companies, supporting drivers that have been involved in a road incident at our contact centres in Halifax and Peterborough. We look after every step of the repair process, repairing vehicles at our own Activate Accident Repair body shops, and through a UK-wide network of independent repair partners.

Want to know what it’s like to work with us? Take a look at our purpose and values. They define who we are, and how we work with team members, customers and suppliers:

Purpose: Make someone's bad day better

Values:

• 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.