Description

You will design and build data infrastructure within Snowflake.

Responsibilities

• Design and implement Snowflake schemas (star, snowflake, data vault) optimized with micro-partitioning, clustering keys, materialized views, and search optimization services.
• Build real-time and batch ingestion pipelines into Snowflake using Snowpipe, Kafka Connect, Fivetran, Matillion, Informatica, or dbt.
• Automate incremental data processing with Streams & Tasks to support CDC (Change Data Capture).
• Develop data transformation logic in Snowpark for Python/SQL/Scala to push compute directly into Snowflake.
• Implement RBAC (Role-Based Access Control), Row Access Policies, and Dynamic Data Masking for data security.

Required Skills

• 10+ years of data engineering experience, with 5+ years in Snowflake Data Cloud.
• Expertise in SQL optimization and Snowflake performance tuning.
• Hands-on with Snowpipe, Streams & Tasks, Snowpark, Zero-Copy Cloning, and Secure Data Sharing.
• Proficiency in Python, Scala, or Java for Snowpark development.
• Experience integrating with cloud platforms like AWS (S3).
• Familiarity with CI/CD, Git, DevOps practices for data operations (GitHub Actions, Azure DevOps).
• Experience with ETL/ELT tools (Informatica, Matillion, Fivetran).
• Knowledge of semi-structured data handling (JSON, Avro, Parquet).
• Bachelor’s or Master’s degree in Computer Science, Data Engineering, or related field.

Preferred Skills

• SnowPro Core Certification.
• Experience with Tableau or Power BI integration.

Key Skills

Education

Bachelor’s/Master’s degree