We are seeking a Snowflake Engineer to design, build, and optimize scalable data solutions using the Snowflake Data Cloud. The ideal candidate will have strong expertise in data modeling, ELT/ETL pipelines, SQL performance tuning, and cloud integration, enabling robust and efficient data processing for analytics and business insights.
Design, develop, and maintain data pipelines and data models in Snowflake.
Implement data ingestion, transformation, and integration processes from multiple structured and unstructured data sources.
Optimize Snowflake performance through clustering, partitioning, caching, and query tuning.
Build secure and efficient data sharing and data governance frameworks within Snowflake.
Collaborate with analytics, BI, and data science teams to deliver high-quality datasets and data marts.
Integrate Snowflake with ETL/ELT tools (Informatica, dbt, Matillion, Talend, etc.) and orchestration tools (Airflow, Azure Data Factory, AWS Glue).
Implement role-based access control (RBAC), data masking, and other security mechanisms.
Automate monitoring and management of data pipelines and ensure data quality and reliability.
Stay updated with Snowflake's latest features, releases, and best practices.
Core Expertise: Snowflake Data Warehouse (architecture, performance tuning, best practices)
Data Modeling: Dimensional modeling (Star/Snowflake schema), normalization/denormalization
SQL Expertise: Advanced SQL scripting, query optimization, stored procedures, and UDFs
ETL/ELT Tools: dbt, Informatica, Talend, Matillion, Apache Airflow, Azure Data Factory, or AWS Glue
Programming Languages: Python, SQL, or Java (for automation and integrations)
Cloud Platforms: AWS, Azure, or GCP (with Snowflake integration)
Version Control: Git, CI/CD pipelines (Jenkins, GitLab CI/CD)
Optional (Nice-to-Have):
Knowledge of Snowpark, Streamlit, or Snowflake Native Apps
Experience with data lakes, Kafka, or real-time data streaming
Familiarity with Power BI, Tableau, or Looker
Strong analytical and problem-solving skills
Ability to work collaboratively with cross-functional teams
Strong communication and documentation skills
Detail-oriented with focus on data accuracy and reliability