Lead Data Engineer DBT

LegalAndGeneral
Cardiff
3 days ago
Create job alert

Legal and General Retails Data Operations team are currently hiring three Lead Data Engineers following the merger of internal divisions resulting in them expanding into a new area. These positions are to focus on the retirements side of the Retail division and will build out new data pipelines utilising tools such as Synapse DBT Azure Devops and Snowflake.


This role will see you responsible for designing building and implementing a variety of data solutions using modern ETL techniques and tools and you will be driving projects forward while serving as a mentor and coach to junior members of the team.


What you will be doing

  • Ensuring the solutions developed and deployed are fit for purpose and GDPR compliant meeting the business requirements adhering to quality standards and delivering the intended value
  • Ensuring all developments delivered follow the agreed standards and release management processes
  • Taking responsibility for evolving these standards in an environment of continuous change facilitating team sessions that seek to improve them and keep them current & compliant
  • Identifying issues and risks with the solutions created and leading their resolution while providing support to colleagues in your team as required while providing input into team and project planning activities and work within an agile delivery framework as part of a Scrum team
  • Facilitating the refinement of the tasks in the Product Backlog and guide and support your team as you break deliveries down into technical data engineering components
  • Converting user stories in to technical quality testing and documentation tasks in the chosen work‑flow management tool
  • Liaising with the end customers Architect & Product Owner to translate business goals into compliant specifications that facilitate the delivery of the technical solution and can be used by any engineer
  • Provide mentorship and support to junior and mid-level data engineers in your team and acting as a role model to colleagues across the Data Ops function

Qualifications

  • Proficient in data engineering practices including ELT/ETL database management systems data integration and data quality
  • Experience and practical knowledge any of the following tools: Snowflake Azure Synapse/Data Factory DBT Cloud Azure DevOps
  • Industry recognised badges/certificates on any of the following methodologies: Scrum/Kanban DevOps/DataOps Dimensional Data Modelling (Kimball)
  • Expertise in a variety of database technologies and data warehousing paradigms
  • Familiarity with cloud platforms CDC and streaming technologies and data architecture principles
  • Strong background in delivering data engineering solutions adhering to project delivery methodologies (Agile Waterfall)
  • Experience in stakeholder management complex data solution documentation and driving continuous improvement within a regulated environment

Benefits

  • The opportunity to participate in our annual performance‑related bonus plan and valuable share schemes
  • Generous pension contribution
  • Life assurance
  • Healthcare Plan (permanent employees only)
  • At least 25 days holiday plus public holidays 26 days after 2 years service. Theres also the option to buy and sell holiday
  • Competitive family leave
  • Participate in our electric car scheme which offers employees the option to hire a brand‑new electric car through tax efficient salary sacrifice (permanent employees only)
  • There are the many discounts we offer both for our own products and at a range of high street stores and online
  • In 2023 some of our workspaces were redesigned. Our offices are great spaces to connect and collaborate and have your wellbeing at the heart

Additional Information

At L&G we believe its possible to generate positive returns today while helping to build a better future for all.


If you join us youll be part of a welcoming inclusive culture with opportunities to collaborate with people of diverse backgrounds views and experiences. Guided by leaders with integrity who care about your future and wellbeing. Empowered through initiatives which support people to develop their careers and excel.


We care passionately about outcomes rather than attendance and are therefore open to discussing all kinds of flexible working options including part‑time term‑time and job shares. Although some roles have limited flexibility due to customer demand we accommodate requests when we can.


It doesnt matter if you dont meet every single criterion in this advert. Instead think about what you excel at and what else you can bring in terms of strengths potential and connection to our purpose.


Remote Work

No


Employment Type

Full‑time


Key Skills

Apache Hive,S3,Hadoop,Redshift,Spark,AWS,Apache Pig,NoSQL,Big Data,Data Warehouse,Kafka,Scala


Experience

years


Vacancy

1


#J-18808-Ljbffr

Related Jobs

View all jobs

Lead Data Engineer - DBT, Snowflake & Synapse

Lead Data Engineer - DBT

Senior Data Engineer - DBT, Snowflake & Azure

Lead Data Engineer – Azure/DBT/Snowflake – Gloucester/Flexible

DBT Lead Data Engineer & Principal Consultant (Remote)

Lead 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 Jobs for Career Switchers in Their 30s, 40s & 50s (UK Reality Check)

Thinking about switching into data science in your 30s, 40s or 50s? You’re far from alone. Across the UK, businesses are investing in data science talent to turn data into insight, support better decisions and unlock competitive advantage. But with all the hype about machine learning, Python, AI and data unicorns, it can be hard to separate real opportunities from noise. This article gives you a practical, UK-focused reality check on data science careers for mid-life career switchers — what roles really exist, what skills employers really hire for, how long retraining typically takes, what UK recruiters actually look for and how to craft a compelling career pivot story. Whether you come from finance, marketing, operations, research, project management or another field entirely, there are meaningful pathways into data science — and age itself is not the barrier many people fear.

How to Write a Data Science Job Ad That Attracts the Right People

Data science plays a critical role in how organisations across the UK make decisions, build products and gain competitive advantage. From forecasting and personalisation to risk modelling and experimentation, data scientists help translate data into insight and action. Yet many employers struggle to attract the right data science candidates. Job adverts often generate high volumes of applications, but few applicants have the mix of analytical skill, business understanding and communication ability the role actually requires. At the same time, experienced data scientists skip over adverts that feel vague, inflated or misaligned with real data science work. In most cases, the issue is not a lack of talent — it is the quality and clarity of the job advert. Data scientists are analytical, sceptical of hype and highly selective. A poorly written job ad signals unclear expectations and immature data practices. A well-written one signals credibility, focus and serious intent. This guide explains how to write a data science job ad that attracts the right people, improves applicant quality and positions your organisation as a strong data employer.

Maths for Data Science Jobs: The Only Topics You Actually Need (& How to Learn Them)

If you are applying for data science jobs in the UK, the maths can feel like a moving target. Job descriptions say “strong statistical knowledge” or “solid ML fundamentals” but they rarely tell you which topics you will actually use day to day. Here’s the truth: most UK data science roles do not require advanced pure maths. What they do require is confidence with a tight set of practical topics that come up repeatedly in modelling, experimentation, forecasting, evaluation, stakeholder comms & decision-making. This guide focuses on the only maths most data scientists keep using: Statistics for decision making (confidence intervals, hypothesis tests, power, uncertainty) Probability for real-world data (base rates, noise, sampling, Bayesian intuition) Linear algebra essentials (vectors, matrices, projections, PCA intuition) Calculus & gradients (enough to understand optimisation & backprop) Optimisation & model evaluation (loss functions, cross-validation, metrics, thresholds) You’ll also get a 6-week plan, portfolio projects & a resources section you can follow without getting pulled into unnecessary theory.