Cloud Data Administrator

Veteran Firm Seeking a Snowflake Administrator for a Hybrid Assignment in Boston, MAMy name is Stephen Hrutka. I lead a Veteran-owned consulting firm in Washington, DC, focused on strategic sourcing, supply chain management, and IT Staffing.We want to fill a Snowflake Administrator role for the State of Massachusetts.The ideal candidate is based in MA/NH/RI and has 2+ years of hands-on experience managing and administering Snowflake environments. Experience with other cloud-based data platforms is a plus. Snowflake certification (e.g., SnowPro Core or Advanced) is preferred.If you're interested, I'll gladly provide more details about the role and discuss your qualifications further.Thanks,Stephen M HrutkaPrincipal ConsultantExecutive Summary: HRUCKUS is seeking a Snowflake Administrator for a role supporting the State of Massachusetts.Position Description: Our client seeks a highly skilled and motivated Snowflake Administrator to join their team. The ideal candidate will be responsible for administering, configuring, and maintaining the Snowflake data warehouse environment. This role requires a deep understanding of Snowflake's features and best practices, strong problem-solving skills, and the ability to work collaboratively with cross-functional teams.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 current with Snowflake's 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 updatesQualifications:Experience: 2+ 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.2+ 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.Additional Details:Job title: Snowflake AdministratorDuration: 12 MonthsLocationBoston, MAWork ArrangementHybrid - Candidates hired for this position must reside in MA/NH/RI)Duration12 MonthsCompensation: Max Pay Rate: $78/hour.

Created: 2025-01-28