Senior/Technical Lead (Data Engineering, Snowflake)

ELLIOTT MOSS CONSULTING PTE. LTD.
Penarth
5 days ago
Create job alert
Job Description

We are modernising an enterprise data warehouse into a cloud-native analytics platform on AWS and Snowflake.


We are seeking a Senior / Lead Data Engineer to design and deliver reliable ingestion and ELT pipelines, dimensional data models, and production-grade operational controls.


This is a hands-on role with scope to lead technical direction, mentor engineers, and work closely with architects, QA, and platform teams across build, testing, and go-live phases.


Key Responsibilities

  • Design and build scalable data pipelines and warehouse layers in Snowflake (RAW / ODS / DW schemas, tables, views).
  • Implement ingestion and orchestration using Snowflake capabilities such as Stages, Storage Integrations, Snowpipe, Tasks, Streams, and Stored Procedures (or agreed equivalent patterns).
  • Develop and maintain dimensional data models (facts and dimensions), including transformations, aggregates, and performance optimisation.
  • Implement data quality checks, reconciliation processes, and validation controls to ensure data accuracy and consistency.
  • Build production-ready operational controls including error handling, rerun/recovery patterns, monitoring support, and clear runbooks/documentation.
  • Collaborate with cloud/DevOps, QA, and BI/reporting teams; support SIT, UAT, and deployment activities.

Required Qualifications

  • 5+ years of experience in data engineering and enterprise data warehousing delivery.
  • Strong SQL expertise, including complex joins, window functions, and performance tuning.
  • Hands-on experience with Snowflake, or strong cloud data warehouse experience with the ability to ramp up quickly.
  • Solid understanding of dimensional modelling (fact and dimension design).
  • Experience with cloud data integration patterns (e.g., S3 or similar object storage).
  • Familiarity with production pipeline practices such as logging, retries, and operational support.
  • Plus Points (Advantage) Experience migrating Oracle or other legacy data warehouses to cloud platforms.
  • Handling of semi-structured data (JSON, XML, VARIANT). CI/CD for data platforms (Git-based workflows, automated deployments).
  • Exposure to BI tools (e.g., Tableau) and governed dataset publishing. AI / ML / GenAI-related certifications.
  • What We Value Strong ownership mindset and practical problem-solving skills.
  • Sound engineering fundamentals and clean, maintainable implementations.
  • Ability to work effectively in fast-paced, delivery-driven environments.
  • Willingness to learn and adapt —a perfect 100% skill match is not required.
  • Senior / Lead Expectations Ownership of a data workstream end-to-end.
  • Ability to guide technical design decisions and review peer deliverables.
  • Comfortable engaging stakeholders to clarify requirements and deliver iteratively.


#J-18808-Ljbffr

Related Jobs

View all jobs

Senior Technical Lead, Data Governance & Collibra

Senior Tech Lead, Reporting & Analytics — Data Strategy

Senior Data Engineer London ·

Consultant – Generative AI & Data Strategy

Lead Data Engineer

Lead Data Scientist

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.