Solutions Architect

Trident Consulting is looking for a "Snowflake Solution Architect" @ Dublin, CA (Hybrid - onsite)” for one of our clients. Job Role: Snowflake Solution Architect Location: Dublin, CA (Hybrid - onsite) – Locals only Contract Type: Only W2 Rate Card: $75- 80/hr on W2 Job Description: Project Description: MUST Understand Medallion Architecture SVT – Single Version of Truth • Trying to enable Snowflake as our target data platform • Currently migrating from Netezza to Snowflake – lift and shift • SVT is a new Medallion • 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), Micro Strategy Power BI, 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 About Trident Consulting: Trident Consulting is an award-winning staffing and consulting firm headquartered in San Ramon, CA. Since 2005, we’ve partnered with Fortune 500 and high-growth companies to deliver high-quality talent across technology, engineering, business operations, and professional services. We specialize in contract, contract-to-hire, and direct hire placements, supporting roles across IT, data & analytics, cloud, cybersecurity, finance & accounting, HR, operations, and more. With a strong focus on hard-to-fill and niche positions, our global recruiting engine enables us to deliver speed, quality, and scale.