– Manage and monitor our Commercial self-service Snowflake database
– Monitor existing pipeline ingestions (Dynamic tables) from centralized usable layer and implement pipeline enhancements
– Performance tuning of Snowflake database to ensure optimal warehousing, speed, etc.
– Create and implement code changes processes between Dev and Prod environments
– Work with solution team members to put in infrastructure changes needed for new downstream solutions and offerings
– Collaborate with data management team members to ensure optimal data quality
– Manage/document downstream dependencies from other teams using data mart
– Liaison between our team and Enterprise IT (through service tickets & relationships)
– Create standard processes/documentation around security/access, data quality thresholds, and data availability
– Create new Data Mart data sets for reporting where it isn't possible/efficient in Power BI
• Key requirements
– SnowPro Core Certified would be necessary, SnowPro Advanced would be ideal
– Advanced SQL knowledge
– Familiarity with ADF (Azure Data Factory) a plus
– Previous Snowflake database management experience
Job Benefits: