Snowflake Architect
Requisition Number: 103509
Data Solutions Architect – Snowflake & dbt
Location: You will have the flexibility to work fully remote from anywhere across the US.
Insight at a Glance
14,000+ engaged teammates globally Received 35+ industry and partner awards in the past year
Now is the time to bring your expertise to Insight. We are not just a tech company; we are a people-first company. We believe that by unlocking the power of people and technology, we can accelerate transformation and achieve extraordinary results. As a Fortune 500 Solutions Integrator with deep expertise in cloud, data, AI, cybersecurity, and intelligent edge, we guide organizations through complex digital decisions.
About the role
We are expanding our Data & AI Business Unit and are seeking a Data Solutions Architect with deep expertise in Snowflake and dbt to design and deliver modern, analytics first data platforms. This role focuses on building scalable, governed data solutions that enable trusted analytics, reporting, and downstream AI use cases.
You will serve as an architectural leader—owning solution design from discovery through delivery—while helping teams adopt best in class analytics engineering practices using Snowflake and dbt.
Responsibilities
Design and govern end to end data platforms built on Snowflake
Architect ELT pipelines using dbt for transformation, testing, and documentation
Define data modeling standards using dimensional, mart based, and semantic patterns
Design ingestion approaches from operational systems into Snowflake (batch and near real time)
Establish best practices for Snowflake performance, cost optimization, and security
Lead dbt project architecture, including model layering, environments, and CI/CD
Partner with analytics, BI, and data science teams to ensure consistent and trusted data outputs
Produce architecture diagrams, technical designs, and data modeling documentation
Act as a technical authority during architecture reviews, delivery planning, and design forums
Evaluate complementary tools in the modern data stack (orchestration, BI, quality, observability)
Required Skills & Experience
7+ years of experience in data engineering, analytics, or data architecture roles
Proven experience as a Data Solutions Architect, Analytics Architect, or Senior Analytics Engineer
Deep, hands on experience with Snowflake data architecture and optimization
Strong experience building transformation layers with dbt (Core or Cloud)
Expertise in dimensional modeling, analytics marts, and semantic data design
Strong SQL skills and experience designing reusable, tested transformation logic
Familiarity with cloud ecosystems (AWS, Azure, or GCP) supporting Snowflake workloads
Ability to communicate architectural decisions clearly to technical and business stakeholders
Experience working in cross functional or customer facing environments
Certifications
Snowflake SnowPro (Core or Advanced) preferred
dbt certifications or equivalent hands on experience strongly valued
Cloud platform certifications (AWS, Azure, GCP) a plus
Travel & Work Environment
Hybrid or remote work environment (US based)
Occasional travel to support stakeholder or client engagements
Collaborative, fast paced environment emphasizing analytics quality, governance, and scale
What you can expect
We’re legendary for taking care of you, your family and to help you engage with your local community. We want you to enjoy a full, meaningful life and own your career at Insight.
Some of our benefits include:
Freedom to work from another location, even an international destination, for up to 30 consecutive calendar days per year.
Comprehensive benefits package including medical, dental, vision, and company 401k match.
But what really sets us apart are our core values of Hunger, Heart, and Harmony, which guide everything we do, from building relationships with teammates, partners, and clients to making a positive impact in our communities.
Join us today, your ambITious journey starts here.
When you apply, please tell us the pronouns you use and any reasonable adjustments you may need during the interview process.
At Insight, we celebrate diversity of skills and experience so even if you don’t feel like your skills are a perfect match - we still want to hear from you!
Compensation Range - Base Salary: $145,000 – $160,000, depending on experience
The position described above provides a summary of some the job duties required and what it would be like to work at Insight. For a comprehensive list of physical demands and work environment for this position, click here.
Insight is an equal opportunity employer, and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability status, protected veteran status, sexual orientation or any other characteristic protected by law.
Posting Notes: Chandler || Arizona (US-AZ) || United States (US) || IT Infrastructure & Support || None || US - Chandler,AZ ||
About the job
Apply for this position
Snowflake Architect
Requisition Number: 103509
Data Solutions Architect – Snowflake & dbt
Location: You will have the flexibility to work fully remote from anywhere across the US.
Insight at a Glance
14,000+ engaged teammates globally Received 35+ industry and partner awards in the past year
Now is the time to bring your expertise to Insight. We are not just a tech company; we are a people-first company. We believe that by unlocking the power of people and technology, we can accelerate transformation and achieve extraordinary results. As a Fortune 500 Solutions Integrator with deep expertise in cloud, data, AI, cybersecurity, and intelligent edge, we guide organizations through complex digital decisions.
About the role
We are expanding our Data & AI Business Unit and are seeking a Data Solutions Architect with deep expertise in Snowflake and dbt to design and deliver modern, analytics first data platforms. This role focuses on building scalable, governed data solutions that enable trusted analytics, reporting, and downstream AI use cases.
You will serve as an architectural leader—owning solution design from discovery through delivery—while helping teams adopt best in class analytics engineering practices using Snowflake and dbt.
Responsibilities
Design and govern end to end data platforms built on Snowflake
Architect ELT pipelines using dbt for transformation, testing, and documentation
Define data modeling standards using dimensional, mart based, and semantic patterns
Design ingestion approaches from operational systems into Snowflake (batch and near real time)
Establish best practices for Snowflake performance, cost optimization, and security
Lead dbt project architecture, including model layering, environments, and CI/CD
Partner with analytics, BI, and data science teams to ensure consistent and trusted data outputs
Produce architecture diagrams, technical designs, and data modeling documentation
Act as a technical authority during architecture reviews, delivery planning, and design forums
Evaluate complementary tools in the modern data stack (orchestration, BI, quality, observability)
Required Skills & Experience
7+ years of experience in data engineering, analytics, or data architecture roles
Proven experience as a Data Solutions Architect, Analytics Architect, or Senior Analytics Engineer
Deep, hands on experience with Snowflake data architecture and optimization
Strong experience building transformation layers with dbt (Core or Cloud)
Expertise in dimensional modeling, analytics marts, and semantic data design
Strong SQL skills and experience designing reusable, tested transformation logic
Familiarity with cloud ecosystems (AWS, Azure, or GCP) supporting Snowflake workloads
Ability to communicate architectural decisions clearly to technical and business stakeholders
Experience working in cross functional or customer facing environments
Certifications
Snowflake SnowPro (Core or Advanced) preferred
dbt certifications or equivalent hands on experience strongly valued
Cloud platform certifications (AWS, Azure, GCP) a plus
Travel & Work Environment
Hybrid or remote work environment (US based)
Occasional travel to support stakeholder or client engagements
Collaborative, fast paced environment emphasizing analytics quality, governance, and scale
What you can expect
We’re legendary for taking care of you, your family and to help you engage with your local community. We want you to enjoy a full, meaningful life and own your career at Insight.
Some of our benefits include:
Freedom to work from another location, even an international destination, for up to 30 consecutive calendar days per year.
Comprehensive benefits package including medical, dental, vision, and company 401k match.
But what really sets us apart are our core values of Hunger, Heart, and Harmony, which guide everything we do, from building relationships with teammates, partners, and clients to making a positive impact in our communities.
Join us today, your ambITious journey starts here.
When you apply, please tell us the pronouns you use and any reasonable adjustments you may need during the interview process.
At Insight, we celebrate diversity of skills and experience so even if you don’t feel like your skills are a perfect match - we still want to hear from you!
Compensation Range - Base Salary: $145,000 – $160,000, depending on experience
The position described above provides a summary of some the job duties required and what it would be like to work at Insight. For a comprehensive list of physical demands and work environment for this position, click here.
Insight is an equal opportunity employer, and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability status, protected veteran status, sexual orientation or any other characteristic protected by law.
Posting Notes: Chandler || Arizona (US-AZ) || United States (US) || IT Infrastructure & Support || None || US - Chandler,AZ ||