Snowflake Administrator - SFADMIN24-14542

NavitsPartners
Everett, Massachusetts, United States
Full-time

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
Related jobs
NavitsPartners
Boston, Massachusetts

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-...

Promoted
Booz Allen Hamilton
Boston, Massachusetts

ServiceNow Platform and Systems Administrator, Senior. As a ServiceNow Platform and Systems Administrator, you can resolve a problem with a complete end-to-end solution in a fast, agile environment. As a ServiceNow Platform and Systems Administrator at Booz Allen, you’ll use your passion to master n...

Promoted
ESR Healthcare
Boston, Massachusetts

At least 7 years experience in Database development on any major RDBMS platform (SQL Server, Sybase, Oracle, DB2). ...

Promoted
Center For Health Information And Analysis
Boston, Massachusetts

We are looking to hire a skilled ETL developer to work with the ETL Development team to create new and maintain existing ETL systems. The ETL Developer is a key member of CHIA’s software development organization and our Data Operations and Technology team reporting to the Associate Director of...

Promoted
WEX, Inc.
Boston, Massachusetts

The WEX SQL Server Database Administrator will be responsible for the maintenance, performance, monitoring, and recoverability of the SQL database environments. High-level knowledge with SQL Server internals, database design, T-SQL, backup/restore, SSIS, security and understanding of performance tun...

Promoted
Mondo
Boston, Massachusetts

Columnar (vertica) databases, any would be considered. ...

Promoted
Klaviyo
Boston, Massachusetts

Has knowledge of data engineering best practices (data discovery, data documentation, infrastructure development/deployment, and information security). Work with a team of data engineers and analysts to build a world-class, self-service data environment that everyone at the company can use. Experien...

Promoted
Tripadvisor
Needham, Massachusetts

Data at Tripadvisor is hugely important, and as a result, we have over 600 on-premise logical databases running on over 100 database hosts serving petabytes of data. As a Principal Database Administrator on the SiteOps team, you will be a force multiplier for our engineering & operations teams, ...

Promoted
The Depository Trust & Clearing Corporation (DTCC)
Boston, Massachusetts

The Database Engineering team is responsible for managing the Distributed Databases, Automation, and Business intelligence technologies. TFE) for automated provisioning and configuration of database environments. Create, maintain, and optimize the database automation frameworks and processes. Collab...

Promoted
Boston Technology
Boston, Massachusetts

Ensure that the code is written with security issues such as SQL Injection in mind. Develop reports in SQL Server Reporting Services. Identify and write the best possible code for new deployments or when rewriting code when migrating to newer versions of SQL Server. Create cubes in SQL Server Analys...