Data Engineer

Company Description

At Octopus, we’re entrepreneurs and we’re investors, on a mission to back the people, ideas and industries that will change the world. 

We think working here is great, but we’re understandably bias. Click here to explore Life at Octopus.

Job Description

The Team

You will be part of the data engineering team, reporting to the head of data engineering. It is a strong team of 6 with lots of experience in data management and processing. The team manages the central data warehouse and provides data engineering expertise across the business on various projects.

What will you be doing?

• You will play a key part in transforming Octopus to a data-driven organization. You have a passion for data and love finding interesting ways to innovate data development.
• You will be responsible for the development of pipelines to ingest data from various source systems and third parties, the data is extracted through different techniques including API, Change Tracking, Message Queues, Files etc. We use StreamSets and Azure Data Factory for data ingestion.
• You will be actively involved in design and implementation of various star schema models for Reporting and Analysis. We use DBT for data transformation.
• Optimize performance and storage of the data in the Data Warehouse and other operational databases. The data warehouse is an Azure Synapse Instance, and the operational database are on Azure SQL and MySQL instances.
• Liaise with various data insight and reporting teams on reporting requirements.
• Be part of various software development projects with active involvement in database design and migration.
• Stay up to date with various data engineering innovations.

Qualifications

Ideally, you’ll have

• Proficiency in designing and implementing complex modern data warehouse solutions.
• Good in working with data in various forms including database, files, json/xml structures and excel.
• Comfortable in writing complex SQL and ability to analyse data.
• Excellent communication skills to capture requirements, manage relationships with stakeholders and articulate the solution.
• Familiarity with cloud-based software solutions

Additional Information

What we offer

💰 A competitive salary, bonus, pension and share incentive plan
✈️ Untracked holiday
🏡 Hybrid working – three days in the office, two days from home
⚓ Anchor (our wellness hub) which includes Headspace, one to one coaching through Wellness Cloud, Digital GP, employee assistance program & more
👪 Up to 6 months paid parental leave regardless of gender
❤️ Life insurance, critical illness cover and income protection
🏥 Private medical insurance for you and your family
🚗 Electric vehicle leasing
🌍 The option to work overseas up to a month per year

Our Values 
At our core, we believe that how a company behaves is just as important as what it does. That’s why we chose to become an accredited B Corp (the equivalent of a Fairtrade coffee stamp but for companies) and to change our Articles of Association so that the interests all our stakeholders – employees, customers, communities, environment and shareholders – are considered in every decision we make.   

We’re committed to creating a diverse and inclusive employee experience for all. We promote equal opportunities for growth and development regardless of race, gender, religion, sexual orientation, age, disability, or socio-economic background. We believe strongly that teams are at their best when every member of the team feels safe to bring their whole self to work.