Solutions Architect - Data

• Trying to enable Snowflake as our target data platform • Currently migrating from Netezza to Snowflake – lift and shift • 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 Overvie • w Provide guidance and best practices – platform, business dashboard creation, working with any new project between IT, Data, and M • SIBusiness outcomes – the idea with SVT, bring all of our business domain data into one pla • ceWrite use cases for the busine • ssCreating Business dashboar • ds“Modelizing” all of that stuff for the busine • ssWill be a part of EVERY Data and Analytics project across the o • rgNeeds to understand security aspects, HOW does Snowflake do thi • s?Working closely with Stakeholde • rsShould be part of the design from the very start – understanding how Snowflake does X • YZWorking closely with the SI partner and architec tsTop Requirements (Must haves • ) Senior Level – potential to go to a principal level in the future (Groom them, take them to a principal leve • l)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 POC • s)Features or Patterns – MUST Understand Medallion Architecture – HOW do you model, HOW to structure the data (ex: Customer Loyalty Program, HR Da • taMORE than just technical experience – good attitude, good comms, driving conversations to convince people of their advice, designs, POCs, et • c.Retail is nice to have but not a hard requireme ntAdditional 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, et • c.Future – chatbot queries, AI use cases for futu re