onsite
Snowflake Architect - EXL Service
Software Engineer
Lead the design and implementation of Snowflake data platforms, translating business needs into robust lakehouse/warehouse solutions using advanced ELT/ETL pipelines, data modeling, and Snowflake features such as Snowpipe, Streams & Tasks, and Dynamic Tables.
About the role
Key Responsibilities
- Lead end‑to‑end Snowflake platform architecture, creating reference designs, patterns, and implementation blueprints.
- Translate business requirements into customized data lakehouse/warehouse solutions, including marts and semantic layers.
- Architect ELT/ETL pipelines into Snowflake, applying best‑practice orchestration and CI/CD pipelines.
- Design and enforce data modeling standards (dimensional, data vault, mart layers) with naming conventions.
- Implement Snowflake features such as Snowpipe, Streams & Tasks, Dynamic Tables, clustering, secure views, and security controls.
- Collaborate with stakeholders to prioritize features, optimize performance, and ensure data governance.
Requirements
- Proven experience designing and deploying Snowflake solutions at enterprise scale.
- Strong background in ELT/ETL development, data modeling, and CI/CD practices.
- Hands‑on expertise with Snowpipe, Streams & Tasks, Dynamic Tables, and clustering strategies.
- Excellent communication skills and ability to translate technical concepts to business stakeholders.
- Experience with data governance, security, and performance tuning in Snowflake.