Verified Job
IT / Software / Data Analyst
dotSolved - Snowflake Administrator/Engineer
IT / Software / Data Analyst
#647335
Remote / WFH
Job Description
We are looking for a hands-on, senior Snowflake expert who has both administrative and development experience in managing, securing, and optimizing large-scale Snowflake instances.
The ideal candidate will be responsible for overseeing our Snowflake SaaS instance (purchased through AWS), integrating with tools such as Prefect, dbt, and Python-based data pipelines, and ensuring operational excellence, cost efficiency, and compliance.
Key Responsibilities
Snowflake Administration :
• Manage and maintain the Snowflake SaaS environment, including user roles, security, data sharing, and integrations.
• Monitor system performance and proactively tune configurations for optimal performance and cost efficiency.
• Administer Snowflake features such as SnowSQL, Snowpipe, and Tasks/Streams.
• Oversee data ingestion and transformation pipelines within Snowflake.
• Configure and manage SSO (Single Sign-On) and IAM integrations with AWS.
Security, Governance & Compliance
• Implement best practices for data access controls, encryption, governance, and auditing.
• Define and enforce policies around data privacy, masking, and secure data sharing.
• Collaborate with IT and InfoSec teams to ensure compliance with internal and external security standards.Integrations & Automation
• Maintain integrations with Prefect, dbt, and Python-based workflows.
• Automate Snowflake administrative tasks (e.g., user provisioning, warehouse scaling, monitoring).
• Collaborate with developers and analysts to ensure seamless data operations across the stack.
Cost Optimization & Performance
• Monitor credit usage and identify opportunities to reduce compute and storage costs.
• Analyze query patterns and workloads to optimize warehouse sizing and caching strategies.
• Provide ongoing insights and reporting on usage metrics and efficiency improvements.
Development & Support
• Support data engineers and analysts with SQL development, schema design, and performance tuning.
• Troubleshoot and resolve Snowflake-related issues in data pipelines.
• Contribute to architecture improvements and adoption of new Snowflake capabilities.
Requirements : Required :
• Senior-level professional with solid, proven industry experience in Snowflake administration and engineering.
• Deep expertise in SnowSQL, Snowpipe, Tasks, Streams, Roles, and Resource Monitors.
• Experience with AWS ecosystem (IAM, S3, Glue, etc.) and Snowflake deployment via AWS Marketplace.
• Proficiency in SQL, Python, and dbt.
• Experience managing SSO integration and identity management for Snowflake.
• Familiarity with Prefect, Airflow, or similar orchestration tools.Strong understanding of data governance, security controls, and cost management in Snowflake.
Preferred
• Experience with CI/CD for data pipelines.
• Experience with other AWS services and integration services with snowflake.
• SnowPro Core or Advanced certification.
Soft Skills
• Strong problem-solving and analytical mindset.
• Excellent communication skills (English proficiency required).
• Self-starter, able to work independently across time zones.
• Collaborative and documentation-oriented approach.
The ideal candidate will be responsible for overseeing our Snowflake SaaS instance (purchased through AWS), integrating with tools such as Prefect, dbt, and Python-based data pipelines, and ensuring operational excellence, cost efficiency, and compliance.
Key Responsibilities
Snowflake Administration :
• Manage and maintain the Snowflake SaaS environment, including user roles, security, data sharing, and integrations.
• Monitor system performance and proactively tune configurations for optimal performance and cost efficiency.
• Administer Snowflake features such as SnowSQL, Snowpipe, and Tasks/Streams.
• Oversee data ingestion and transformation pipelines within Snowflake.
• Configure and manage SSO (Single Sign-On) and IAM integrations with AWS.
Security, Governance & Compliance
• Implement best practices for data access controls, encryption, governance, and auditing.
• Define and enforce policies around data privacy, masking, and secure data sharing.
• Collaborate with IT and InfoSec teams to ensure compliance with internal and external security standards.Integrations & Automation
• Maintain integrations with Prefect, dbt, and Python-based workflows.
• Automate Snowflake administrative tasks (e.g., user provisioning, warehouse scaling, monitoring).
• Collaborate with developers and analysts to ensure seamless data operations across the stack.
Cost Optimization & Performance
• Monitor credit usage and identify opportunities to reduce compute and storage costs.
• Analyze query patterns and workloads to optimize warehouse sizing and caching strategies.
• Provide ongoing insights and reporting on usage metrics and efficiency improvements.
Development & Support
• Support data engineers and analysts with SQL development, schema design, and performance tuning.
• Troubleshoot and resolve Snowflake-related issues in data pipelines.
• Contribute to architecture improvements and adoption of new Snowflake capabilities.
Requirements : Required :
• Senior-level professional with solid, proven industry experience in Snowflake administration and engineering.
• Deep expertise in SnowSQL, Snowpipe, Tasks, Streams, Roles, and Resource Monitors.
• Experience with AWS ecosystem (IAM, S3, Glue, etc.) and Snowflake deployment via AWS Marketplace.
• Proficiency in SQL, Python, and dbt.
• Experience managing SSO integration and identity management for Snowflake.
• Familiarity with Prefect, Airflow, or similar orchestration tools.Strong understanding of data governance, security controls, and cost management in Snowflake.
Preferred
• Experience with CI/CD for data pipelines.
• Experience with other AWS services and integration services with snowflake.
• SnowPro Core or Advanced certification.
Soft Skills
• Strong problem-solving and analytical mindset.
• Excellent communication skills (English proficiency required).
• Self-starter, able to work independently across time zones.
• Collaborative and documentation-oriented approach.
