Description

You will design and optimize data engineering solutions using Snowflake, managing end-to-end ETL pipelines and data warehousing architecture.

This role is on-site.

Responsibilities

• Build and maintain cloud-based data pipelines using Python and SQL for ETL/ELT development.
• Design Snowflake architecture, including security, roles, warehouses, stages, tasks, and streams.
• Optimize Spark job performance and tune Snowflake queries for high efficiency.
• Develop dimensional models using Star and Snowflake schema designs.
• Troubleshoot production issues and conduct root cause analysis for data integration failures.

Required Skills

• 6+ years of Data Engineering or ETL experience.
• 3+ years of hands-on Snowflake experience, including SnowSQL and SnowPipe.
• Strong proficiency in Python and advanced SQL.
• Experience with Spark performance tuning and big data technologies.
• Knowledge of relational databases (Oracle, SQL Server, PostgreSQL, MySQL) and NoSQL (MongoDB, Cassandra, DynamoDB).
• Expertise in dimensional modeling, data warehousing, and data migration.
• Ability to create technical documentation and functional specifications.

Key Skills

Education

Bachelor's degree