Snowflake Data Architect: AI-Driven Data Solutions Lead

CDW; United States; Remote; USD 128,000 - 193,000; Full time

Benefits offered by this job

Benefits overview

Job summary

CDW is seeking a Consulting Data Architect – Snowflake to design and deliver Snowflake architectures on AWS, using dbt and AI patterns for production-ready solutions. You will lead cross-functional teams, develop reusable patterns, and drive client engagements with rigorous QA and governance.

The role emphasizes data engineering, data modeling, and analytics delivery across regulated industries, with travel to client sites as needed. A strong background in Snowflake, SQL, and AWS is essential.

Qualifications

• Bachelor’s degree and 7+ years’ professional experience with relational data models, databases, data engineering, ingestion, transformation, and analytics delivery OR 11+ years’ professional experience.
• Strong experience with Snowflake, DBT, AWS, and SQL, including data transformation, cleansing, preparation, and performance-minded development.
• Experience developing datasets that support ad-hoc analytical needs, reporting, and marketing or business stakeholder insight generation.
• Experience working in highly regulated industries and complying with internal governance, data privacy, and data quality requirements.
• Preferred experience includes healthcare data, marketing data, and a bachelor’s degree in IT, software engineering, data engineering, or a related field.
• Implements, maintains, upgrades, and troubleshoots S&S solutions; transferring technical skills and knowledge to client through work logs.
• Performs overall solution Quality Assurance (QA) tasks for all projects delivered against assigned project deliverables while ensuring they are in alignment with the project scope and SOW (Statement of Work).
• Provides implementation/migration planning to client, knowing and meeting client timetable, coordinating vendor installations, etc.
• Facilitates communication between product team members.
• Strong written and verbal communication skills with the ability to effectively interact with leadership stakeholders and clients.
• Proven ability to maintain and create technical documentation for assigned project work.
• Demonstrated attention to detail, especially client and project changes, with solid analytical skills to identify potential risks.
• History of balancing competing priorities with the ability to adapt to the changing needs of the business while meeting deadlines.
• Demonstrated experience applying lessons learned to unique problems.
• History of reskilling on new technologies with understanding of difference with past technologies.
• Ability and willingness to travel as needed to other CDW locations or client sites.

Responsibilities

• Design and deliver Snowflake architectures deployed on AWS, leveraging dbt and Generative AI solution patterns.
• Build and validate proofs of concept, prototypes, reusable accelerators, reference architectures, and implementation templates that help move data and AI solutions from concept to production-ready outcomes.
• Lead project teams, directing coworker and client teams in solution design and development.
• Provide leadership in creating business cases, financial justification and solution benefit content for customer ready deliverables and presentations.
• Aggregate oversight of technical solutions across multiple projects to ensure synergy in our approach and broad visibility to the solutions delivery team.
• Proactively address or escalating any budget issues that are identified during the project.
• Quality assurance for SOW requests that meet triggers for size, cross brand, and complexity.
• Perform peer review of deliverables from other team members for technical content to ensure accuracy.
• Maintain client relationships as a trusted Technical Advisor.
• Serve as focal point for communications between multiple departments and clients, using experience and judgment to communicate effectively to all parties.
• Recommend solutions supporting client account teams with development of proposals, quotations, and presentations.
• Lead development of practical AI-enabled solution patterns, including retrieval-augmented generation, vector search, embedding pipelines, prompt orchestration, semantic search, and AI-enabled analytics workflows.

Skills

Snowflake

AWS

SQL

dbt

Generative AI

Data modeling

Data engineering

Analytics delivery

Leadership

Education

Bachelor’s degree (IT/Software/Data Eng)

Tools

Snowflake

AWS

SQL

dbt

Job description

CDW is seeking a Consulting Data Architect – Snowflake to design and deliver Snowflake architectures on AWS, using dbt and AI patterns for production-ready solutions. You will lead cross-functional teams, develop reusable patterns, and drive client engagements with rigorous QA and governance.

The role emphasizes data engineering, data modeling, and analytics delivery across regulated industries, with travel to client sites as needed. A strong background in Snowflake, SQL, and AWS is essential.