Principal Consulting Snowflake Architect at CDW

Job description

The Principal Consultant serves as the senior technical authority for complex, strategic, ambiguous, or high-risk Snowflake engagements. In addition to demonstrating the capabilities expected of the Architect, this role sets enterprise-level technical direction, shapes strategic opportunities, advises executive stakeholders, governs architecture quality across engagements, mentors architects, and advances the organization's Snowflake offerings, intellectual property, delivery standards, and market credibility. The Principal remains directly involved in delivery when needed to validate architecture decisions, develop critical solution components, resolve complex technical issues, and establish credible implementation patterns for delivery teams. What You Will Do Own delivery and technical outcomes for strategic engagements, including scope, schedule, effort, dependencies, quality, budget, architecture risk, customer satisfaction, corrective action, and executive escalation. Define, govern, and deliver end-to-end Snowflake architectures spanning ingestion, transformation, modeling, analytics, AI, data sharing, governance, security, and platform operations. Maintain hands-on Snowflake leadership across SQL, pipelines, transformation, testing, troubleshooting, performance tuning, cost optimization, deployment, documentation, and knowledge transfer. Lead architects, engineers, consultants, customer teams, project managers, presales resources, account teams, and partners through discovery, design, implementation, deployment, and operational transition. Ensure solutions and teams adhere to enterprise architecture, security, privacy, governance, data quality, DevOps, testing, documentation, and operational standards. Serve as the final technical authority and architecture escalation point for critical design decisions, delivery risks, and complex customer environments. Review and approve key designs and deliverables for technical accuracy, scalability, maintainability, performance, cost, risk, and alignment to customer outcomes and Statements of Work. Lead architecture utilizing Snowflake capabilities including virtual warehouses, Snowpipe, Streams and Tasks, Dynamic Tables, Snowpark, Iceberg Tables, Marketplace, Native Apps, Horizon Catalog, Cortex AI, and secure data sharing. Work directly with executive and senior technical stakeholders to align Snowflake and AI capabilities with measurable business outcomes, modernization strategies, operating models, and innovation roadmaps. Shape strategic opportunities through discovery, solution strategy, estimates, assumptions, timelines, delivery models, proposals, SOWs, business cases, executive messaging, risk treatment, and implementation roadmaps. Provide billable consulting leadership for cloud modernization, cloud-native architecture, data governance, data quality, analytics, AI-enabled solutions, platform engineering, performance, and cost optimization. Guide multiple project teams and strategic engagements while balancing customer outcomes, scalability, delivery risk, cost, profitability, and implementation success. Establish architecture standards, decision frameworks, reference patterns, quality expectations, technical review practices, reusable offerings, accelerators, intellectual property, enablement content, demos, and thought leadership. Mentor architects, technical leaders, and delivery leaders through coaching, succession planning, capability development, knowledge transfer, and continuous improvement of delivery assets and standards. Represent the practice with customers, Snowflake, cloud partners, internal leadership, and account teams while identifying follow-on opportunities and promoting technical excellence. What We Expect of You Bachelor’s degree and 10+ years of professional experience with relational data models, databases, data engineering, ingestion, transformation, analytics delivery, and solution architecture OR 14+ years of professional experience with relation