Job description
Our Ways of Working:
We believe that we do our best work when we are together, but also appreciate that everyone works in different ways. That’s why we operate with three working models which look 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
Work with us
At Moonpig Group our mission is to help people connect and create moments that matter. We are an international group made up of two brilliant brands – Moonpig in the UK, US and Australia, and Greetz in the Netherlands.
We’re now growing the team to work towards an even more ambitious goal of reaching 25 million customers. To help get us there, we’ll be developing some cool tech innovations. Two projects we’ll bring to life this year include augmented reality/video cards and pre-personalisation; the latter aiming to provide a richer browsing experience for our customers via the automatic translation of customer data into personalised cards and gifts across multiple galleries.
But the magic does not stop there. Our architecture is built for scale and flexibility which will allow us to quickly innovate and launch new propositions - coupling that with the wealth of data we have on our customers, the sky's the limit in the world of experimenting with cutting edge ideas.
Moonpig is a hidden gem in terms of our culture. Check out our tech culture and benefits as well as our 4.0 rating and reviews on Glassdoor for a view on how great it is to work here!
What you can expect as a Data Modeler
Data modelers are central to our understanding of data. It’s so much more than just writing SQL, it’s also about how you apply best practices to analytics code and how you strive to understand the business and work with our stakeholders. You’ll be working with tools such as dbt and Snowflake, with the purpose of producing clean, transformed data that is ready to be used by our team of analysts.
The role will be working with us in the 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 work 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 in a timely fashion to the business. When things don’t go according to plan, we should be proactive in alerting the business to 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 time.
- You are responsible for the trust in our data. You will be building out 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 are able to translate business requirements to SQL to create meaningful data models, through engagement with business stakeholders, engineers and data analysts
- You understand 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
- Know/learn how to use and leverage the power of 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 the ever scaling objectives of Moonpig
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 visualisation tools
Want to hear more?
Find out more about Moonpig Group and what it has to offer here!
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 organisation, 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 safe and comfortable to be their true authentic self at work.
Moonpig
www.moonpig.com
London, United Kingdom
Nickyl Raithatha
$100 to $500 million (USD)
201 to 500 Employees
Company - Private
Internet & Web Services
2000