Design and build analytics platforms utilizing dbt for data modeling with a focus on data quality, governance, and CI/CD pipelines, ensuring scalable insights across global operations.
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.
We’re standing up a brand-new Analytics Platform team to drive the data strategy across our global business.
We're looking for a dbt wizard to help build scalable data foundations.
The team will...
- Build a platform of consolidated analytics tools which enables data teams to quickly turn data into insights through dashboards, notebooks, and AI agents
- Make metrics discoverable, trustworthy, and usable to data consumers
- Embed excellent data modelling practices to make data assets efficient, reusable & globally consistent
What you’ll do...
- Build, document and consult on:
- Analytics for business domains using dbt & modern BI tools such as Lightdash
- Strategies to model & govern a Data Mesh – improving discoverability, consistency, performance, and performance
- Comprehensive testing frameworks to ensure data quality, using tools like dbt_expectations and Elementary
- Robust CI/CD pipelines for testing and deployment of AE and BI models
- Monitoring and alerting tools for insights on AE performance
You’ll work hands-on with ~20 teams, guiding them to adopt tools & data modelling approaches at scale (1000s of models!)
What You'll Need...
- Deep expertise with dbt Core
- Advanced SQL, Jinja and Git
- Data Modelling Techniques e.g. Kimball, OBT
- Experience with a cloud warehouse provider e.g. Databricks, Snowflake, BigQuery
- A record of working with multiple stakeholders across domains
It'd be nice if you had experience in...
- Python
- Spark
- Github
- Lightdash
- Elementary
- CircleCI
- Databricks
- Airflow
- Kubernetes
- DuckDB
💚 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
Our process usually takes up to 4 weeks, but we’ll always do our best to flex around what works for you. Along the way, you’ll chat with our recruitment team and your Recruiter will help you throughout different stages. Got any burning questions before then? Drop us a message at [email protected] and we’d love to help!
If this sounds like you then we'd love to hear from you. 🚀
Are you ready for a career with us? We want to ensure you have all the tools and environment you need to unleash your potential. Need any specific accommodations? Whether you require specific accommodations or have a unique preference, let us know, and we'll do what we can to customise your interview process for comfort and maximum magic!
Studies have shown that some groups of people, like women, are less likely to apply to a role unless they meet 100% of the job requirements. Whoever you are, if you like one of our jobs, we encourage you to apply as you might just be the candidate we hire. Across Octopus, we're looking for genuinely decent people who are honest and empathetic. Our people are our strongest asset and the unique skills and perspectives people bring to the team are the driving force of our success. As an equal opportunity employer, we do not discriminate on the basis of any protected attribute. Our commitment is to provide equal opportunities, an inclusive work environment, and fairness for everyone.
Top Skills
Airflow
CircleCI
Databricks
Dbt
Duckdb
Elementary
GCP
Git
Git
Jinja
Kubernetes
Lightdash
Python
Snowflake
Spark
SQL
Octopus Energy London, England Office
1 Upper James Street, London, United Kingdom, W1F 9DE
Similar Jobs
41 Minutes Ago
Artificial Intelligence • Healthtech • Machine Learning • Natural Language Processing • Biotech • Pharmaceutical
The Senior Director will lead data and analytics projects, driving enterprise transformation and aligning with business priorities while managing a technical team and influencing stakeholders.
Top Skills:
AIAnalytics ToolsCloud PlatformsData PlatformsMl
Aerospace • Information Technology • Cybersecurity • Defense • Manufacturing
Manage customer relations and training programs, optimizing resources, leading planning conferences, and ensuring training readiness while interfacing with cross-functional teams.
Top Skills:
Microsoft Office (ExcelPowerpoint)Word
Aerospace • Information Technology • Cybersecurity • Defense • Manufacturing
Develop and document design solutions for aircraft cabin modifications, ensuring compliance with regulations, while liaising with customers, vendors, and regulatory bodies.
Top Skills:
3DxAutocadCadCatia V5
What you need to know about the London Tech Scene
London isn't just a hub for established businesses; it's also a nursery for innovation. Boasting one of the most recognized fintech ecosystems in Europe, attracting billions in investments each year, London's success has made it a go-to destination for startups looking to make their mark. Top U.K. companies like Hoptin, Moneybox and Marshmallow have already made the city their base — yet fintech is just the beginning. From healthtech to renewable energy to cybersecurity and beyond, the city's startups are breaking new ground across a range of industries.
