Solution Architect (Snowflake)

Job Title: Solution Architect (Snowflake) Location: Hybrid – 3 days in Dublin, CA Duration: 6+ Months CTH Interview Process: Video Responsibility • 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 (Sridhar and Sirisha) • 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 to 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 Must Have: • Senior Level – potential to go to a principal level in the future (Groom them, take them to a principal level), Snowflake and Azure expertise • 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