Analytics Engineer

Our Ways of Working Principles:
We believe that most of us do our best work when we work together, but we know that everyone works in different ways, and quite frankly, has other commitments and responsibilities outside of work.As we further adjust  to hybrid working, we want to take what we've learnt from working remotely and keep the flexibility that's enabled us to thrive and keep driving our business forward.
We have some core principles which support us in this:Do what’s rightTrust & give permissionDelivery matters
We understand ways of working can look different based on your role, team and you as an individual so we are here to support and discuss this with you during the interview process.
Work with usAt 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 here!). 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 binds us together and we think of them as a platform to help us deliver our best work. You have every chance to drive impact here at Moonpig, and most importantly, we genuinely want you!
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.
What you’ll be doing: At Moonpig, we are committed to enabling impactful, data-driven decisions to improve the lives of our customers. Joining our Data Platform Team means you're at the heart of our mission, transforming raw data into valuable data products that drive our business forward.
As an Analytics Engineer, your role is crucial in shaping our understanding and use of data. Beyond expert SQL development, you will apply best practices to analytics code, collaborate extensively with stakeholders, and ensure our data systems support robust business decisions.
The role sits within the Analytics Engineering team, which is part of the Data Platform Team, and wider Data function. The position reports into the Engineering Manager for Analytics Engineering.

Key Responsibilities:

• Data Transformation Leadership: You own the 'T' in ELT, focusing on delivering clean, transformed data that powers business analytics. Engage closely with stakeholders to meet their data needs and ensure the reliability and timeliness of data delivery.
• Platform Ownership: Manage and govern our primary data platform, Snowflake. Ensure secure data access and compliance, maintaining high standards of data protection and accessibility.
• Data Integrity: Develop and enforce data quality checks, build comprehensive data dictionaries, and conduct tests to guarantee the reliability of our data architecture.
• Collaboration and Communication: Work within an agile team environment, liaising between business stakeholders, engineers, and analysts to translate business needs into effective data models. Your ability to communicate complex technical concepts to non-technical team members is vital.

You'll be a great addition to the team if you:

• Advanced SQL Skills: Exceptional ability in SQL is required for effective data manipulation, analysis, and crafting of complex queries.
• dbt Expertise: Extensive experience with dbt is crucial for designing and maintaining robust data models and transformation processes that are efficient and scalable.
• Big Data Systems Proficiency: Knowledge of Snowflake is recommended but experience with other big data systems like BigQuery will be considered. We’re looking for a well-rounded skill set in managing large data environments.
• Python Skills: Familiarity with writing clean and efficient code for data manipulation, automation, and integration tasks is beneficial
• Agile and Adaptive: Comfortable working in an agile environment, you should be adept at balancing technical precision with timely project delivery, demonstrating flexibility and effectiveness in a dynamic setting.
• Technical Curiosity: Demonstrate a keen interest in continuously enhancing your capabilities in data technologies. This includes potential integration of tools like Metaplane for advanced data flow monitoring and performance optimisations

Extra Bonus Points if you:

• Experience with Data Monitoring Tools: Familiarity with Metaplane or similar tools for monitoring data flows.
• Proficiency in Version Control Systems: Notably git, which is crucial for managing and tracking changes in the codebase effectively.
• Experience with Data Orchestration and Ingestion Frameworks: Proficient with frameworks like Fivetran, Airflow, and Dagster, important for automating, managing, and orchestrating data pipelines efficiently.
• Knowledge of Data Visualisation Tools: Experience with tools such as Tableau, which are essential for creating impactful data visualisations and dashboards.

Our Data Tech Environment

• Snowflake, DBT, SQL, Python, Fivetran, Airflow, Dagster, Metaplane, Tableau.
• AWS (inc Sagemaker, EC2, Lambda, Glue, S3, API gateway), Terraform, C#, .NET Core.
• GitHub for SCM, CI/CD through GitHub workflows.
• Google Analytics, GTM, GCP Big Query.
• Robust and performant cloud/serverless applications.


• We don’t expect you to have experience with all of the technologies above!

How we get there

• Sprints
• Jira / Confluence
• Pair Programming
• Focus on experimentation to validate our hypothesis

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+, Gender Balance, Neurodiversity and our EMBRACE (Educating Myself for Better Racial Awareness and Cultural Enrichment) Committees.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.