About the role
About the Role
We are looking for a skilled Snowflake Data Engineer to design, build, and optimize scalable data pipelines and cloud data warehousing solutions. You will play a key role in transforming raw, multi-source data into reliable, high-performance datasets that power business intelligence, analytics, and data science across the organization.
Key Responsibilities
Data Pipeline Development: Design, build, and maintain robust ETL/ELT pipelines to ingest structured and semi-structured data (JSON, Parquet, Avro) into Snowflake using Snowpipe, Streams, Tasks, and external orchestrators.
Data Modeling & Transformation: Develop clean, modular data models (dimensional/star schemas) and transformation workflows using advanced SQL, Python (Snowpark), and dbt.
Performance & Cost Optimization: Monitor query performance, right-size virtual warehouses, implement clustering keys and partitioning strategies, and manage Snowflake compute and storage costs.
Data Governance & Security: Implement role-based access control (RBAC), data masking policies, Time Travel, and data quality checks to ensure security, compliance, and reliability.
Collaboration: Partner with data analysts, data scientists, and software engineers to understand data requirements and deliver production-ready datasets.
Required Qualifications
Experience: 4+ years of hands-on experience in data engineering, with at least 2 years working directly with Snowflake in a production environment.
SQL & Programming: Expert-level SQL skills and strong proficiency in Python for data processing and automation.
Snowflake Ecosystem: Deep understanding of Snowflake architecture, virtual warehouses, Snowpipe, Streams, Tasks, zero-copy cloning, and Snowpark.
Data Modeling: Proven experience designing data warehouses using dimensional modeling (Kimball/Inmon) best practices.
Cloud & DevOps: Familiarity with at least one major cloud provider (AWS, Azure, or GCP) and version control/CI/CD tools (Git, GitHub Actions, GitLab).
Requirements
- Experience: 4+ years of hands-on experience in data engineering, with at least 2 years working directly with Snowflake in a production environment.
- SQL & Programming: Expert-level SQL skills and strong proficiency in Python for data processing and automation.