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
Job Summary:
The Consulting Data Architect - Snowflake makes innovative contributions to new solution/product design and implementation, based on understanding of applicable technology and how it can be applied to solution design, considerations of system-wide impact and business issues for clients. Provides technical expertise in analyzing client's requirements to develop services offerings across multiple technology solutions that provide significant value. This role also supports data engineering delivery by designing, ingesting, transforming, validating, and documenting analytics data solutions, including medallion-style data marts that combine multiple data sources into trusted models for reporting and actionable business insights.
What you will do:
* Design and deliver Snowflake architectures deployed on AWS that leverage dbt Generative AI solution patterns.
* 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.
* 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 addresses or escalates 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, when necessary, using experience and judgment to communicate effectively to all parties. Recommend solutions supporting client account teams with development of proposals, quotations, and presentations.
What we expect of you:
* 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 with relational data models, databases, data engineering, ingestion, transformation, and analytics delivery
* 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. 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.
Job Summary:
The Consulting Data Architect - Snowflake makes innovative contributions to new solution/product design and implementation, based on understanding of applicable technology and how it can be applied to solution design, considerations of system-wide impact and business issues for clients. Provides technical expertise in analyzing client's requirements to develop services offerings across multiple technology solutions that provide significant value. This role also supports data engineering delivery by designing, ingesting, transforming, validating, and documenting analytics data solutions, including medallion-style data marts that combine multiple data sources into trusted models for reporting and actionable business insights.
What you will do:
* Design and deliver Snowflake architectures deployed on AWS that leverage dbt Generative AI solution patterns.
* 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.
* 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 addresses or escalates 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, when necessary, using experience and judgment to communicate effectively to all parties. Recommend solutions supporting client account teams with development of proposals, quotations, and presentations.
What we expect of you:
* 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 with relational data models, databases, data engineering, ingestion, transformation, and analytics delivery
* 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. 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
Provide customer-facing Microsoft infrastructure support in a case-based break/fix environment. Troubleshoot and resolve Azure, Microsoft 365, Windows Server, and related technology issues; manage cases, document resolutions, meet SLAs, collaborate with peers and Microsoft support, and participate in on-call coverage. The role also involves customer communication, technical documentation, mentoring, training, and identifying potential customer needs.
Top Skills:
Active DirectoryIntuneMicrosoft 365AzureMicrosoft SupportSccmWindows Server
Information Technology
Develops and positions NetApp-based storage, data management, cyber resiliency, hybrid cloud, and AI infrastructure solutions in a national technical pre-sales role. Responsibilities include requirements discovery, solution architecture, proposals, bills of material, statements of work, services scoping, technical leadership, partner collaboration, customer advising, field enablement, mentoring, and strategic opportunity support. The role also creates reusable architectures and represents CDW in customer, partner, and industry engagements.
Top Skills:
Ai InfrastructureCloud StorageContainersCyber ResiliencyData ProtectionHybrid CloudNetappOntapVirtualization
Information Technology
Develops and presents hybrid infrastructure solutions for federal and state/local government customers. Responsibilities include technical pre-sales consulting, solution architecture, assessments, service scoping, configurations and bills of materials, statements of work, sales strategy, customer and partner relationship management, and technical enablement. The role requires expertise across servers, storage, backup, virtualization, cloud, and AI technologies, along with mentoring other solution architects and traveling up to 25%.
Top Skills:
Artificial IntelligenceBackupCloud ComputingServersStorageVirtualization
What you need to know about the Charlotte Tech Scene
Ranked among the hottest tech cities in 2024 by CompTIA, Charlotte is quickly cementing its place as a major U.S. tech hub. Home to more than 90,000 tech workers, the city’s ecosystem is primed for continued growth, fueled by billions in annual funding from heavyweights like Microsoft and RevTech Labs, which has created thousands of fintech jobs and made the city a go-to for tech pros looking for their next big opportunity.
Key Facts About Charlotte Tech
- Number of Tech Workers: 90,859; 6.5% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Lowe’s, Bank of America, TIAA, Microsoft, Honeywell
- Key Industries: Fintech, artificial intelligence, cybersecurity, cloud computing, e-commerce
- Funding Landscape: $3.1 billion in venture capital funding in 2024 (CED)
- Notable Investors: Microsoft, Google, Falfurrias Management Partners, RevTech Labs Foundation
- Research Centers and Universities: University of North Carolina at Charlotte, Northeastern University, North Carolina Research Campus
