Senior / Lead Data Engineer

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.