Principal Consulting Snowflake Architect

CDW; United States; Remote; USD 156,000 - 241,000; Full time

Job summary

CDW seeks a Principal Consulting Engineer to design and deliver scalable Snowflake data architectures, driving AI-enabled insights and business value for clients. You will mentor engineers, influence pre-sales, and lead complex delivery with senior stakeholders.

You bring 10+ years of consulting or 14+ years of related IT experience, Snowflake expertise, and strong SQL/Python skills, enabling modernization across cloud platforms and data governance.

Qualifications

• Bachelor's degree and 10+ years of consulting experience OR 14+ years of IT/data platform/ cloud architecture experience.
• SnowPro Core and one additional advanced certification required.
• Deep expertise in Snowflake architecture: storage/compute separation, virtual warehouses, multi-cluster scaling, micro-partitions, pruning, caching, clustering, workload isolation.
• Advanced SQL skills required; Python preferred.

Responsibilities

• Design and implement end-to-end Snowflake solutions across ingestion, transformation, modeling, analytics, data sharing, governance, AI, and operations.
• Lead implementation of Snowflake-native capabilities (virtual warehouses, Snowpipe, Streams/Tasks, Dynamic Tables, Snowpark, Cortex AI, etc.).
• Collaborate with architects, data scientists, analysts, and stakeholders to deliver complex enterprise data solutions on Snowflake.
• Provide oversight on proposals, estimates, and implementation approaches with pre-sales teams.

Skills

Snowflake architecture

SQL

Python

Cloud architecture

Leadership

Cross-functional collaboration

Education

Bachelor's degree in Computer Science or related field

Tools

Snowflake

Snowflake SQL

Azure

AWS

GCP

Python

Job description

The Principal Consulting Engineer - Snowflake

Ensures scalable data architecture solutions are designed and implemented leveraging Snowflake AI Data Cloud to the customer’s satisfaction and approval. This position serves as the senior technical authority across customer engagements and helps advance CDW's Snowflake capabilities, offerings, reusable intellectual property, and market credibility. The role leads through influence, mentors architects and engineers, shapes opportunities with pre-sales teams, and remains directly involved in delivery when the work is complex, ambiguous, or high risk. The role serves as a trusted advisor to executives, technical stakeholders, and delivery teams by translating Snowflake capabilities into measurable business outcomes, including scalability, cost efficiency, time-to-insight, and AI-driven innovation. This position will provide oversight and project guidance while taking a lead technical role in advancing CDW’s Databricks, cloud data platform, and Digital Velocity solution offerings.

What you will do

• 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 such as 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 to implement complex end‑to‑end enterprise data solutions using the Snowflake platform.
• Partner with pre‑sales teams on Snowflake statements of work, including solution scope, estimates, assumptions, timelines, and implementation approach.
• Work directly with executive and technical stakeholders to articulate the business value of Snowflake and AI/ML, translate capabilities into customer outcomes, 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 as part of the delivery model by using 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.
• Serve as a thought leader internally and externally by shaping Snowflake and AI/ML strategy, mentoring peers, contributing to reusable delivery assets, and helping build CDW’s reputation as a trusted advisor.

What we expect of you

• 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 and 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.

Pay range: $156,000 - $240,800 depending on experience and skill set Annual bonus target of 10% subject to terms and conditions of plan Benefits overview: https://cdw.benefit-info.com/ Salary ranges may be subject to geographic differentials CDW is committed to being an AI-fluent organization

CDW is committed to fostering an equitable, transparent, and respectful hiring process for all applicants. During our application process, our goal is to understand your experience, strengths, skills, and qualifications. As an AI forward company, we see AI not just as a tool, but as a catalyst for new ways of thinking, creating, and communicating. We encourage candidates to embrace an AI mindset, one that’s curious, adaptive, and ready to explore what’s possible. We welcome thoughtful use of AI to expand your perspective and elevate how you share your story, while ensuring your application remains rooted in your own background, judgment, and voice.

About Us

CDW is a Fortune 500 technology solutions provider that helps businesses, government, education, and healthcare organizations achieve what’s possible through technology. What makes CDW different isn’t just what we do-it’s how we do it. At CDW we act as one-building trust, speaking candidly, and working together to achieve more. We play to win-focusing on what matters most and delivering for our customers. And we think forward-staying curious, moving fast, and continuously learning. We believe meaningful work happens when people feel supported, heard, and empowered to contribute. That’s why we think of ourselves as coworkers, not just employees-working together to solve complex challenges and deliver real impact for our customers and communities. As a full-stack, full-lifecycle technology partner, CDW brings deep expertise, strong relationships, and broad industry knowledge to help turn ideas into outcomes. When you join CDW, you become part of a collaborative environment where your work matters, your growth is supported, and your contributions help shape what’s next. Together, we deliver the full promise of what technology can do. Together, we Make Amazing Happen. CDW is an equal opportunity employer. All qualified applicants will receive consideration for employment without regards to race, color, religion, sex, sexual orientation, gender identity, national origin, disability status, protected veteran status or any other basis prohibited by state and local law. At CDW, we make technology work so people can do great things. We are a leading multi-brand technology solutions provider to business, government, education and healthcare customers in the United States, the United Kingdom and Canada. Our coworkers across the globe are working together to bring technology to life for our customers by solving complicated IT business challenges, providing outstanding service, and orchestrating the technology landscape to optimize our customers’ performance.