Description

Lead data development and architectural advisory for multiple projects using Snowflake and Python.

Responsibilities

• Develop and maintain Snowflake database structures using SnowSQL, Snowpipes, Streams, Views, and Procedures.
• Implement data movement strategies between Snowflake and other RDBMS like Oracle and MS SQL.
• Optimize database performance through SQL tuning, troubleshooting, and managing Dynamic Tables.
• Build real-time or near real-time data pipelines using Kafka and Snowpipe.
• Manage data orchestration workflows using Apache Airflow.

Required Skills

• 9+ years of relevant experience in data engineering and database development.
• Expert-level Python proficiency, specifically with pandas, Snowpark, snowflake-connect, and boto3.
• Deep expertise in Snowflake features including Time Travel, CDC, and Dynamic Tables.
• Hands-on experience with AWS cloud environments.
• Advanced SQL skills, including complex joins and analytical functions.
• Experience with orchestration tools like Apache Airflow.
• Proven ability to handle client requirements and advise on project architecture.
• Experience working within Agile/Scrum frameworks.
• BE degree.

Preferred Skills

• Knowledge of DBT.
• Experience with CI/CD pipelines using Jenkins or Bamboo.
• Familiarity with AWS services such as S3, Lambda, and Athena.

Key Skills

Education

BE