Analytics Engineer

Octopus Energy

3800

Houston, TX, United States

Posted on: 2024-05-10

Category: energy

Apply now

Please let Octopus Energy know you found this job on Work in Green. This will help us grow!

Expired

Employment type:

Full time

Experience required:

Intermediate

Salary

Salary not provided

About the company:

We're on a mission to make a big green dent in the universe by building a truly sustainable energy system globally.

That means making power greener, smarter, and more affordable for everyone.

We put customers at the heart of everything we do: with always-fair prices, transparency and outrageous customer service.

We drive system change: with transformative tech to make renewable energy the norm and end global reliance on fossil fuels.

Octopus Energy Group is made up of 10 businesses spanning 6 countries across 3 continents, including: Octopus Energy Retail, Kraken Technologies, Octopus Energy Generation, Kraken Flex, Octopus Electric Vehicles, and the Octopus Centre for Net Zero. More on OEG @ octopusenergy.group

Welcome to the future of energy

We are both an electricity retailer and a tech platform and we think there is no better way to address our greatest challenge, climate change, than with the combination of those two.

Through our proprietary tech platform, Kraken, we are changing the way people interact with their energy company - by making it approachable, low cost, easy-to-understand, and most importantly, 100% renewable. We’ve distinguished ourselves by being named 2020’s Energy Provider of the Year, which highlights our commitment to exceptional customer service. In many markets we are a leading employer on Glassdoor for best places to work.

At Octopus we’re focused on making energy fair, clean, and simple for all using technology. We’re looking for an Analytics Engineer that can help us with this challenge. Our data team is developing a data platform and providing data services to inform Octopus US business strategy and operations. This data platform enables self-service of data analytics for business stakeholders as well as automation of all our data workflows from ETL jobs to ML training and prediction. The data platform team works across the whole customer domain on anything from energy load forecasting to financial and customer data modeling.

Octopus Energy is growing fast and that means lots of data that needs to be ingested, organized, analyzed and shared with the team. You’ll work across all different parts of the business to understand what our teams need and deliver data pipelines and tools to meet them. Because it’s still early days, you’ll need to be versatile and be equally comfortable building robust production ready pipelines or hacking together a quick script to run on your machine. You’ll spend most of your time engineering, but you should also enjoy analyzing data and building data interfaces like dashboards or data applications.

You’ll be part of our global data platform team who will provide dev ops and infrastructure support as well as technical guidance. We’re building a consistent data platform across all Octopus retail businesses around the world so you’ll be part of and contribute to a global data community. This position is based in Houston, Texas.

If this sounds like you then we'd love to hear from you.

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.

What you'll do

Work with the data scientists, data analysts, and business stakeholders to scope out and plan new data sources and pipelines

Build, automate, deploy and maintain data models and workflows

Develop Streamlet data apps and lend a hand building and maintaining Tableau dashboards

Spearhead efforts on data monitoring and integrity to ensure accuracy of reporting.

Work with the global data platform team to deploy new tools and services into the US data environment

Participate in and contribute to our global data community

Build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources

Use an analytical, data-driven approach to drive a deep understanding of fast changing business

Build large-scale batch and real-time data pipelines with data processing frameworks

What you'll need

2+ years of experience in data engineering

First and foremost, we want our data engineers to be great software engineers with a passion for writing high quality code

It would be helpful to have experience/expertise in the following (in rough priority order):

- Python (in combination with Data Pipelines and Analytics)

- Advanced SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases.

- Experience modeling data for analytics - ideally experience using dbt as a modeling tool

- Experience building data pipelines in a cloud environment (ideally AWS)

- Spark

The projects will be varied and we’re looking for someone who can work autonomously and proactively to scope problems and solve and deliver pragmatic solutions

We want someone who is passionate about building great data tools for our business teams

Experience in the energy industry or enthusiasm for innovation in our energy system towards a more intelligent and clean grid are a big plus!

The ability to work alongside the team in our downtown Houston office

Our Data Platform Stack

Python as our main programming/scripting language

Kubernetes for data services and task orchestration

Airflow purely for job scheduling and tracking

Circle CI for continuous deployment

Parquet and Databricks Delta file formats on S3 for data lake storage

Spark and pandas for data processing

dbt for data modelling

Presto and SparkSQL for querying

Jupyter for data notebooks and ad-hoc analytics

Streamlit for data applications

Tableau for BI

Why you'll love it here

Great medical, dental, and vision insurance options including FSAs.

Paid time off — we know working hard means also being able to recharge as needed, we trust our employees to get the work done and take the time they need.

401(k) plan with employer match.

Parental leave. Biological, adoptive and foster parents are all eligible.

Pre-tax commuter benefits.

Flexible working environment: you need to shift around your schedule? You do you, we genuinely believe in work/life balance.

Equity Options: every Octopus employee owns part of the business. We’re a team, working together towards huge goals. Every person is crucial to our success, you should be rewarded as such.

Modern office or co-working spaces depending on location.

Wondering what the salary for this role is? Just ask us! When 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!

7949 Energy jobs