Role Overview
We are seeking a skilled Snowflake Data Engineer with strong experience in Snowflake Data Cloud, PL/SQL, and modern data engineering practices. The ideal candidate will work on designing, building, and optimizing data pipelines, ETL workflows, and Snowflake data environments. The role requires deep expertise in SQL/PLSQL, cloud platforms, Snowflake features, and data ingestion frameworks.
Key Responsibilities (KRA)
- Designing, developing, and managing end-to-end data pipelines on Snowflake
- Implementing data ingestion processes using formats such as CSV, JSON, Parquet, and Avro
- Writing advanced SQL, PL/SQL, SnowSQL, and stored procedures for data transformation
- Performing Snowflake staging (internal/external) and implementing efficient loading strategies
- Optimizing Snowflake performance through query tuning and data model improvements
- Troubleshooting failures, root-cause analysis, and resolving technical issues across ETL workflows
- Developing ETL routines using Python, Scala, PySpark, or ETL tools
- Collaborating with cloud teams to manage AWS/Azure/GCP environments supporting Snowflake workflows
- Evaluating and improving existing staging, source, and reporting data structures
- Ensuring high data quality, reliability, and governance across all data assets
- Implementing dbt models and managing transformations within the data pipeline
- Creating documentation for data flows, transformation logic, and Snowflake architecture
- Working with cross-functional teams including data analysts, BI developers, and cloud engineers
- Ensuring best practices in data security, orchestration, and cloud integration
Required Skillsets
- Strong hands-on experience with Snowflake Data Cloud
- Expertise in SQL, advanced PL/SQL, and Oracle database programming
- Experience with SnowSQL, stored procedures, and Snowflake-specific features
- Knowledge of internal and external Snowflake staging and data loading options
- Proficiency in data ingestion from multiple file formats (CSV, JSON, Parquet, Avro, etc.)
- Strong understanding of ETL development using Python, Scala, or PySpark
- Experience with AWS, Azure, or GCP cloud platforms
- Knowledge of dbt for data transformation and modeling
- Experience in SQL performance tuning and root-cause analysis
- Familiarity with modern data architectures and data modeling concepts
- Strong problem-solving skills and the ability to troubleshoot complex pipelines
- Experience evaluating and improving existing data structures
- Good communication, documentation, and teamwork abilities
Qualifications
- Bachelor's degree in Computer Science, Engineering, Information Systems, or equivalent
- 4 - 7 years of experience in data engineering roles
- Minimum 2 years hands-on experience with Snowflake
- Strong hands-on experience with PL/SQL and SQL development
- Experience working with cloud environments such as AWS, Azure, or GCP
(ref:hirist.tech)
