Technology

Solutions Architect/Data Architect W2 Role

IntelliTask LLCDublin, CA🇺🇸United StatesPosted Oct 17, 2026

Why This Role Stands Out

This hybrid role offers a fantastic opportunity to shape a company's data platform strategy, leveraging your expertise in Snowflake and data architecture to drive critical business outcomes. You'll thrive here if you're a senior-level architect eager to mentor, innovate, and have a significant impact on every data project within the organization. Apply now to be at the forefront of this exciting data transformation!

Quick Overview

Seniority

Mid Senior

Work mode

On Site

Location

Dublin, CA, United States

Posted

Yesterday

SQLSnowflakePythondbt

Job Description

Role: Solutions Architect/Data Architect

Duration: 6-12 months contract to Hire

Location: Tue – Thur onsite in Dublin, CA – hybrid

Project Description

Trying to enable Snowflake as our target data platform

Currently migrating from Netezza to Snowflake – lift and shift

SVT is a new Medallion (SOMETHING)

IT is responsible for landing the data

MSI team is responsible for defining the data model, transforming data from the landing to the defined zone and published zone and building

DBT (Transformation), MicroStrategy PowerBI, SQL DBM, Data Modeling, Defining

Currently using StreamSets for ingestion

Alation for Data Governance (nice to have)

Point is to start building with a NEW, correct framework for SVT

Duties/Day to Day Overview

Provide guidance and best practices – platform, business dashboard creation, working with any new project between IT, Data, and MSI

Business outcomes – the idea with SVT, bring all of our business domain data into one place

Write use cases for the business

Creating Business dashboards

“Modelizing” all of that stuff for the business

Will be a part of EVERY Data and Analytics project across the org

Needs to understand security aspects, HOW does Snowflake do this?

Working closely with Stakeholders

Should be part of the design from the very start – understanding how Snowflake does XYZ

Working closely with the SI partner and architects

Top Requirements

Senior Level – potential to go to a principal level in the future (Groom them, take them to a principal level)

Some hands on to do quick POCs – give options, build quick – PYTHON development experience (Architect level, give guidance, understand and read code, do some quick POCs)

Features or Patterns – MUST Understand Medallion Architecture – HOW do you model, HOW to structure the data (ex: Customer Loyalty Program, HR Data

MORE than just technical experience – good attitude, good comms, driving conversations to convince people of their advice, designs, POCs, etc.

Retail is nice to have but not a hard requirement

Technical Requirements

Emphasized the need for a solution architect with a solid Snowflake background, but also experience with data ingestion (e.g., StreamSets), CDC, DBT, and an understanding of dashboard/reporting enablement. 5

Highlighted the importance of knowledge in Medallion architecture (landing, refined, published zones), data modeling, and structuring data for business use cases.

Stressed Snowflake security expertise, especially for handling sensitive data (e.g., loyalty and HR data), and the need to work closely with information security to ensure foundational security is built into the design. 7

Requested hands-on capability for quick POCs, not just theoretical knowledge, with Python development experience to guide and review code, and to support rapid prototyping.