← Back to jobs

E-Solutions Logo
Snowflake Solutions Architect

E-Solutions

 

United States

Posted On: Just posted
Experience: 15+ years
Availability: Remote
Openings: 1
Category: Snowflake Solutions Architect
Tenure: Contract - Corp-to-Corp
Related Jobs

No related jobs found

Description

Architect and implement secure, scalable Snowflake data platforms with integrated governance, performance optimization, and CI/CD pipelines.

This role is remote.

Responsibilities

  • Define multi-environment Snowflake architecture including secure RBAC, PrivateLink, VPC peering, and resource governance.
  • Design data ingestion frameworks using Snowpipe, Streams, Tasks, and external tables for batch and real-time flows.
  • Develop and optimize transformations using dbt and/or Snowpark (Python/Scala) and build dimensional or data vault models.
  • Lead CI/CD integration, Infrastructure-as-Code (Terraform/CloudFormation), and version control for data pipelines.
  • Implement warehouse sizing, clustering, query optimization, and cost monitoring dashboards to ensure FinOps compliance.

Required Skills

  • 15+ years in data engineering or architecture, with 3+ years specifically in Snowflake.
  • Strong command of SQL and Snowflake internals (warehouses, micro-partitions, caching, services layer).
  • Hands-on experience with Snowpipe, Streams & Tasks, materialized views, and external tables.
  • Proficiency in dbt and/or Snowpark (Python/Scala).
  • Strong experience with one major cloud platform (AWS, Azure, or GCP).
  • Proficiency in IaC tools (Terraform/CloudFormation) and CI/CD pipelines.
  • Experience with orchestration tools such as Airflow, ADF, or Prefect.
  • Proven background in security (RBAC, data masking, compliance) and cost governance.

Preferred Skills

  • Experience with CDC tools (Fivetran, Debezium) and streaming platforms (Kafka, Pub/Sub, Event Hubs).
  • Familiarity with BI tools (Power BI, Tableau, Looker) and data governance platforms (Collibra, Alation).

Education

Bachelor's degree

Related Jobs

No related jobs found

← Back to jobs