Designs and delivers Snowflake data architectures on AWS, including dbt-based data engineering and AI-enabled solutions. Leads RAG, vector search, embedding, semantic search, and analytics initiatives from proof of concept through production. Directs project teams, oversees solution quality and budgets, supports proposals and business cases, and serves as a trusted technical advisor to clients. Requires strong data engineering, governance, documentation, communication, and stakeholder-management skills, with travel as needed.
Description
The Consulting Data Architect, Snowflake is responsible for designing end-to-end Snowflake solutions and providing technical leadership throughout implementation. In addition to demonstrating the capabilities expected of the Senior Consulting Data Engineer, this role translates business and technical requirements into scalable architectures, leads project teams, owns solution-level quality, creates reusable solution patterns, and serves as a trusted technical advisor to customer stakeholders. The role remains hands-on as needed while directing engineers, consultants, and customer teams in the delivery of data engineering, analytics, governance, and AI-enabled Snowflake solutions. What You Will Do
* Manage team delivery against the Statement of Work, including scope, schedule, effort, dependencies, quality, and budget; communicate status and escalate risks with corrective recommendations.
* Perform hands-on development in Snowflake, SQL, dbt, python, ingestion, transformation, modeling, testing, troubleshooting, deployment, documentation, and knowledge transfer as required for delivery success.
* Design and lead implementation of end-to-end Snowflake architectures, including ingestion, transformation, data modeling, analytics, security, governance, platform operations, and dbt-based ELT patterns.
* Ensure project teams follow approved architecture, security, privacy, governance, source-control, testing, deployment, and documentation standards.
* Review solution components and deliverables for technical accuracy, data quality, maintainability, performance, and alignment with customer requirements and architecture decisions.
* Coordinate customer stakeholders, engineers, consultants, project managers, account teams, and partners; identify follow-on opportunities and contribute reusable delivery practices.
* Translate customer business objectives, technical requirements, constraints, and success measures into documented solution architectures and implementation plans.
* Lead project teams by directing engineers, consultants, and customer technical resources in solution design, development, testing, deployment, and knowledge transfer.
* Own technical decisions for assigned engagements and resolve design conflicts across workstreams, integrations, security requirements, and delivery dependencies.
* Build and validate proofs of concept, prototypes, reusable accelerators, reference architectures, and implementation templates that move data and AI solutions toward production-ready outcomes.
* Design practical AI-enabled solution patterns, including retrieval-augmented generation, vector search, embedding pipelines, prompt orchestration, semantic search, and AI-enabled analytics workflows.
* Conduct architecture and peer reviews; own solution-level technical quality and confirm deliverables align with requirements, architecture decisions, project scope, and the Statement of Work.
* Monitor technical delivery against scope, schedule, effort, and budget; proactively address or escalate risks and recommend corrective actions.
* Support discovery, business-case development, estimates, assumptions, proposals, SOWs, quotations, presentations, and implementation approaches in partnership with account and presales teams.
* Serve as the primary trusted technical advisor for project stakeholders and communicate effectively across customer, delivery, sales, and partner teams.
* Create reusable delivery assets and promote consistent architecture, engineering, documentation, and quality practices across engagements.
* Mentor engineers and consultants and provide actionable technical guidance and knowledge transfer.
* Attend required customer and internal meetings with camera on when participating virtually, unless an approved exception or practical limitation applies. What We Expect of You
* Bachelor's degree and 7+ years of professional experience with relational data models, databases, data engineering, ingestion, transformation, analytics delivery, and solution architecture OR 11+ years of professional experience with relational data models, databases, data engineering, ingestion, transformation, analytics delivery, and solution architecture
* Consulting experience with Snowflake is required.
* Advanced experience designing Snowflake solutions using SQL, dbt, python, modern ELT, data modeling, security, governance, and performance optimization patterns.
* Demonstrated ability to own end-to-end technical design and lead implementation across multiple workstreams and stakeholder groups.
* Experience selecting and applying dimensional, medallion, Data Vault, or comparable modeling patterns based on customer needs.
* Experience designing RBAC, data quality, lineage, privacy, security, governance, deployment, and operational controls.
* Experience leading proofs of concept and translating outcomes into production implementation plans.
* Strong consulting, facilitation, presentation, and written communication skills with the ability to influence technical and business stakeholders.
* Demonstrated ability to review technical deliverables, identify architecture and delivery risks, and provide clear corrective direction.
* Experience supporting presales discovery, solution scope, estimates, assumptions, and customer presentations.
* SnowPro Core certification required; an advanced Snowflake certification is preferred.
* Ability and willingness to travel to customer or company locations as needed. Pay range: $128,000 - $193,200 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
* We're looking for people who bring curiosity, a learner's mindset, and a willingness to engage with ever-evolving technology and tools. We value adopting AI as a partner, openness to experimentation, and a shared interest in learning together on AI. Our goal is to create a culture where AI enhances- not replaces- human creativity and decision-making. You don't need to be an expert today; what matters is your readiness to explore, adapt, and grow with us as we integrate AI responsibly and effectively into our work.Additionally, 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.
The Consulting Data Architect, Snowflake is responsible for designing end-to-end Snowflake solutions and providing technical leadership throughout implementation. In addition to demonstrating the capabilities expected of the Senior Consulting Data Engineer, this role translates business and technical requirements into scalable architectures, leads project teams, owns solution-level quality, creates reusable solution patterns, and serves as a trusted technical advisor to customer stakeholders. The role remains hands-on as needed while directing engineers, consultants, and customer teams in the delivery of data engineering, analytics, governance, and AI-enabled Snowflake solutions. What You Will Do
* Manage team delivery against the Statement of Work, including scope, schedule, effort, dependencies, quality, and budget; communicate status and escalate risks with corrective recommendations.
* Perform hands-on development in Snowflake, SQL, dbt, python, ingestion, transformation, modeling, testing, troubleshooting, deployment, documentation, and knowledge transfer as required for delivery success.
* Design and lead implementation of end-to-end Snowflake architectures, including ingestion, transformation, data modeling, analytics, security, governance, platform operations, and dbt-based ELT patterns.
* Ensure project teams follow approved architecture, security, privacy, governance, source-control, testing, deployment, and documentation standards.
* Review solution components and deliverables for technical accuracy, data quality, maintainability, performance, and alignment with customer requirements and architecture decisions.
* Coordinate customer stakeholders, engineers, consultants, project managers, account teams, and partners; identify follow-on opportunities and contribute reusable delivery practices.
* Translate customer business objectives, technical requirements, constraints, and success measures into documented solution architectures and implementation plans.
* Lead project teams by directing engineers, consultants, and customer technical resources in solution design, development, testing, deployment, and knowledge transfer.
* Own technical decisions for assigned engagements and resolve design conflicts across workstreams, integrations, security requirements, and delivery dependencies.
* Build and validate proofs of concept, prototypes, reusable accelerators, reference architectures, and implementation templates that move data and AI solutions toward production-ready outcomes.
* Design practical AI-enabled solution patterns, including retrieval-augmented generation, vector search, embedding pipelines, prompt orchestration, semantic search, and AI-enabled analytics workflows.
* Conduct architecture and peer reviews; own solution-level technical quality and confirm deliverables align with requirements, architecture decisions, project scope, and the Statement of Work.
* Monitor technical delivery against scope, schedule, effort, and budget; proactively address or escalate risks and recommend corrective actions.
* Support discovery, business-case development, estimates, assumptions, proposals, SOWs, quotations, presentations, and implementation approaches in partnership with account and presales teams.
* Serve as the primary trusted technical advisor for project stakeholders and communicate effectively across customer, delivery, sales, and partner teams.
* Create reusable delivery assets and promote consistent architecture, engineering, documentation, and quality practices across engagements.
* Mentor engineers and consultants and provide actionable technical guidance and knowledge transfer.
* Attend required customer and internal meetings with camera on when participating virtually, unless an approved exception or practical limitation applies. What We Expect of You
* Bachelor's degree and 7+ years of professional experience with relational data models, databases, data engineering, ingestion, transformation, analytics delivery, and solution architecture OR 11+ years of professional experience with relational data models, databases, data engineering, ingestion, transformation, analytics delivery, and solution architecture
* Consulting experience with Snowflake is required.
* Advanced experience designing Snowflake solutions using SQL, dbt, python, modern ELT, data modeling, security, governance, and performance optimization patterns.
* Demonstrated ability to own end-to-end technical design and lead implementation across multiple workstreams and stakeholder groups.
* Experience selecting and applying dimensional, medallion, Data Vault, or comparable modeling patterns based on customer needs.
* Experience designing RBAC, data quality, lineage, privacy, security, governance, deployment, and operational controls.
* Experience leading proofs of concept and translating outcomes into production implementation plans.
* Strong consulting, facilitation, presentation, and written communication skills with the ability to influence technical and business stakeholders.
* Demonstrated ability to review technical deliverables, identify architecture and delivery risks, and provide clear corrective direction.
* Experience supporting presales discovery, solution scope, estimates, assumptions, and customer presentations.
* SnowPro Core certification required; an advanced Snowflake certification is preferred.
* Ability and willingness to travel to customer or company locations as needed. Pay range: $128,000 - $193,200 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
* We're looking for people who bring curiosity, a learner's mindset, and a willingness to engage with ever-evolving technology and tools. We value adopting AI as a partner, openness to experimentation, and a shared interest in learning together on AI. Our goal is to create a culture where AI enhances- not replaces- human creativity and decision-making. You don't need to be an expert today; what matters is your readiness to explore, adapt, and grow with us as we integrate AI responsibly and effectively into our work.Additionally, 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.
Similar Jobs at CDW
Information Technology
Provides reactive, case-based support for Microsoft core infrastructure across multiple customer environments. Troubleshoots Windows Server, Active Directory, domain controllers, Group Policy, DNS, DHCP, SCCM, endpoint management, and related technologies. Manages service cases, documents resolutions, communicates with customers, meets service-level commitments, participates in on-call rotations, supports infrastructure improvements, and collaborates with technical teams. Provides customer guidance, peer mentoring, technical documentation, and escalation support while identifying potential customer needs.
Top Skills:
Active DirectoryAzureDhcpDnsDomain ControllersEndpoint ManagementGroup PolicyMicrosoft 365SccmWindows Server
Information Technology
Build and support enterprise data ingestion, transformation, modeling, and integration solutions using Microsoft Fabric and Azure data services. Develop batch, API, file, database, and event-driven pipelines; create dimensional and curated data models; write and optimize SQL; resolve data-quality and pipeline issues; and support production workloads. Collaborate in Agile engineering processes using GitHub, Azure DevOps, CI/CD, code reviews, and reusable development standards.
Top Skills:
Azure Data FactoryAzure Data LakeAzure DevopsAzure Key VaultAzure Service BusAzure SqlAzure StorageCi/CdDelta LakeGitGitJSONMicrosoft FabricPysparkPythonRest ApisSQLSQL Server
Information Technology
Drives Red Hat partner growth across Federal, state and local government, and education markets. Responsibilities include developing sales pipelines, optimizing opportunities, enabling sales teams, managing partner and customer relationships, influencing enterprise stakeholders, supporting major transaction cycles, coordinating agreements, identifying market trends, presenting solutions, and creating go-to-market plans. The hybrid role requires working from the downtown Chicago office at least twice weekly and up to 40% travel.
Top Skills:
Red Hat
What you need to know about the Seattle Tech Scene
Home to tech titans like Microsoft and Amazon, Seattle punches far above its weight in innovation. But its surrounding mountains, sprinkled with world-famous hiking trails and climbing routes, make the city a destination for outdoorsy types as well. Established as a logging town before shifting to shipbuilding and logistics, the Emerald City is now known for its contributions to aerospace, software, biotech and cloud computing. And its status as a thriving tech ecosystem is attracting out-of-town companies looking to establish new tech and engineering hubs.
Key Facts About Seattle Tech
- Number of Tech Workers: 287,000; 13% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Amazon, Microsoft, Meta, Google
- Key Industries: Artificial intelligence, cloud computing, software, biotechnology, game development
- Funding Landscape: $3.1 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Madrona, Fuse, Tola, Maveron
- Research Centers and Universities: University of Washington, Seattle University, Seattle Pacific University, Allen Institute for Brain Science, Bill & Melinda Gates Foundation, Seattle Children’s Research Institute
