About The Role

Build ingestion pipelines from source systems into Snowflake, following established schema and architecture design • Develop and maintain data transformation logic using SQL/dbt/Snowflake pipelines, based on defined business and technical requirements • Build and maintain aggregation and reporting layers feeding downstream dashboards and reporting tools • Implement data lineage and audit logging at the pipeline level to support traceability and compliance • Write and maintain automated tests, including data validation checks, to catch issues early and ensure pipeline reliability • Tune Snowflake objects for performance as data volumes and domain coverage grow • Support UAT activities and resolve defects, refine logic, and iterate based on business and stakeholder feedback • Document pipelines and data objects to support maintainability and future extensibility

Minimum 5 years of Data and Analytics Engineering experience • Strong SQL and Python • Hands-on experience with Snowflake Tasks, Streams, Dynamic Tables, Snowpark • Snowflake Cortex (AI/ML functions within Snowflake) • dbt model development • Medallion architecture (bronze/silver/gold layering) for pipeline design • Experience building data pipelines and frameworks with strong data validation and testing practices • Strong pipeline/ELT engineering fundamentals — ingestion patterns, schema-on-write discipline, idempotent load design • Comfortable working within an established architecture and schema, executing to spec and maintaining best practices