Over the past ten years, Octopus Energy Group has expanded from a UK startup to become the UK's largest energy provider and a global leader, serving over 10 million customers across 8 countries.
The Analytics Platform team is brand new to the company and is tasked with consolidating analytics tooling and building a strategy for consistent data modelling across all our global businesses.
We are looking for a dbt wizard to help us in building a platform that each country can plug their respective data into and get consistent data to be used to optimise customer journeys for each region or metrics at the global level by the group management team.
Our mission is to build a platform for analytics where...
Producers can build efficient pipelines from source data to insight with easeProducers can scale out Modelling & BI to any number of Octopus Energy businesses around the world
Producers can provide insight via:
Notebooks for detailed storytellingDashboards for live updates on a domain
Consumers can find what they’re looking for with easeConsumers have trust in the metrics and dashboards they’re presented withConsumers can self-serve if neededConsumers can retrieve data via automation
What you’ll do...
Build, document and consult on:Using dbt to model analytics for business domains using a data mesh framework.Charts and dashboards using modern BI toolsComprehensive testing frameworks using tools like dbt_expectation and elementary to ensure data qualityData governance and documentation strategy to improve data discoverability and drive a consistent approach across teamsBuild robust CI/CD pipelines for testing and deployment of AE and BI models.Build monitoring and alerting tools for gathering insight on AE performance
What You'll Need...
Deep expertise with dbt Core and GitAdvanced experience with SQL Advanced experience with Jinja Data Modelling Techniques e.g. Kimball, OBTExperience with a cloud ware,house provider e.g. Databricks, GCP, Snowflake
It'd be nice if you had experience in...
PythonGithubLightdashElementaryCircleCIDatabricksAirflowKubernetesDuckDBSpark
💚 Why else you'll love it here
💰 Wondering what the salary for this role is? Just ask us! On a call with one of our recruiters it's something we always cover as we genuinely want to match your experience with the correct salary. The reason why we don't advertise is because we honestly have a degree of flexibility and would never want salary to be a reason why someone doesn't apply to Octopus - what's more important to us is finding the right octofit!🎉 Octopus Energy Group is a unique culture. An organisation where people learn, decide, and build quicker. Where people work with autonomy, alongside a wide range of amazing co-owners, on projects that break new ground. We want your hard work to be rewarded with perks you actually care about! We won best company to work for in 2022, on Glassdoor we were voted 50 best places to work in 2022 and our Group CEO, Greg has recorded a podcast about our culture and how we empower our people. We’ve also been placed in the top 10 companies for senior leadership🎁 Visit our UK perks hub - Octopus Employee Benefits
