Job Description:

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.
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

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 (we do not require a perfect 100% match).

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.

Senior/Technical Lead (Data Engineering, Snowflake)