Lead Data Engineer DBT

LegalAndGeneral
Cardiff
1 month ago
Applications closed

Related Jobs

View all jobs

Lead Data Engineer

Lead Data Engineer

Lead Data Engineer

Data Engineer

Data Engineer - Data Vault

Senior Data Engineer

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

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.

How Many Data Science Tools Do You Need to Know to Get a Data Science Job?

If you’re trying to break into data science — or progress your career — it can feel like you are drowning in names: Python, R, TensorFlow, PyTorch, SQL, Spark, AWS, Scikit-learn, Jupyter, Tableau, Power BI…the list just keeps going. With every job advert listing a different combination of tools, many applicants fall into a trap: they try to learn everything. The result? Long tool lists that sound impressive — but little depth to back them up. Here’s the straight-talk version most hiring managers won’t explicitly tell you: 👉 You don’t need to know every data science tool to get hired. 👉 You need to know the right ones — deeply — and know how to use them to solve real problems. Tools matter, but only in service of outcomes. So how many data science tools do you actually need to know to get a job? For most job seekers, the answer is not “27” — it’s more like 8–12, thoughtfully chosen and well understood. This guide explains what employers really value, which tools are core, which are role-specific, and how to focus your toolbox so your CV and interviews shine.

What Hiring Managers Look for First in Data Science Job Applications (UK Guide)

If you’re applying for data science roles in the UK, it’s crucial to understand what hiring managers focus on before they dive into your full CV. In competitive markets, recruiters and hiring managers often make their first decisions in the first 10–20 seconds of scanning an application — and in data science, there are specific signals they look for first. Data science isn’t just about coding or statistics — it’s about producing insights, shipping models, collaborating with teams, and solving real business problems. This guide helps you understand exactly what hiring managers look for first in data science applications — and how to structure your CV, portfolio and cover letter so you leap to the top of the shortlist.

The Skills Gap in Data Science Jobs: What Universities Aren’t Teaching

Data science has become one of the most visible and sought-after careers in the UK technology market. From financial services and retail to healthcare, media, government and sport, organisations increasingly rely on data scientists to extract insight, guide decisions and build predictive models. Universities have responded quickly. Degrees in data science, analytics and artificial intelligence have expanded rapidly, and many computer science courses now include data-focused pathways. And yet, despite the volume of graduates entering the market, employers across the UK consistently report the same problem: Many data science candidates are not job-ready. Vacancies remain open. Hiring processes drag on. Candidates with impressive academic backgrounds fail interviews or struggle once hired. The issue is not intelligence or effort. It is a persistent skills gap between university education and real-world data science roles. This article explores that gap in depth: what universities teach well, what they often miss, why the gap exists, what employers actually want, and how jobseekers can bridge the divide to build successful careers in data science.