Principal Consulting Architect, Snowflake

🕒 August 13

🇺🇸 United States – Remote

💵 $156k - $240.8k / year

⏰ Full Time

🔴 Lead

🏛️ Architect

🦅 H1B Visa Sponsor

This company has sponsored H1B visas in the past.

👻 Ghost score 24%

What it means: how likely this posting is sitting open without active hiring.How to read it: 60% or higher means we think this is a ghost. Lower scores are less of a worry.How we score it: age, reposts, open roles vs team size, how fast jobs close, and whether pay is listed.Fine print: an estimate from public data, not a judgment of the company. Real jobs can score high, so treat it as a hint, not a fact.

Apply Now

Find Similar Remote Jobs

Set Up Email Alert For New Jobs

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume

CDW

WebsiteLinkedInAll Job Openings

10,000+ employees

Founded 1984

💼 Consulting

🏥 Healthcare

📚 Education

💰 Post-IPO Equity on 2015-07

Consulting • Healthcare • Education

CDW is a leading provider of technology solutions, offering a comprehensive range of products and services to address the needs of enterprises, government, healthcare, and education sectors. They specialize in providing IT infrastructure services, managed services, and security solutions. CDW partners with top technology brands to deliver customized solutions that enhance business productivity and performance across various industries. With a strong focus on digital transformation, security, and cloud solutions, CDW supports businesses in navigating the complexities of modern IT environments. Their expertise spans several domains, including digital workspaces, cybersecurity, and enterprise solutions, making CDW a key partner in driving technological advancements.

📋 Description

• Design and implement end-to-end Snowflake solutions spanning ingestion, transformation, data modeling, analytics, data sharing, governance, artificial intelligence, and platform operations • Lead implementation of Snowflake-native capabilities including virtual warehouses, Snowpipe, Streams and Tasks, Dynamic Tables, Snowpark, secure data sharing, Iceberg Tables, Snowflake Marketplace, Native Apps, and Cortex AI • Collaborate with cloud solution architects, data engineers, data scientists, business analysts, and customer stakeholders on complex enterprise data solutions • Partner with pre-sales teams on Snowflake statements of work, including scope, estimates, assumptions, timelines, and implementation approach • Advise executive and technical stakeholders on the business value of Snowflake and AI/ML and co-create innovation roadmaps • Provide billable consulting leadership through complex Snowflake architecture, cloud-native pattern design, platform modernization, data governance, data quality, and cloud engineering solutions • Champion AI/ML through automation, optimization, and machine learning frameworks to accelerate implementation, reduce cost, and increase customer impact • Assess customer data ecosystems, cloud data readiness, IT priorities, and business success measures to design implementation architectures and structured learning plans • Shape Snowflake and AI/ML strategy, mentor peers, contribute to reusable delivery assets, and build CDW’s reputation as a trusted advisor

🎯 Requirements

• Bachelor’s degree and 10+ years of consulting experience, including hands-on experience designing and implementing Snowflake platform solutions OR 14+ years of related IT, data platform, or cloud architecture experience • SnowPro Core and one additional advanced certification required • Deep expertise in Snowflake architecture, including storage and compute separation, virtual warehouses, multi-cluster scaling, micro-partitions, pruning, caching, clustering, and workload isolation • Advanced SQL skills required; Python preferred • Experience designing data pipelines with Snowpipe, Streams and Tasks, Dynamic Tables, stored procedures, user-defined functions, and enterprise orchestration or transformation tools • Experience with enterprise data modeling, dimensional modeling, data vault or comparable patterns, semantic layers, data products, and modern ELT practices • Experience integrating Snowflake with cloud storage, SaaS platforms, APIs, business intelligence tools, data integration tools, identity providers, DevOps pipelines, and observability solutions • Experience with data governance, data cataloging, master data management, data quality, RBAC, security, compliance, and data lineage using Unity Catalog and related modern data platform practices • Strong cloud data architecture experience across Azure, AWS, or Google Cloud, including data platform modernization, cloud-native design patterns, advanced analytics, and AI/ML solution enablement • Proven ability to lead architecture decisions, own end-to-end technical accountability, mentor other resources, and guide platform-agnostic projects in agile, fast-paced environments • Willingness to travel to other CDW locations or client sites • A valid U.S. driver’s license is required

🏖️ Benefits

• Annual bonus target of 10% subject to terms and conditions of plan • Benefits offered; details provided at https://cdw.benefit-info.com/ • Remote work arrangement • Salary ranges may be subject to geographic differentials