You will manage and optimize Snowflake architecture and data security protocols.
Responsibilities
Review and implement improvements for Snowflake architecture, including virtual warehouse configurations, storage-compute separation, and performance tuning.
Implement BDM for new business users and facilitate the onboarding process.
Design and optimize advanced SQL queries for speed and scalability across large datasets.
Enforce Snowflake security protocols, including role-based access control, encryption, data masking, and compliance standards.
Monitor costs through dashboards and reports, and build data quality monitoring dashboards to identify and address missing, delayed, malformed, or duplicate events.
Required Skills
5+ years of experience in data administration roles.
Expertise in Snowflake architecture and management.
Advanced SQL query design and optimization.
Experience with performance tuning strategies.
Knowledge of role-based access control (RBAC) and data masking.
Ability to build monitoring dashboards for cost and data quality.