Snowflake Solution Architect in Columbus, Ohio – 3 days onsite
Modern Data and AI Consultancy (Partnered with Red Hat, Snowflake, Databricks, AWS, Azure, and GCP)
**BUSINESS NEED:**
**Why is the role open / what project does it support?**
To serve as the principal technical authority for enterprise data and AI platforms across a portfolio of client engagements. The architect will define target-state architecture, roadmaps, data modeling, and integration patterns, while owning the technical outcome, governance, and standards across engagements from pre-sales solutioning through delivery.
**TIMING:**
**Start Date:** asap
**Duration:** 1 year or perm
**Full Time/Part Time (include hours):** [Not specified, implies Full Time based on principal-level ownership and concurrent engagement management]
**LOCATION / DELIVERY:**
Hybrid 3 days onsite Columbus, Ohio
**Candidate Location:** United States
**Onshore / Nearshore / Offshore:** Onshore (US-based)
**Travel:** [Not specified in provided text]
**CANDIDATE PROFILE:**
**Must-Have Skills:**
1. **Enterprise Data & AI Platform Architecture:** Advanced-certification depth in target-state architecture using Snowflake, and cloud-native services across AWS, Azure, and GCP.
2. **Data Modeling & Integration Pattern Design:** Expertise designing layered data models (medallion, dimensional, Data Vault, 3NF), semantic layers, and integration patterns (batch, CDC, event-driven, API, data sharing).
3. **Executive Advisory & Pre-Sales Leadership:** Proven experience leading technical discovery, running architecture assessments, translating findings into phased roadmaps/investment cases, and defending technical trade-offs to client executives.
**Nice-to-Have:**
* Experience setting adoption direction for platform-native and AI capabilities (Snowflake Cortex, Snowpark, Iceberg/open table formats, Databricks Unity Catalog, Mosaic AI).
* Background in authoring practice reference architectures and engineering standards (CI/CD, Infrastructure as Code).
* Experience using AI tooling directly in design/delivery work.
**Interview Availability:** ASAP- Urgent need