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..
Candidates must have strong Snowflake hands-on delivery e.g. Snowpipe / Tasks / Streams, dimensional modelling, performance tuning, and operational readiness.
we are also open to strong enterprise DW engineers (Oracle / other cloud DW) with solid SQL and modelling fundamentals who can ramp up quickly on Snowflake.
The key is proven end-to-end delivery experience and track record, and the ability to build reliable, production-ready pipelines.
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, Snow pipe, Tasks/Streams, Stored Procedures (or equivalent agreed patterns).
Develop and maintain dimensional models (facts/dimensions), including transformations, aggregates, and performance optimization.
Implement data quality checks, reconciliation, and validation to ensure correctness and consistency.
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)
