Snowflake Data Engineering Consultant

Continuus; Grafton (WI); On-site; USD 100,000 - 140,000; Full time

Job summary

Continuus is seeking a Snowflake Data Engineering Consultant to enhance the performance of its data warehouses. The ideal candidate will have expertise in monitoring system performance, optimizing SQL queries, and designing database schemas. Join a prestigious firm where you can work with cutting-edge technologies in data analytics, providing exceptional service to a diverse client base.

Benefits

Unlimited PTO

401K matching program

Health insurance

Dental insurance

Vision insurance

Pet insurance

Qualifications

• Hands-on experience in cloud data warehouses using Snowflake.
• Experience in data integration solutions using ETL/ELT techniques.
• Understanding of data pipelines and automation.

Responsibilities

• Monitor Snowflake data warehouse performance.
• Analyze query execution and optimize SQL queries.
• Implement indexing and partitioning strategies.

Skills

Data architecture design

SQL

Data modeling

Cloud technologies

ETL/ELT techniques

Education

Bachelor's degree in Computer Science or related field

Job description

Join to apply for the Snowflake Data Engineering Consultant role at Continuus

Join to apply for the Snowflake Data Engineering Consultant role at Continuus

Get AI-powered advice on this job and more exclusive features.

About

Continuus Technologies is a consulting firm that provides end-to-end business intelligence, data analytics, and enterprise data management strategies and technology solutions. At Continuus, we are invested in our people. Every member of our team plays an integral part of our growth and success. As a member of the Continuus team, you will be working with some of the brightest minds in the data space. As our clients’ trusted advisors, our diversified and experienced consultants are committed to solving big picture problems, leveraging the most forward-thinking technologies to increase ROI and data depth across the client organization. From road-mapping and strategizing to implementation and support, we help organizations in the financial services, manufacturing, and healthcare industries manage and make sense of their data.

Description

About

Continuus Technologies is a consulting firm that provides end-to-end business intelligence, data analytics, and enterprise data management strategies and technology solutions. At Continuus, we are invested in our people. Every member of our team plays an integral part of our growth and success. As a member of the Continuus team, you will be working with some of the brightest minds in the data space. As our clients’ trusted advisors, our diversified and experienced consultants are committed to solving big picture problems, leveraging the most forward-thinking technologies to increase ROI and data depth across the client organization. From road-mapping and strategizing to implementation and support, we help organizations in the financial services, manufacturing, and healthcare industries manage and make sense of their data.

We hire go-getters who are motivated to deliver the highest quality of service to our clients. We provide the tools to help them excel in their careers while providing the autonomy and flexibility to deliver their work in the way that best fits their schedules and work style. Our award-winning workplace encourages creativity, teamwork, and continuous learning.

• Snowflake Premier Services Partner
• Alteryx Premier Partner
• Inc. 5000 Fastest Growing US Companies 2022
• Inc. Best Places Honoree - 2023
  
  

Position Name: Snowflake Data Engineering Consultant

As a Snowflake Data Engineering Consultant, your main responsibilities will be to support the Snowflake data warehouse performance by monitoring system usage, analyzing query execution, and optimizing SQL queries and database schemas. You'll also manage compute resources, implement indexing and partitioning strategies, and provide support to users for query optimization.

Requirements

Scope

• Monitor system performance and usage patterns.
• Analyze query execution plans and resource consumption.
• Review and optimize SQL queries for efficiency.
• Design and implement database schemas for efficient data storage and retrieval.
• Utilize clustering keys and sort keys to improve query performance.
• Configure warehouses and resource monitors based on workload patterns.
• Scale resources up or down as needed to meet performance requirements.
• Implement indexing strategies to accelerate query performance.
• Develop and optimize ETL processes for data ingestion.
• Document performance tuning techniques and best practices.
• Share knowledge and provide training to other team members.
  
  

Skills

• Experience in a role performing data warehouse and analytics solution design and development using a variety of techniques
• Understanding of data architecture design, data modeling, and physical database design and tuning
• Hands-on experience in implementation of cloud data warehouses using Snowflake.
• Hands-on experience in cloud technologies, such as AWS, Azure and/or Google Cloud
• Ability to understand data pipelines and modern ways of automating data using cloud based and on premise technologies
• Experience managing and creating extractions and queries in SQL
• Experience designing and developing data integration solutions using both ETL and ELT techniques
• SnowPro Certified or SnowPro Advanced Certification a plus
  
  

Behavior

The ideal candidate will...

• Consistently show up with Continuus' and our client's best interest in mind.
• Be a self-starter who takes autonomy and pride in your work.
• Have the ability to think independently while also working in a collaborative environment.
• Not be afraid to ask for help, voice your opinion, or make suggestions for improvements.
• Be a fast learner and have a passion and drive for continuous learning and challenging yourself.
• Be able to have fun in the midst of stress while maintaining great attention to detail.
• Adapt quickly to new situations and are forward-thinking.
• Have a clear and transparent communication style.
• Be creative and want to use your creativity to move the business forward.
• Have a willingness and openness to learning new practices, platforms, and technologies.
• Have the teamwork skills to build and enhance a successful marketing department.
• Have a willingness to work with and help team members from all internal departments, partners, vendors, etc.
  
  

Continuus Technologies is based out of Milwaukee, WI. We look for creative, tool agnostic individuals who love working with clients in differing industries. We believe in a flexible, community focused, and transparent environment. We strive for a culture that promotes a work/life balance and offer amazing benefits, including unlimited PTO, a generous 401K matching program, health, dental, vision, and pet insurance.

Continuus Technologies is an Equal Opportunity Employer and prohibits discrimination and harassment of any kind. We’re committed to the principles of equal employment opportunity for all and to providing employees with a safe and respectful work environment.

Seniority level

• Seniority level

  Entry level

Employment type

• Employment type

  Full-time

Job function

• Job function

  Engineering and Information Technology

• Industries

  Data Infrastructure and Analytics

Referrals increase your chances of interviewing at Continuus by 2x

Get notified about new Engineering Consultant jobs in Grafton, WI.

Property Risk Engineering (Consultant or Sr Consultant)

Software Engineering Manager (Backend SaaS)

Software Engineering Manager - Sustaining Engineering

Engineering Manager - Public Cloud, Python, Golang

Engineering Manager - Solutions Engineering

Senior Staff Engineering Manager of Financial Data and Analytics

Software Engineering Manager, Ubuntu Gaming

Software Platform Engineering Manager - Ubuntu for Next-Gen Silicon

Software Engineering Manager - Container and Virtualisation Infrastructure

Food and Beverage Engineering Project Manager

Milwaukee, WI $115,000.00-$155,000.00 3 weeks ago

Embedded Linux Field Engineering Manager

Engineering Manager for IAM (Identity and Access Management)

Software Engineering Manager - Desktop and Embedded Linux Optimisation

Software Engineering Manager - Ubuntu Linux Kernel

Linux Engineering Manager - Optimisation for Latest Hardware

Engineering Manager, Ubuntu Server - Ubuntu Pro

We’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI.