Consulting Data Architect - Snowflake

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.