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

• 14000+ engaged teammates globally

• $8.2 billion in revenue in 2025

• Placed on Newsweek’s America’s Greatest Workplaces for 2025

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!

Insight does not accept unsolicited resumes from recruiters or employment agencies. Unsolicited resumes will be treated as direct applications from the candidate and recruiters or agencies who submit candidates for this position without a prior written vendor agreement will not be eligible for any form of compensation even if the candidate is hired.

Compensation Range - Base Salary: $150000 – $165000 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 - ChandlerAZ ||