Senior Snowflake Consultant

Summary

Join Massive Rocket, a rapidly growing Braze & Snowflake agency, as a Snowflake Consultant. You will design and implement high-performance data solutions on Snowflake's cloud platform, collaborating with cross-functional teams. Responsibilities include managing datasets, executing data transformations, designing data models, and ensuring data quality. You will also analyze data, translate findings into actionable insights, and utilize data for customer engagement through Braze. Collaboration with data engineers, analysts, and stakeholders is crucial. This role requires a Bachelor's degree, 4+ years of Snowflake development experience, and expertise in SQL, data modeling, and ETL processes. The position is 100% remote.

Requirements

• Bachelor's degree in Computer Science, Information Technology, or equivalent work experience
• 4+ years of working as Snowflake Developer or in a similar role
• 4+ years of experience in SQL and data modeling and ETL processes
• 2+ years of experience of working with Python
• Experience with Snowflake features such as Snowpipe, Snowflake Data Sharing, and Snowflake Secure Data Sharing
• Experience with cloud platforms (e.g., AWS, Azure, Google Cloud) and data integration tools
• Excellent problem-solving skills and attention to detail
• Strong communication skills with the ability to convey complex data concepts to non-technical stakeholders
• Ability to work independently and collaboratively in a fast-paced environment
• Experience working in an agency setting or experience working with external clients

Responsibilities

• Setting up and maintaining ETL pipelines in the Snowflake environment across a variety of architectures (real-time and batch, internal/external storage systems, dynamic tables, tasks)
• Implement Snowflake solutions that integrate seamlessly with existing data architecture
• Optimize the performance of Snowflake databases, including designing and implementing data structures and using indexes appropriately
• Deploying and configuring tools to monitor and report on the performance of the Snowflake system
• Ensure data quality and integrity across all Snowflake data solutions (QA process, Unit Tests…)
• Use large datasets and a variety of analytical techniques to tell compelling stories with the data in an easy-to-understand manner
• Translate complex data analyses into actionable insights and recommendations for business stakeholders
• Help build Snowflake into the core source of data to power Braze and Customer Engagement initiatives
• Be able to work through a Customer Engagement data plan and translate it into an actionable set of data models in Snowflake
• Understand and work with core Customer Engagement and Braze concepts such as custom events, user attributes and syncing data from Snowflake into Braze
• Collaborate with data engineers, analysts, and other stakeholders to ensure alignment on data strategy and implementation
• Provide technical support and guidance to team members on Snowflake best practices and optimization techniques
• Support customers in leveraging unused features of the Snowflake platform that can either provide efficiencies or cost-savings across the stack
• Align with the internal CDP and CRM team to work on the data plan and therefore power the Braze platform in the most efficient way possible

Preferred Qualifications

• Snowflake certification
• Experience with other data warehousing solutions (e.g., Redshift, BigQuery)
• Knowledge of data visualization tools (e.g., Tableau, Power BI)
• Understanding of data governance and security best practices
• Experience working in Scrum

Benefits

• 100% remote forever
• Career progression paths and opportunities for promotion/advancement
• Organised team events and outings