Description

Design, build, and maintain scalable Snowflake data warehouses and ETL pipelines. Own data integrity, security, and performance optimization across cloud environments.

Responsibilities

• Design and develop complex Snowflake data models, ETL processes, and data quality controls.
• Build and maintain scalable data pipelines for integrating internal and external data sources.
• Write Python code to automate data ingestion, transformation, and loading tasks.
• Optimize Snowflake warehouse performance, including virtual warehouse sizing and query tuning.
• Collaborate with stakeholders to define requirements and deliver data visualizations in Tableau.

Required Skills

• 8+ years of experience in data engineering and Snowflake data warehouse development.
• Expert proficiency in SQL, including Snowflake’s dialect and complex query optimization.
• Deep understanding of Snowflake architecture: virtual warehouses, storage/compute separation, micro-partitioning, cloning, and time travel.
• Strong expertise in Snowflake security: Role-Based Access Control (RBAC), data masking, and encryption.
• Proficiency in Python for automation, data processing, and scripting.
• Experience with ETL/ELT tools and data integration from APIs and third-party systems like Salesforce.
• Cloud platform experience with AWS or Azure.
• Familiarity with CI/CD practices, GitHub for version control, and Jira for project management.

Preferred Skills

• SnowPro Advanced Architect or SnowPro Data Engineering certification.
• Experience building multi-cloud data pipelines and implementing data governance frameworks.

Key Skills

Education

Bachelor's degree