Snowflake Data Engineering Consultant

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. 

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.