Analytics Engineer

(you might also go by the name of Data Engineer or BI Developer - if you have experience with dbt)*Team:*Data*Salary:*£65-70k per annum depending on experience*Location:*Hybrid role*Join our milk round *This is a fantastic opportunity for an experienced Analytics Engineer to make an impact at a growing business with an inspiring mission Our goal at Modern Milkman is to make the home sustainable, and, to date, we've prevented over 100 million plastic bottles from polluting the planet. Not bad for a business that started as four friends from Lancashire delivering milk from a beat-up truckThe data team exist to enable better decisions for everyone at Modern Milkman. We care about leveraging data to improve the way we operate, how we serve our customers, how we build digital products and more. We deliver this by creating value driving data products and generating actionable insights so we can make smarter, data-informed decisions.*Your mission *We're looking for an Analytics Engineer to help us build and scale our data stack. You'll be joining a small team of data pros who work closely with colleagues in tech and the business to deliver reliable, valuable analytics in a self-serve BI environment.As an Analytics Engineer, you'll be responsible for staging, transforming and modelling source data to produce clean, certified datasets in our data warehouse that can be used to generate critical analysis.You'll work with stakeholders from across the business with a range of skills and needs, gathering their requirements and getting the right data to the right place at the right time.Key Responsibilities Designing and building data models for analytics, reporting, and data science applications.Implementing and maintaining reliable, efficient ELT pipelines.Build and maintain BI reporting and dashboards, ensuring that data products effectively support business decision-making.Support the broader data function through ad hoc analysis and insights, with the expectation that analytical work will become a core part of the role as our data infrastructure matures.Developing tools and processes to ensure the quality and observability of data.Monitoring and improving the performance and efficiency of the data stack.Producing excellent documentation on all of the above.Work in a small, agile team to build excellent data products.Build great relationships with stakeholders and understand their needs and challenges.Be curious, adaptable, and willing to pitch in to help with data problems of all shapes and sizes.What You'll Bring Experience in a data or analytics engineering role, ideally in a start-up environment.Excellent SQL, with strong Python skills a plus.Solid understanding of data modeling, data transformation, and reporting tools.Previous experience with data cloud tech like Snowflake, BigQuery, or Databricks.Knowledge of ELT tools like dbt, Fivetran, or Stitch.Strong problem-solving skills.Excellent communication skills, both technical and business-oriented.Benefits 25 days holiday, 8 bank holidays (5 flexible ones). Plus, your birthday off tooEMI Share OptionsUp to 6% matched company pension.Access to thanksBen, for a range of core & flexible benefitsEmployee discount off Modern Milkman productsEnhanced parental leave & payLife InsuranceCycle to work scheme & Octopus EV salary sacrificeIn-person company events£300 working from home set up£300 L&D budget per annum£300 Health and Well Being budgetEndless samples of our stock – Seriously, our category managers have us taste testing food and drinks all the timeUp to 4 weeks working abroad2x volunteering days and team volunteering daysLoads of company clubs to join, from book clubs (Page Churners), Running, cycling and swimming (Trotters and Plodders), 5 aside Football (Modern Milkman FC) and any other pun-related clubs you can think of.*Interview Process:*5 stages (incl. a task) Talent Screen> Hiring Manager Interview >Task with wider team>Ways of working interview*Candidate Experience *Due to the high volume of applications, it might take us a little longer to get back to you. Most feedback will be shared via email, and we make every effort to provide specific and constructive insights whenever possible