Our Ways of Working:
We believe that we do our best work when we are together, but also recognize that everyone works in different ways. That’s why we operate with three working models which aim to define where and how our people work - Remote, Hybrid, Site/Office - based.
Although we believe the majority of our people will choose our hybrid working model (at least 2 days in the office each week), for some of our teams that don't require as much in-person connection and collaboration, we offer fully remote working (with paid travel to the Moonpig office up to 6 times per year). Remote roles are specified directly on our job adverts
Please note this role can be hybrid London or Manchester, or remote and is a 6 month Fixed term contract
Work with us
At Moonpig Group our mission is to help people connect and create moments that matter. We’re an international group made up of three brilliant brands – Moonpig in the UK, Ireland, US and Australia, and Greetz in the Netherlands – with our newest addition Buyagift joining us in 2022.
We were founded with a goal to disrupt the traditional greetings industry. Two decades on, we’re an established leader within the online gifting market, offering a wide range of products to customers across the world.
Moonpig is an iconic brand and innovator, with clear values (read more about our values ). These values set our teams and our business up for success in an environment that’s fun, supportive and challenging. They’re the glue that holds us together and we view them as a platform to help us deliver our best work. You have every chance to make an impact here at Moonpig, and most importantly, we genuinely want you!
Our architecture is designed for scale and flexibility which will allow us to swiftly innovate and launch new propositions -- along with the abundance of data we have on our customers, the sky's the limit in the world of experimenting with cutting-edge ideas.
What you can expect as a Data Modeller
Data modellers are crucial to our understanding of data. It’s so much more than just writing SQL, it’s also about how you enforce best practices to analytics code and how you strive to understand the business and collaborate with our stakeholders. You’ll be working with tools such as dbt and Snowflake, with the aim of producing clean, transformed data that is ready to be used by our team of analysts. The role will be part of our Data Platform Team. Our team vision is “To enable Moonpig to make impactful data-driven decisions”.
We have the following expectations for this role:
- You own the T in ELT (transformation). Your main day-to-day focus is to provide clean, transformed data that can be used by analytics and the rest of the business. In order to do this, you will need to collaborate closely with the stakeholders to understand the needs and assumptions of the business.
- You are responsible for the reliability of the data (within the transform process). The data should be provided promptly to the business. When things go awry, we should be proactive in alerting the business about the delays and work on rectifying them and improving long term reliability where possible.
- You own the data platforms.
- You own the data platform (Snowflake) that all our data flows through and are responsible for the governance of our data. Protecting our data is critically important so controlling this access is a top priority and ensuring the right people have access to the right data at the right
- are responsible for the trust in our data. You will be building comprehensive integrity, presence and quality tests while also maintaining data dictionaries in order to create confidence in the data we produce.
What we expect from a Data Modeler:
- You are a SQL expert - writing concise, performant, readable SQL and able to understand our existing SQL scripts
- You can translate business requirements to SQL to create meaningful data models, through engagement with business stakeholders, engineers and data analysts
- You comprehend data, the flow of data and the value in having proper governance around your data
- You understand how to apply technological best practices to build a stable, performant data transformation pipeline
- Can utilize or learn how to use big data systems such as Snowflake and BigQuery
- You work well within an agile team and strive to balance technical excellence and delivery.
- You take the initiative to help achieve Moonpig's ever-scaling objectives
Extra bonus points if you have:
- Experience using git
- Experience using DBT
- Experience working in Snowflake
- The ability to communicate complex technical concepts to non-technical people
- The ability to give meaningful, candid, actionable feedback
- A broad and comprehensive understanding of concepts and principles in data
- Used ingestion tools such as Fivetran, Stitch Data, Airflow or similar
- Experience in working with Tableau or other visualization tools
Want to hear more?
Find out more about Moonpig Group and what it has to offer !
Moonpig’s Commitment to Equality, Diversity and Inclusivity
At Moonpig Group, we’re committed to creating an inclusive and caring culture with brilliant people who feel a real sense of belonging. We welcome and celebrate all diverse backgrounds to Moonpig Group, from working parents who need flexibility with their hours to individuals who are neurodiverse and prefer to work a certain way.
We’re proud to have several employee-led committees within our organization, including the LGBTQ+ Committee, The Gender Balance Committee, and our Moonpig Against Racism Committee.
We’ll continue to push for diversity and that sense of belonging so that all Moonpig Group employees feel