Senior (Data Engineering, Snowflake)

Job Description

We are modernising an enterprise data warehouse to a cloud-native analytics platform on AWS + Snowflake. We are looking for a Senior/Lead Data Engineer to design and build reliable ingestion and ELT pipelines, dimensional data models, and production-ready operational controls.

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

Key Responsibilities

- Design and build data pipelines and data warehouse layers in Snowflake (e.g., RAW/ODS/DW schemas, tables, views).

- Implement ingestion and orchestration using Snowflake features such as Stages/Storage Integrations, Snowpipe, Tasks/Streams, Stored Procedures (or equivalent agreed patterns).

- Develop and maintain dimensional models (facts/dimensions), including transformations, aggregates, and performance optimisation.

- Implement data quality checks, reconciliation, and validation to ensure correctness and consistency.

- Build operational readiness: error handling, rerun/recovery patterns, monitoring support, and clear runbooks/documentation.

- Collaborate with cross-functional teams (cloud/DevOps, QA, BI/reporting) and support SIT/UAT and deployment activities.

Qualifications

Requirements (Must-Have)

- 5+ years of experience in data engineering / enterprise data warehousing delivery.

- Strong SQL skills (complex joins, window functions, performance tuning).

- Hands-on experience building on Snowflake (or strong cloud DW experience with solid ability to ramp up on Snowflake quickly).

- Good understanding of dimensional modelling (fact/dimension design).

- Experience with cloud data integration patterns (e.g., S3 or similar object storage) and production pipeline practices (logging, retries, operational support)

Plus Points (Advantage)

- Oracle DW / legacy warehouse migration experience.

- Semi-structured data handling (JSON/XML/VARIANT).

- CI/CD for data deployments (Git-based workflows, automated releases).

- Familiarity with BI tools (e.g., Tableau) and governed dataset publishing.

- AI / ML/ GenAI-related certification(s)

What We Value

- Practical problem-solving and delivery ownership.

- Strong engineering fundamentals and clean implementation.

- Ability to work in fast-paced projects and collaborate effectively.

- Willingness to learn and adapt

Senior/Lead Expectations

- Can take ownership of a workstream end-to-end.

- Can guide design decisions and review others work.

- Comfortable working with stakeholders to clarify requirements and deliver iteratively.