Snowflake Data Architect — AI-Ready Enterprise Platforms

BlueCloud; United States; On-site; USD 150,000 - 230,000; Full time

Job summary

BlueCloud is seeking an experienced Data Architect to lead assessment, design, and modernization of enterprise data platforms with a strong Snowflake focus. You will define target-state architectures, guide delivery teams, and help clients build secure, cost-efficient, AI-ready data platforms for current analytics and future AI initiatives.

The ideal candidate translates complex requirements into architectural solutions, communicates with engineering teams and executive sponsors, and leads

Qualifications

• 10+ years in data architecture or a comparable senior technical role.
• At least 2–4 years of deep Snowflake architecture and implementation experience.
• Proven experience designing and modernizing enterprise-scale Snowflake data platforms.
• Strong knowledge of Snowflake environment design, security, governance, data modeling, workload management, and cost optimization.
• Hands‑on experience with Snowflake capabilities including Snowpark, Dynamic Tables, Streams and Tasks, stored procedures, and system usage views.
• Expert‑level SQL and strong Python skills.
• Strong experience with dbt and data pipelines/orchestration technologies such as Fivetran, Kafka, Airflow, or similar tools.
• Experience designing batch, streaming, lakehouse, and cloud‑native data architectures.
• Strong understanding of data governance, access control, lineage, data quality, and metadata management.
• Experience with at least one major cloud platform: AWS, Azure, or GCP.

Responsibilities

• Lead the architecture, assessment, and modernization of enterprise Snowflake data platforms.
• Define current-state and target-state architectures across ingestion, transformation, storage, orchestration, governance, security, and consumption.
• Assess pipelines and workloads by business criticality, frequency, volume, runtime, reliability, and cost.
• Analyze Snowflake usage telemetry to establish cost and performance baselines.
• Identify anti-patterns and propose modernization strategies using set-based processing and Snowpark.
• Design scalable data models, governed domains, and context models for analytics and AI.
• Architect Snowflake Cortex solutions and establish security, governance, and observability standards.
• Create data lakehouse and real-time architectures across AWS/Azure/GCP.
• Lead discovery workshops, present findings to technical and executive audiences, and guide multidisciplinary teams.

Skills

Snowflake architecture

SQL

Python

dbt

Data governance

Cloud platforms

Leadership

Stakeholder mgmt

Education

Bachelor's degree in CS/IS or related

Tools

Snowpark

Dynamic Tables

Streams and Tasks

Fivetran

Airflow

Kafka

Terraform

Lucidchart

Job description

BlueCloud is seeking an experienced Data Architect to lead assessment, design, and modernization of enterprise data platforms with a strong Snowflake focus. You will define target-state architectures, guide delivery teams, and help clients build secure, cost-efficient, AI-ready data platforms for current analytics and future AI initiatives.

The ideal candidate translates complex requirements into architectural solutions, communicates with engineering teams and executive sponsors, and leads