Role : Snowflake Administrator
The following information provides an overview of the skills, qualities, and qualifications needed for this role.
Duration : 12 Months
Location : Boston, MA
Interview type : Webcam Interview Only
If you are interested in working on W2, please share your resume at [email protected].
Complete Description : 9+ years of experience required
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 with organizational policies.
- 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 ensure data integrity and availability.
- Troubleshooting and Support : Provide technical support and troubleshooting for Snowflake-related issues, including resolving performance bottlenecks and query optimization.
- Documentation and Reporting : Maintain detailed documentation of system configurations, procedures, 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 performance of the Snowflake environment.
- Best Practices : Stay up to date with Snowflake best practices and industry trends. Recommend and implement improvements and upgrades to enhance system functionality and performance.
- Security : Ensure the platform is up to date on system patches. Monitor, apply, and test product security updates.
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 in 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 hands-on experience as a Snowflake Administrator.
- Ability to identify and drive continuous improvements.
- Strong problem-solving and analytical skills.
- Strong SQL skills.
- Knowledge of Snowflake security features including access control, authentication, authorization, encryption, masking, secure view, etc.
- Experience in scripting languages such as PowerShell and Python.
- Experience working in AWS cloud environments.
- Experience integrating Snowflake with an identity and access management program such as Azure IDP is a plus.
- Experience working with Power BI and other BI, data visualization, and reporting tools.
- Strong database design and data modeling experience.
- Business requirement gathering and aligning to solutions delivery.
- Experience with other relational database management systems, cloud data warehouses, and big data platforms is a plus.
- Experience with data integration solutions and tools, data pipelines, and modern ways of automating data using cloud-based and on-premises technologies.
- Analytical Skills : Excellent problem-solving and analytical skills with a strong attention to detail.
- Communication : Effective communication skills, both written and verbal, with the ability to convey complex technical information to non-technical stakeholders.
- Teamwork : Ability to work independently and collaboratively in a fast-paced environment.
Preferred Skills :
- Snowflake certification (e.g., SnowPro Core or Advanced Certification).
- Experience with data visualization tools (e.g., Power BI).
- Knowledge of technical areas such as T-SQL, DevOps, and scripting.
J-18808-Ljbffr
1 day ago