Solution Architect

• Trying to enable Snowflake as our target data platform
• Currently migrating from Netezza to Snowflake – lift and shift
• SVT is a new Medallion (SOMETHING)
• 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)

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 (Must haves)       

•                          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

Additional Qualifications (Nice to Haves)          

•                          We have an SI partner who is bringing in Architects already, this person is higher level, part of the design, road mapping, etc.

•                          Future – chatbot queries, AI use cases for future