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

Apply Now

Senior Data Engineer

Ascot Lloyd
City of London
2 weeks ago
Create job alert

Role Title: Senior Data Engineer


Reports to: Head of IT Delivery


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


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


SMCR Function: This is a conduct role


The Senior Data Engineer will lead the design, implementation, and optimisation of data solutions across the Azure platform, ensuring scalability, reliability, and performance. The role includes ownership of data pipelines, modelling within Azure Synapse, and supporting the transition to Microsoft Fabric. The engineer will mentor junior team members, drive data quality standards, and collaborate closely with business and technology stakeholders to deliver enterprise-grade analytics solutions.


Key Responsibilities

  • Design, build, and maintain Azure Data Factory (ADF) pipelines to support complex data integration and transformation needs.
  • Develop scalable and optimised data models in Azure Synapse Analytics for analytical and operational reporting.
  • Govern and enhance Power BI datasets and semantic models, ensuring best practice in DAX, performance tuning, and report design.
  • Lead the development of data architecture and standards across Azure Data Lake and Synapse environments.
  • Contribute to the migration to Microsoft Fabric, shaping platform architecture and integration patterns.
  • Implement and maintain data validation, monitoring and quality frameworks.
  • Work collaboratively with cross-functional teams to translate business requirements into robust technical solutions.
  • Mentor and support data engineers, ensuring adherence to engineering best practices.
  • Participate in Agile delivery using Azure DevOps for backlog management, sprint planning, and CI/CD.

Technical Skills

  • Azure Data Factory: Expert in building, automating, and optimising ETL pipelines.
  • Azure Synapse Analytics: Strong experience with dedicated SQL pools, data warehousing concepts, and performance tuning.
  • Power BI: Advanced experience managing enterprise models, datasets, and governance processes.
  • SQL: Expert‑level proficiency in query design, optimisation and data transformation.
  • Azure Data Lake: Deep understanding of data structures, storage layers, and integration for analytics.
  • Microsoft Fabric (Emerging): Contribute to the organisation's transition and adoption strategy.
  • Git / Azure DevOps: Skilled in version control, release management, and CI/CD.
  • Azure Machine Learning (Desirable): Experience applying or integrating ML models to enhance analytics.
  • ChatGPT / Copilot Integrations (Desirable): Experience leveraging AI for data automation and insight generation.

Soft Skills

  • Strong leadership and mentoring capability to support and develop junior engineers.
  • Excellent documentation and knowledge‑sharing practices.
  • Analytical and adaptable in resolving complex data challenges.
  • Effective communicator, able to collaborate with both technical and business stakeholders.
  • Quality‑focused with a continuous improvement mindset.

Experience

  • 5+ years of experience in a Data Engineering role within a cloud‑based environment.
  • Proven delivery of data solutions using Azure Data Factory, Synapse Analytics, and Power BI.
  • Experience leading or contributing to data platform modernisation initiatives, ideally involving Microsoft Fabric.
  • Prior experience mentoring others and driving technical standards across teams.

SM&CR Responsibilities

As an FCA regulated Company, Ascot Lloyd are 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

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


#J-18808-Ljbffr

Related Jobs

View all jobs

Senior Data Engineer

Senior Data Engineer

Senior Data Engineer

Senior Data Engineer

Senior Data Engineer

Senior 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 Science Recruitment Trends 2025 (UK): What Job Seekers Need To Know About Today’s Hiring Process

Summary: UK data science hiring has shifted from title‑led CV screens to capability‑driven assessments that emphasise rigorous problem framing, high‑quality analytics & modelling, experiment/causality, production awareness (MLOps), governance/ethics, and measurable product or commercial impact. This guide explains what’s changed, what to expect in interviews & how to prepare—especially for product/data scientists, applied ML scientists, decision scientists, econometricians, growth/marketing analysts, and ML‑adjacent data scientists supporting LLM/AI products. Who this is for: Product/decision/data scientists, applied ML scientists, econometrics & causal inference specialists, experimentation leads, analytics engineers crossing into DS, ML generalists with strong statistics, and data scientists collaborating with platform/MLOps teams in the UK.

Why Data Science Careers in the UK Are Becoming More Multidisciplinary

Data science once meant advanced statistics, machine learning models and coding in Python or R. In the UK today, it has become one of the most in-demand professions across sectors — from healthcare to finance, retail to government. But as the field matures, employers now expect more than technical modelling skills. Modern data science is multidisciplinary. It requires not just coding and algorithms, but also legal knowledge, ethical reasoning, psychological insight, linguistic clarity and human-centred design. Data scientists are expected to interpret, communicate and apply data responsibly, with awareness of law, human behaviour and accessibility. In this article, we’ll explore why data science careers in the UK are becoming more multidisciplinary, how these five disciplines intersect with data science, and what job-seekers & employers need to know to succeed in this transformed field.

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

Data science is one of the most in-demand, dynamic, and multidisciplinary areas in the UK tech and business landscape. Organisations from finance, retail, health, government, and beyond are using data to drive decisions, automate processes, personalise services, predict trends, detect fraud, and more. To do that well, companies don’t just need good data scientists; they need teams with clearly defined roles, responsibilities, workflows, collaboration, and governance. If you're aiming for a role in data science or recruiting for one, understanding the structure of a data science department—and who does what—can make all the difference. This article breaks down the key roles, how they interact across the lifecycle of a data science project, what skills and qualifications are typical in the UK, expected salary ranges, challenges, trends, and how to build or grow an effective team.