Be at the heart of actionFly remote-controlled drones into enemy territory to gather vital information.

Apply Now

Data Engineer

Ascot Lloyd
Birmingham
3 days ago
Create job alert
Data Engineer

Reports to: Head of IT Delivery


Location: Hub Location (London/Reading/Birmingham/Leeds/Glasgow)


Hours of work: Full time (35 hours) with 3 days per week in the office


SMCR Function: This is a conduct role


The Data Engineer will play a key role in developing and maintaining Power BI reports and dashboards to support the business’s operational MI, while contributing to broader data initiatives within Azure Data Factory, Synapse Analytics, and the ongoing migration to Microsoft Fabric. This is a hands‑on delivery role suited to a mid‑level engineer with strong technical ability and a desire to grow within a modern cloud data environment.


Key Responsibilities

  • Build and maintain Power BI reports and dashboards that deliver accurate and timely insights for operational and business stakeholders.
  • Develop, test, and maintain ETL pipelines in Azure Data Factory (ADF) to ensure reliable data integration and transformation.
  • Work with Azure Synapse Analytics to model, query, and optimise data for analysis and reporting.
  • Support the team in the transition to Microsoft Fabric, assisting with data model migration and integration activities.
  • Write and optimise SQL queries to support data preparation and reporting needs.
  • Collaborate with analysts, engineers, and business teams to understand requirements and deliver fit‑for‑purpose solutions.
  • Contribute to data quality checks, documentation, and continuous improvement across the data platform.
  • Participate in Agile delivery using Azure DevOps for task management and version control.

Technical Skills

  • Power BI: Strong experience in developing and publishing reports, dashboards, and data models using DAX and Power Query.
  • Azure Data Factory: Hands‑on experience building and maintaining ETL pipelines.
  • Azure Synapse Analytics: Working knowledge of data modelling, views, and performance tuning.
  • SQL: Proficient in writing, optimising, and troubleshooting queries.
  • Azure Data Lake: Understanding of data storage and structure for analytics use cases.
  • Git / Azure DevOps: Familiar with version control and Agile delivery workflows.
  • Microsoft Fabric (Desirable): Awareness or early exposure to Fabric data pipelines, dataflows, and workspace management.

Soft Skills

  • Strong analytical mindset with attention to detail and accuracy.
  • Effective communicator who can translate technical outputs into business value.
  • Collaborative and eager to learn from senior engineers and peers.
  • Proactive in identifying improvements to processes and data quality.

Experience

  • 2-4 years of experience in a Data Engineering or BI Development role.
  • Demonstrable experience with Power BI, Azure Data Factory, and SQL.
  • Exposure to Azure Synapse Analytics and an interest in Microsoft Fabric preferred.

SM&CR Responsibilities

As an FCA regulated Company, Ascot Lloyd is required to adhere to the Senior Managers and Certification Regime (SM&CR), to develop a culture where employees take personal responsibility for their own actions.


Individual Conduct Rules

  • You must act with integrity.
  • You must act with due care, skill and diligence.
  • You must be open and co‑operative with the FCA, PRA and other regulators.
  • You must pay due regard to the interests of customers and treat them fairly.
  • You must observe proper standards of market conduct.
  • You must act to deliver good outcomes for clients.

Meta Information

  • Seniority level: Mid‑Senior level
  • Employment type: Full‑time
  • Job function: Information Technology


#J-18808-Ljbffr

Related Jobs

View all jobs

Data Engineer

Data Engineer

Data Engineer

Data Engineer

Data Engineer

Data Engineer

Subscribe to Future Tech Insights for the latest jobs & insights, direct to your inbox.

By subscribing, you agree to our privacy policy and terms of service.

Industry Insights

Discover insightful articles, industry insights, expert tips, and curated resources.

Data Engineering Recruitment Trends 2025 (UK): What Job Seekers Need To Know About Today’s Hiring Process

Summary: UK data engineering hiring has shifted from title‑led CV screens to capability‑driven assessments that emphasise reliable pipelines, modern lakehouse/streaming stacks, data contracts & governance, observability, performance/cost discipline & measurable business outcomes. This guide explains what’s changed, what to expect in interviews & how to prepare—especially for platform‑oriented DEs, analytics engineers, streaming specialists, data reliability engineers, DEs supporting AI/ML platforms & data product managers. Who this is for: Data engineers, analytics engineers, streaming engineers, data reliability/SRE, data platform engineers, data product owners, ML/feature‑store engineers & SQL/ELT specialists targeting roles in the UK.

Why Data Engineering Careers in the UK Are Becoming More Multidisciplinary

For many years, data engineering in the UK meant designing pipelines, moving data between systems, and ensuring analysts had what they needed. Today, the field is expanding. With cloud platforms, machine learning, real-time analytics and the explosion of sensitive personal data, employers expect data engineers to do much more. Modern data engineering is no longer just about code and storage. It requires legal awareness, ethical judgement, psychological insight, linguistic clarity and human-centred design. These disciplines shape how data is collected, processed, explained and trusted. In this article, we’ll explore why data engineering careers in the UK are becoming more multidisciplinary, how law, ethics, psychology, linguistics & design now influence job descriptions, and what job-seekers & employers must do to thrive.

Data Engineering Team Structures Explained: Who Does What in a Modern Data Engineering Department

Data has become the lifeblood of modern organisations. Every sector in the UK—finance, healthcare, retail, government, technology—is increasingly relying on insights derived from data to drive decisions, deliver products, and improve operations. But raw data on its own isn’t enough. To make data useful, reliable, secure, and scalable, companies must build strong data engineering teams. If you’re recruiting for data engineering or seeking a role, understanding the structure of such a team and who does what is essential. This article breaks down the typical roles in a modern data engineering department, how they collaborate, required skills and qualifications, expected UK salaries, common challenges, and advice on structuring and growing a data engineering team.