Snowflake Data Engineering Consultant

November 4, 2024

Apply Now

Receive Emails with Similar Jobs

Continuus Technologies

WebsiteLinkedInAll Job Openings

Continuus Technologies is a company that empowers financial firms with cloud data solutions. The company provides innovative, custom solutions to help financial services organizations achieve operational efficiency and unlock insights quickly. Continuus Technologies offers a range of services from data strategy and governance to AI-driven analytics and cloud transformations, supporting clients in uniting complex data ecosystems and enabling strategic decision-making. With a focus on building scalable and sustainable solutions, their consultants drive the adoption of cutting-edge technology to tackle data complexity and enhance competitive advantage.

Snowflake • Tableau • Alteryx • FactSet • Fivetran

51 - 200 employees

💸 Finance

🤖 Artificial Intelligence

📋 Description

• Continuus Technologies is a consulting firm providing end-to-end business intelligence and data management solutions. • The role supports Snowflake data warehouse performance by optimizing queries and managing compute resources. • Work in a creative, teamwork-focused environment with autonomy and flexibility to excel.

🎯 Requirements

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

🏖️ Benefits

• unlimited PTO • a generous 401K matching program • health, dental, vision, and pet insurance