Snowflake Admin - Steneral Consulting

Title : Snowflake Admin
Duration: Long term
Visa : USC/GC
Location : Boston, MA (Hybrid) local on,ly

Rate: 50-55/hr ideal C2C some flex

JOB DESCRIPTION:

REQUIRED EXPERIENCE:

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 modelling experience

The Technology division is 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 a deep understanding of Snowflake's features and best practices, as well as 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 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 update