Snowflake Administrator at Bayforce | Torre

Snowflake Administrator

Emma highlights
This highlight was written by Emma’s AI. Ask Emma to edit it.
Full-time
Provide your expected compensation while applying
location_on
Remote (anywhere)
Posted 9 months ago

Responsibilities


About the job We are seeking a proactive Snowflake Administrator to manage and optimize our Snowflake data platform. This hands-on role focuses on ensuring the reliability, performance, and security of data pipelines while supporting the broader data team. Strong SQL skills and the ability to work effectively with data models and warehousing concepts are essential. Key responsibilities * Manage Snowflake administration tasks, including users, roles, RBAC, and security policies. * Monitor and optimize virtual warehouses, queries, and storage to ensure performance and cost efficiency. * Oversee data ingestion from multiple sources, ensuring reliability and data integrity. * Build and maintain dbt models to support data transformations and reporting needs. * Maintain databases, schemas, views, and other Snowflake objects. * Analyze, tune, and optimize complex SQL queries. * Act as the primary point of contact for Snowflake-related support and troubleshooting. * Stay current with Snowflake features and best practices to continuously improve the data stack. Required skills and qualifications * Proven experience administering Snowflake. * Strong SQL skills, including writing, debugging, and optimizing complex queries. * Hands-on experience creating and maintaining dbt models. * Solid understanding of data warehousing concepts, database architecture, and ELT processes. * Experience with core administrative tasks such as user management, RBAC, and resource monitoring. Preferred qualifications * SnowPro Core certification. * Experience using Python (3.10/3.11) for scripting, UDFs, or Snowpark. * Experience with data integration tools such as Qlik Replicate or Airbyte. * Familiarity with major cloud platforms, including AWS, Azure, or GCP.