Description:

We are looking for an experienced Snowflake Developer to design, develop, and maintain scalable cloud-based data warehouse and data engineering solutions.

Key Responsibilities:

• Develop and maintain data pipelines using Snowflake, SQL, and Python.
• Design and implement ETL/ELT processes for data ingestion and transformation.
• Develop Snowflake objects including databases, schemas, tables, views, stored procedures, Streams, Tasks, and Snowpipe.
• Build scalable data models for analytics and reporting.
• Perform SQL query optimization and Snowflake performance tuning.
• Implement data loading, transformation, validation, and reconciliation processes.
• Integrate Snowflake with cloud services such as AWS S3 and AWS Glue.
• Work with orchestration tools such as Airflow or dbt.
• Troubleshoot data pipeline and production issues and perform root-cause analysis.
• Implement data quality, security, governance, and access-control practices.
• Collaborate with Data Engineers, BI teams, Analysts, Architects, and business stakeholders.
• Participate in code reviews, testing, deployment, and production support.

Required Skills:

• Strong hands-on experience with Snowflake.
• Advanced SQL and database development experience.
• Strong Python programming skills.
• Experience with ETL/ELT development and data pipelines.
• Good understanding of data warehousing and dimensional data modeling.
• Experience with Snowflake Streams, Tasks, Snowpipe, and stored procedures.
• Experience with cloud platforms, preferably AWS.
• Experience with Git and CI/CD processes.
• Strong troubleshooting and performance-tuning skills.

Good to Have:

• Snowpark
• dbt
• Apache Airflow
• AWS Glue
• Kafka
• CDC and SCD
• Tableau or Power BI
• Snowflake certification