Design, develop, and maintain scalable data pipelines that ingest, transform, and load data into Snowflake.
This role is hybrid.
Responsibilities
Build and optimize ETL/ELT pipelines using Python, Snowflake SQL, and Snowpark to load data from databases, APIs, and cloud storage (S3, Azure Blob, GCS).
Orchestrate workflows using Airflow, Azure Data Factory, dbt, or Control-M and implement CI/CD pipelines for data workflows.
Implement data validation, quality checks, and reconciliation processes to ensure SLA compliance.
Optimize Snowflake performance through clustering, partitioning, caching, and warehouse sizing.
Ensure data security and governance using RBAC, masking policies, and encryption.
Required Skills
5+ years of experience with Snowflake Data Cloud and Python for ETL development (Pandas, PySpark, Snowpark).
Strong SQL skills, specifically within Snowflake.
Experience with ETL/ELT tools and orchestration frameworks such as Airflow or Azure Data Factory.
Knowledge of cloud platforms: AWS, Azure, or Google Cloud Platform.
Experience with data modeling (star/snowflake schemas) and implementing CI/CD, Git, and DevOps practices.
Understanding of data security, governance, and compliance standards.