Senior Snowflake Consultant

Job description

Who We Are

Massive Rocket is a high-growth Braze & Snowflake agency that has made significant strides in connecting digital marketing teams with product and engineering units. Founded just 5 years ago, we have experienced swift growth and are now at a crucial juncture, aspiring to reach $100M in revenue. Our focus is on delivering human experiences at scale, leveraging the latest in web, mobile, cloud, data, and AI technologies. We pride ourselves on innovation and the delivery of cutting-edge digital solutions.

Every role at Massive Rocket is Entrepreneurial - Successful people at Massive Rocket will not only think about their role but understand the roles around them, their goals and contribute to the success and growth of their team, customers and partners.

What We Offer

🚀 Fast-moving environment – you will never stop learning and growing

❤️ Supportive and positive work culture with an emphasis on our values

🌍 International presence – work with team members in Europe, the US, and around the globe

🪐 100% remote forever

🧗🏼‍♂️ Career progression paths and opportunities for promotion/advancement

🍕 Organised team events and outings

What we’re looking for

As a Snowflake Consultant, you will lead the charge in crafting innovative, high-performance data solutions on Snowflake’s cutting-edge cloud platform. Collaborating with diverse, cross-functional teams, you’ll uncover opportunities to harness data, driving impactful business insights and strategic decisions.

In this role, you’ll manage vast datasets, execute intricate data transformations, and design robust data models. Your expertise will ensure our data solutions are not only efficient but also at the forefront of industry advancements. Stay ahead of the curve by integrating the latest trends and best practices into our dynamic data ecosystem.

Elevate your career with us and make a significant impact through the power of data.

Responsibilities

i) Data Solution Design and Implementation

• 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…)

ii) Data Analysis and Storytelling

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

iii) Strategic Data Utilisation for Customer Engagement through Braze

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

iv) Collaboration and Support

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

Required Skills & Qualifications

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

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

During the process, please note the following requirements and preparations:

- Massive Rocket has a Bring Your Own Device (BYOD) policy — you will be expected to use your own equipment for work.

- A valid work visa is required — Massive Rocket does not provide sponsorship at this time.

- You may be asked to provide proof of identification, such as a passport, ID card, or utility bill (gas, water, electricity).

- Two references may be requested — please be prepared to share names, relationship to you, and contact details (email and mobile).

- Contractors only: Proof of incorporation and valid insurance coverage is required.

Note: Please ensure that your qualifications closely match the criteria outlined in the job description. Applications not meeting the specified criteria may not be processed or considered for this position.