Key Responsibilities
JOB DESCRIPTION
- 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





Required Skills & Experience
- Minimum 5 years of Data and Analytics Engineering experience
- Solid 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

📌 Process Manager (Pune Division)
🏢 eClerx
📍 Pune Division