Data Engineer

Role Overview:
We are seeking a Senior/Lead Data Engineer to drive the modernization of our enterprise data warehouse into a cloud-native analytics platform. This is a hands-on leadership role where you will design and build reliable ingestion pipelines, dimensional models, and robust operational controls. You will work closely with architects and platform teams to transition from legacy systems to a high-performance AWS + Snowflake ecosystem.
Key Responsibilities:
1. Architecture & Pipeline Engineering
Snowflake Design: Architect and build data warehouse layers, including RAW, ODS, and DW schemas, tables, and views.
Ingestion & Orchestration: Implement end-to-end pipelines using Snowflake-native features such as Snowpipe, Tasks, Streams, and Stored Procedures.
Cloud Integration: Manage data flow from AWS S3 through storage integrations and stages into the warehouse.
2. Data Modeling & Optimization
Dimensional Modeling: Develop and maintain complex Fact and Dime...