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 ||