Snowflake Data Engineer
- Softenger
- 7 - 12 years
- Pune
- 5 months ago
- Email to a friend
- Report this job
Job Description
Job Overview:
We are seeking a highly skilled and detail-oriented Snowflake Data Engineer to join our data engineering team. The ideal candidate will design and implement scalable Data Warehouse solutions leveraging Snowflake, develop robust data pipelines, and ensure optimal performance of analytics workloads. This role requires deep expertise in Snowflake architecture, SQL, and modern ELT/ETL practices.
Key Responsibilities:
- Design and implement scalable data warehouse solutions using Snowflake.
- Develop complex SQL queries for analytics, reporting, and data transformation.
- Build and maintain robust ELT/ETL pipelines using Snowflake-native capabilities and external tools like ADF or Airflow.
- Apply dimensional modeling techniques (Star/Snowflake schemas) to support BI and analytics.
- Optimize performance and manage compute costs through profiling and tuning.
- Manage Snowflake objects including tables, views, materialized views, streams, tasks, UDFs, and stored procedures.
- Ensure data quality, governance, and lineage across the data lifecycle.
- Collaborate with cross-functional teams to gather requirements and build scalable data solutions.
- Troubleshoot issues related to data ingestion, transformation, and query performance.
- Stay up-to-date with Snowflake features like Time Travel, Zero Copy Cloning, Search Optimization, and CDC via Streams/Tasks.
Required Skills:
- Advanced SQL: Joins, CTEs, window functions, recursive queries, analytical functions.
- Snowflake Architecture: Virtual warehouses, micro-partitions, clustering, scaling, caching.
- Data Modeling: Star/Snowflake schemas, normalization/denormalization strategies.
- Performance Tuning: Query optimization, result caching, warehouse sizing.
- ETL/ELT Development: Using Snowflake-native features and orchestration tools like ADF or Airflow.
- Stored Procedures & Scripting: Experience in SQL and JavaScript-based procedures and functions within Snowflake.
Preferred Experience & Tools:
- Azure Data Factory (ADF): Pipelines, triggers, linked services, and integration with ADLS Gen2.
- Programming Skills: Python or PySpark for data transformation and automation.
- Snowpipe & Streams/Tasks: Real-time ingestion and Change Data Capture (CDC).
- Data Security: Implementation of row-level security, masking, and encryption.
- DevOps Practices: Familiarity with Git, CI/CD pipelines, and Terraform (basic level).
Bonus/Value-Add Skills:
- Strong analytical and problem-solving abilities.
- Excellent communication and documentation skills.
- Agile/Scrum methodology experience.
- Leadership or mentoring experience.
- Ability to manage priorities in fast-paced, multi-project environments.
Job Classification
Industry: IT Services & ConsultingFunctional Area / Department: Engineering - Software & QARole Category: DBA / Data warehousingRole: DBA / Data warehousing - OtherEmployement Type: Full timeContact Details:
Company: SoftengerLocation(s): Pune
Keyskills: Snowflake Schema Dimensional Modeling Data Warehousing SQL Azure Data Factory Star Schema Data Modeling ETL
Similar positions
Job Listings
We are in open beta version of website, please let us know if any issues, at: info(at)indigojobs.in