Senior Data Engineer, Octopus Investments
+ Bonus + Share incentive plan
3 days a week in office (Holborn, London)
Ethical Investments
Posted today
Ethical Investments
501-1000 employees
Posted today
+ Bonus + Share incentive plan
3 days a week in office (Holborn, London)
501-1000 employees
Company mission
Octopus Group is a B Corp whose mission is to invest in the people, ideas and industries that will help change the world.
Role
Who you are
- We look for those with an entrepreneurial spirit and the culture here allows those with creativity to flourish
- Knowledge in writing complex SQL and ability to analyse data, and experience in migration of data across various systems
- You can work with data in various data formats including database, parquet files, hierarchical json/xml, delimited files and excel
- A track record of designing and implementing complex modern data warehouse solutions
- Good knowledge in working with various Rest API protocols
- Excellent communication skills to capture requirements, manage relationships with stakeholders and articulate the solution
What the job involves
- This is a hands on, busy role where you’ll be able to utilise your skills and experience whilst also driving efficiencies, designing and implementing models for reporting and analysis, and working across a variety of projects
- You will join the data engineering team, reporting into the head of data engineering
- The team consists of 6 developers with extensive experience in data processing, storage, and analysis
- They manage the central data warehouse and offer data engineering expertise across various business projects, including data migration, cleansing, analysis, and reporting
- There’s a real focus on collaboration, knowledge sharing and feedback to support the growth of the team and drive impact for our stakeholders
- You will play a key part in transforming Octopus to a data-driven organization. Demonstrating a passion for data and finding interesting ways to innovate data development, you’ll 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
- 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
- Be part of various projects across software development, and data migration with active involvement in database design and migration
Salary benchmarks
Our take
Octopus is a group of companies investing in innovative ideas from various industries. The Octopus Group incorporates Octopus Energy, Octopus Real Estate, Octopus Investments, Octopus Ventures and Octopus Labs.
Across its financial services business, the company cares as much about the impact its investments have as it does about the returns it generates for its investors.
Since its inception, the company has grown significantly and has more than 3 million domestic customers and now actively operates in 18 countries.
Steph
Company Specialist at Welcome to the Jungle
Meet the team
10 people
Jessica Bourdon-Pierre, Portfolio Manager
Insights
Company
Employee endorsements
Flexible working
"Your job and your life can be organised flexibly. I do school runs and finish early to get family time and catch up in evenings on missed time. "
Company benefits
- Critical Illness Cover & Death In Service
- Health Insurance
- Pension Plan
- Performance Bonus
- Share Incentive Plan
- Hybrid Working (3 days in the office, 2 days remote)
- Childcare Vouchers
- Sick pay
- 'Take what you need' Annual leave
- £3000 Bike to Work Scheme
- Employee Discount Portal
- Professional Development & Training
- Monthly 'Drink Up'
- The Greatest Christmas Party Ever
Company values
- Be Helpful: We like people who behave like it’s always day one and who remember that without our customers there is no business.
- Be Straightforward: We like people who have opinions and who express them in a way that’s respectful and easy to understand
- Be Bold: We like people who make decisions quickly and who are OK changing their mind if it turns out there’s a better way of doing things
Company HQ
Holborn, London, UK
Articles
Leadership
Simon Rogerson
(Co-Founder & CEO)Previously worked at Octopus Investments for 20 years, first as Chief Executive and co-founder for 19 years and then as Executive Chairman for 1 year.
Chris Hulatt
(Co-Founder)Previously Investment Manager at Mercury Asset Management for 2 years and Non Executive Director at ClearlySo for 4 years.
Diversity, Equity & Inclusion at Octopus Investments
Riean Stewart (Portfolio Talent Associate)
- 50/50 gender split across all senior leadership roles (currently 43% female / 57% male)
- 15% of managerial roles and above will be held by people from an ethnic background (Currently 8%)
- We partner with Black Young Professionals network, Investment 2020, Work180, Women in Finance, 10,000 Black Interns and more to promote D&I at Octopus and in the Investments industry
- We host events aimed at women in the financial services industry and how we can attract & support people in this space
- We host internal D&I events on how to support ethnic backgrounds in the workplace, Neurodiversity and more!
Share this job
View 2 more jobs at Octopus Investments