Data Engineer
London, United Kingdom
Octopus
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.
* Salary range is an estimate based on our AI, ML, Data Science Salary Index 💰
Tags: APIs Azure Data management Data warehouse dbt Engineering Excel JSON MySQL Pipelines SQL XML
Perks/benefits: Career development Competitive pay Health care Insurance Medical leave Parental leave Salary bonus
More jobs like this
Explore more AI, ML, Data Science career opportunities
Find even more open roles in Artificial Intelligence (AI), Machine Learning (ML), Natural Language Processing (NLP), Computer Vision (CV), Data Engineering, Data Analytics, Big Data, and Data Science in general - ordered by popularity of job title or skills, toolset and products used - below.
- Open Data Science Manager jobs
- Open Lead Data Analyst jobs
- Open Senior Business Intelligence Analyst jobs
- Open MLOps Engineer jobs
- Open Data Engineer II jobs
- Open Data Manager jobs
- Open Principal Data Engineer jobs
- Open Power BI Developer jobs
- Open Data Scientist II jobs
- Open Junior Data Scientist jobs
- Open Sr Data Engineer jobs
- Open Data Analytics Engineer jobs
- Open Product Data Analyst jobs
- Open Business Intelligence Developer jobs
- Open Business Data Analyst jobs
- Open Data Analyst Intern jobs
- Open Sr. Data Scientist jobs
- Open Senior Data Architect jobs
- Open Big Data Engineer jobs
- Open Principal Data Scientist jobs
- Open Manager, Data Engineering jobs
- Open Azure Data Engineer jobs
- Open Data Quality Analyst jobs
- Open Junior Data Engineer jobs
- Open Data Product Manager jobs
- Open Data quality-related jobs
- Open GCP-related jobs
- Open Java-related jobs
- Open Business Intelligence-related jobs
- Open ML models-related jobs
- Open Data management-related jobs
- Open Privacy-related jobs
- Open PhD-related jobs
- Open Deep Learning-related jobs
- Open Finance-related jobs
- Open Data visualization-related jobs
- Open PyTorch-related jobs
- Open APIs-related jobs
- Open TensorFlow-related jobs
- Open NLP-related jobs
- Open Consulting-related jobs
- Open Snowflake-related jobs
- Open LLMs-related jobs
- Open CI/CD-related jobs
- Open Generative AI-related jobs
- Open Kubernetes-related jobs
- Open Hadoop-related jobs
- Open Data governance-related jobs
- Open Airflow-related jobs
- Open Databricks-related jobs