Snowflake Data Associate

Compunnel Inc.
Westbrook, United States of America
2 days ago

Role details

Contract type
Temporary contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Intermediate
Compensation
$ 104K

Job location

Westbrook, United States of America

Tech stack

Query Performance
Airflow
Amazon Web Services (AWS)
Amazon Web Services (AWS)
Amazon Web Services (AWS)
Cloud Computing
Databases
Information Engineering
ETL
Data Sharing
Database Theory
Linux
Disaster Recovery
Github
Python
MySQL
Oracle Applications
Role-Based Access Control
Cloud Services
Standard Sql
User Provisioning Software
Datadog
Scripting (Bash/Python/Go/Ruby)
Informatica Powercenter
Snowflake
GIT
Infrastructure Automation Frameworks
Information Technology
Data Management
Functional Programming
Terraform
Software Version Control
Data Pipelines

Job description

  • Provide day-to-day Tier 1 operational support for Snowflake environments, including handling support tickets for access requests and user provisioning
  • Monitor Snowflake costs and usage through dashboards and resource monitors, identifying opportunities for optimization
  • Assist with creating and maintaining cost and utilization reports to support business decision-making
  • Support RBAC (Role-Based Access Control) implementation by managing user access, roles, and permissions
  • Participate in on-call rotation to provide production support for Snowflake and related data platforms.
  • Handle deployments and releases from GitHub
  • Assist with configuring and maintaining Snowflake objects including databases, schemas, warehouses, and resource monitors
  • Support data sharing and replication processes for internal and external clients
  • Collaborate with data engineering teams to troubleshoot data pipeline issues and support ETL/ELT processes
  • Help maintain monitoring dashboards and implement alerts for system health and performance issues
  • Document procedures, configurations, and troubleshooting steps in runbooks and knowledge base articles
  • Support audit and compliance activities by providing documentation and evidence as needed
  • Assist with Snowflake query performance troubleshooting and optimization efforts
  • Participate in Disaster Recovery (DR) testing and failover exercises
  • Support general data platform operations including production troubleshooting and incident response
  • Work with infrastructure as code tools like Terraform to support automation initiatives
  • Establish and follow naming conventions, object tagging, and organizational best practices
  • Respond to production incidents promptly and work independently to resolve issues or escalate appropriately

Requirements

Do you have experience in Snowflake?, * 2-3 years of IT experience with exposure to cloud data platforms, databases, or data engineering environments

  • Intermediate experience with Snowflake administration, configuration, or support
  • Foundational knowledge of SQL and database concepts
  • Familiarity with Linux and Python scripting for basic automation tasks
  • Experience with Git/GitHub for code versioning and deployment processes
  • Exposure to tools and technologies such as AWS (S3, EC2, Lambda), Apache Airflow (MWAA), Python, Oracle, MySQL, Terraform, Git, Datadog, Informatica, and Alation
  • Basic understanding of AWS cloud services and cloud infrastructure
  • Familiarity with role-based access control (RBAC) and security concepts
  • Willingness to participate in on-call rotation and provide production support
  • Good problem-solving and analytical skills with attention to detail
  • Strong communication skills (verbal and written) and ability to document technical processes
  • Self-starter with ability to quickly ramp up in new environments and hit the ground running
  • Experience working independently in contract or consulting roles preferred
  • Ability to integrate quickly into existing teams and contribute independently with minimal supervision
  • Flexibility to adapt to changing priorities and project needs
  • Available to start immediately or with minimal notice period
  • Available for the full duration of the contract assignment
  • Customer Service orientation with ability to handle support requests professionally

Apply for this position