Job Title : Snowflake Administrator
Duration : 12 months
Location : Boston, MA (Hybrid)
Job Summary :
We are seeking a highly skilled and motivated Snowflake Administrator to join our team. The ideal candidate will be responsible for the administration, configuration, and maintenance of our Snowflake data warehouse environment.
This role requires expertise in Snowflake's features, best practices, and strong problem-solving abilities. The position also involves collaborating with cross-functional teams to ensure the efficient operation of the Snowflake platform.
Key Responsibilities :
- Snowflake Environment Management : Administer and manage Snowflake data warehouse environments, including setup, configuration, monitoring, and optimization.
- Performance Tuning : Monitor and optimize performance, including query performance, resource utilization, and storage management.
- User and Access Management : Manage user access, roles, and permissions to ensure data security and compliance.
- Data Integration : Support and manage data integration processes, including data loading, transformation, and extraction.
- Backup and Recovery : Implement and oversee backup and recovery strategies to maintain data integrity and availability.
- Troubleshooting and Support : Provide technical support for Snowflake-related issues, including resolving performance bottlenecks and optimizing queries.
- Documentation and Reporting : Maintain detailed documentation of system configurations and changes. Generate and deliver regular reports on system performance and usage.
- Collaboration : Work closely with data engineers, analysts, and other IT professionals to ensure seamless integration and optimal Snowflake performance.
- Best Practices : Stay updated on Snowflake best practices and industry trends, recommending improvements and upgrades.
- Security : Monitor, apply, and test product security updates, ensuring the platform remains secure and up to date.
Qualifications :
- Education : Bachelor's degree in Computer Science, Information Technology, Data Science, or a related field. Relevant certifications are a plus.
- Experience : 3+ years of hands-on experience managing and administering Snowflake environments. Experience with other cloud-based data platforms is a plus.
Required Skills :
- Strong proficiency in Snowflake architecture, features, and capabilities.
- Knowledge of SQL and Snowflake-specific query optimization.
- Experience with ETL tools and data integration processes.
- 3+ years of experience as a Snowflake Administrator.
- Strong problem-solving and analytical skills.
- Expertise in Snowflake security features (access control, authentication, authorization, encryption, etc.).
- Scripting experience (PowerShell, Python).
- Experience working in AWS cloud environments.
- Knowledge of identity and access management integration (Azure IDP is a plus).
- Experience with Power BI and other data visualization and reporting tools.
- Strong database design and data modeling skills.
- Experience with business requirement gathering and solutions delivery.
- Familiarity with other RDBMS, cloud data warehouses, and big data platforms is a plus.
- Knowledge of data integration tools, data pipelines, and modern automation technologies.
Preferred Skills :
- Snowflake certification (e.g., SnowPro Core or Advanced Certification).
- Experience with data visualization tools such as Power BI.
- Knowledge of T-SQL, DevOps, and scripting.
11 days ago