Data Engineer - Senior Consultant
SKILLS
FULL DESCRIPTION
Data Engineer - Senior Consultant
[Employer hidden — sign up to reveal] is hiring a Data Engineer - Senior Consultant to build reliable, scalable data platforms using Microsoft Fabric, Azure, and modern data technologies. The role involves working across the full data lifecycle, mentoring, and contributing to engineering capability growth. Requires SC clearance eligibility. Hybrid role with offices across UK cities.
- Hybrid - Newcastle, Edinburgh, Glasgow, Leeds, Manchester, Birmingham, Bristol, London
- Permanent - Employee
- Salary: £61,000 - £70,000 per annum
The Role
[Employer hidden — sign up to reveal] data engineers help organisations transform how they manage, use and learn from data. The work ranges from building modern lakehouse and warehouse platforms in Microsoft Fabric to modernising legacy environments, migrating complex workloads and improving the quality, governance and reliability of critical data services. This role offers the opportunity to work across the full data lifecycle, combining platform design, engineering, integration and optimisation. Expect to work with structured, semi-structured and unstructured data, building batch and near real-time data pipelines that underpin critical business and public services. You'll collaborate with architects, analysts, software engineers and client teams to solve complex challenges and influence technical direction. The role also offers opportunities to contribute beyond delivery through mentoring, recruitment, community building and helping to define engineering standards and best practice as our capability continues to grow.
Requirements
- This role involves weekly on-site work, and you’ll be required to travel regularly to client locations across the UK.
- You must either hold active Security Check (SC) clearance or be eligible and willing to undergo the clearance process.
- SC clearance is granted in line with UK Government security vetting requirements. Typically, applicants must have UK citizenship and have lived continuously in the UK for at least the past five years, with no single absence exceeding 28 consecutive days.
Essential Experience
- Microsoft Fabric and Azure data services, including lakehouse, warehouse, notebooks and pipeline capabilities.
- Building enterprise-scale data platforms, lakehouses and data warehouses.
- Data modelling and dimensional modelling techniques such as Kimball.
- ETL/ELT development and large-scale data integration.
- PySpark, Spark SQL and modern transformation techniques.
- Advanced SQL and relational databases including SQL Server, PostgreSQL and Oracle.
- Integrating structured, semi-structured and unstructured data sources.
- Migration and modernisation of legacy platforms such as Oracle, SQL Server/SSIS or Synapse.
- Power BI semantic models, curated datasets and supporting analytics platforms.
- Data quality, governance, metadata management and lineage.
- Data security, classification and access control approaches.
- Automated testing, validation, reconciliation testing and performance optimisation.
- DataOps, CI/CD and version control practices.
- Agile delivery environments.
Essential Consulting Skills
- Solving complex engineering challenges and exploring different approaches to finding the right solution.
- Influencing technical direction through expertise, evidence and constructive challenge.
- Working closely with technical and non-technical stakeholders to understand underlying problems rather than simply implement requirements.
- Balancing engineering quality, governance, security and reliability with business outcomes.
- Sharing knowledge, mentoring others and helping raise engineering standards.
- Building trusted relationships with clients and acting as a technical advisor.
- Keeping pace with emerging technologies and evaluating new approaches where they can add value.
- Contributing to a growing engineering capability while remaining close to delivery and technology.
What We Offer
A competitive package including a 7% employer pension contribution, share options, and a discretionary bonus. You’ll also benefit from 25 days’ holiday and access to 3 annual “life happens” days to support unexpected situations. We provide wellbeing support, ongoing professional development, volunteering opportunities, and the chance to be part of a genuinely supportive team.
Where You’ll Work
This role requires regular on-site attendance at our HQ, hub offices, and client sites, as well as the ability to work from home. Applicants must be able to travel to offices and client sites across the UK as part of their normal working arrangements, as travel is essential for fulfilling the responsibilities of the role.
We Include You
We welcome candidates from all identities, attributes, ways of thinking and backgrounds to thrive in a career at [Employer hidden — sign up to reveal]. Our aim is for the diversity of our people to be reflected in the solutions we deliver, to help create a fairer society for all.
Interview
Interviews will be conducted via Microsoft Teams. We’re happy to make adjustments to support your needs.
Want to Know More?
Visit our website or email [Employer hidden — sign up to reveal]. We may use artificial intelligence (AI) tools to support parts of the hiring process. If you would like more information about how your data is processed, please contact us.