Sign up to save this job, get alerts, and apply with an optimized CV.
Snowflake Administrator / Engineer
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:
Integrations & Automation:
Development & Support
RequirementsQualifications Required:
Preferred:
Soft Skills
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.
RequirementsQualifications 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.
Required skills
Sign up to apply
Create a free account to apply for this job and get access to:
- AI-powered CV optimization for this specific job
- Save jobs and create custom alerts
- See your CV match score for each job
Company information
- Company
- dotSolved System Inc.
- Location
-
India, Tamil Nadu, Chennai, Ekkaduthangal
India - Posted
- 9 months ago
Interested in this position?
Create your free account and tailor your CV to match this job.