SNOW FLAKE + AWS IS MANDATORY
JOB DESCRIPTION
We are modernizing 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.
