Consulting AI-Driven Snowflake Data Architect

Socket.dev; Illinois; On-site; USD 128,000 - 193,000; Full time

Benefits offered by this job

Annual bonus 10%

Benefits portal

Job summary

CDW is seeking a Consulting Data Architect – Snowflake to design architectures on AWS using Snowflake, dbt, and AI-enabled analytics patterns. You will lead AI-driven solution design and build PoCs, reference architectures, and reusable accelerators for production-ready outcomes.

You will guide project teams, develop business cases, and maintain cross-functional communications with clients, ensuring governance and data quality throughout engagements.

Qualifications

• 7+ years with relational data models, databases, data engineering, ingestion, transformation, and analytics delivery OR 11+ years in the same areas.
• 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 stakeholder insight generation.

Responsibilities

• Design and deliver Snowflake architectures deployed on AWS that leverage dbt Generative AI solution patterns.
• Lead development of AI-enabled solution patterns, including retrieval-augmented generation and semantic search.
• Build proofs of concept, reference architectures, and implementation templates for production-ready outcomes.

Skills

Snowflake

DBT

AWS

SQL

Relational data modeling

Education

Bachelor's degree in IT, software engineering, data engineering, or related field

Tools

Snowflake

DBT

AWS

SQL

Job description

CDW is seeking a Consulting Data Architect – Snowflake to design architectures on AWS using Snowflake, dbt, and AI-enabled analytics patterns. You will lead AI-driven solution design and build PoCs, reference architectures, and reusable accelerators for production-ready outcomes.

You will guide project teams, develop business cases, and maintain cross-functional communications with clients, ensuring governance and data quality throughout engagements.