Job description
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
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
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
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.