Data Modeller, Moonpig

• 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
• Experience using git
• Experience working in Snowflake
• The ability to give meaningful, candid, actionable feedback
• Used ingestion tools such as Fivetran, Stitch Data, Airflow or similar

Desirable

• Data modellers 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”
• 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