What are the responsibilities and job description for the Snowflake Administrator position at Acro Service Corp?
Job Title: Snowflake Administrator
Duration: 12 Months (with possible renewable)
Location: Boston, MA 02116 - HYBRID (must reside in MA/NH/RI)
JOB DESCRIPTION:
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 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 platform is up to date on System patches. Monitor, apply and test product security updates
Qualifications:
• Experience: 8 years of hands-on experience in managing and administering Snowflake environments. Experience with other cloud-based data platforms is a plus.
Required Skills:
o Strong proficiency in Snowflake architecture, features, and capabilities.
o Knowledge of SQL and Snowflake-specific query optimization.
o Experience with ETL tools and data integration processes.
o 2 years of hands-on experience as a Snowflake Administrator
o Ability to identify and drive continuous improvements
o Strong problem solving and analytical skills
o Strong SQL skills
o Knowledge of Snowflake security features including access control, authentication, authorization, encryption, masking, secure view, etc.
o Experience in scripting languages such as PowerShell and Python
o Experience working in AWS cloud environments
o Experience integrating Snowflake with an identity and access management program such as Azure IDP is a plus
o Experience working with Power BI and other BI, data visualization, and reporting tools
o Strong Database design and data modelling experience
o Business requirement gathering and aligning to solutions delivery
o Experience with other relational database management systems, cloud data warehouses and big data platforms is a plus
o 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
Salary : $70 - $82
