Database Specialist

Description

Discover OneOcean:

OneOcean is a unified brand born from the integration of OneOcean and Ocean Technologies Group.

Owned by Lloyd’s Register, an organisation with more than 260 years of trust, integrity and leadership at sea, OneOcean combines the agility and ambition of a fast-moving innovator with the strength and stability of one of the world’s most trusted maritime institutions.

At the heart of OneOcean is a portfolio unlike any other in maritime. A comprehensive, integrated portfolio built on years of expertise, trusted by thousands of maritime professionals around the world.

Our Mission: Our mission is clear. In the race to zero emissions, our research, advisory and technical expertise and industry-firsts are supporting a safe, sustainable maritime energy transition. Today we are a leading provider of classification and compliance services to the marine and offshore industries, helping our clients design, construct and operate their assets to accepted levels of safety and environmental compliance.

Why Join OneOcean Crew?

• Legacy & Innovation: We were created more than 260 years ago as the world’s first marine classification society to improve and set standards for the safety of ships.
• Global Impact: Our digital solutions are relied upon by more than 30,000 vessels, following the acquisition of OneOcean in 2022 and Ocean Technologies Group in 2024.
• Product Offering: Covering five proven product areas - learning, fleet operations, compliance, voyage planning and performance management - supporting its customers from ship to shore, from training and people operations, to voyage compliance and optimisation.

Navigating the position: Database Specialist
OneOcean is looking to recruit a Database Specialist.In this role you will be designing, developing, and maintaining data ingestion, transformation, and modelling pipelines as part of the organisation's analytics landscape and wider data ecosystem. In this critical role you will provide the right data at the right time to enable decision making by both internal stakeholders and our customers.

We are embarking on an exciting journey, re-designing our company's approach to data and reporting. We want to revolutionise the way we deliver value from data to our business and customers and we're looking for innovative data professionals to help us realise that vision.

**Please not this is a 12 month fixed term contract**

Key Responsibilities

• Create and maintain optimal data pipeline architecture from multiple data sources.
• Assemble large, complex data sets that meet functional/non-functional business requirements.
• Identify, design, and implement internal process improvements: automating manual processes, optimising data delivery, re-designing infrastructure for greater scalability, etc.
• Build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources.
• Ensure robust data validation and verification processes to ensure the correctness of data for reporting.
• Develop and maintain data warehousing approaches, including the modelling, and pipelining of data for storage and retrieval.
• Keeping data separated and secure as per best practice guidelines.
• Ensure that the data taken from the information sources is accurate, liaising with other business functions when necessary.
• Proactively keep up to date with the latest cloud data technology
• Produce supporting documentation, such as specifications, data models, relation between data and other data objects, required for the effective development, usage, and communication of the data operations solutions with different business units, as and when required to ensure that overall objectives are met.
• Providing data exports for customer verification and sunsetting customers.
• Providing data exports as seed data for external systems integrations.
• Data mining & analysis.
• Documents migration.

Skills, Knowledge and Expertise

• Experience working with databases on-premises and/or cloud-based environments such as MSSQL, MySQL, PostgreSQL, SQL Azure, Aurora MySQL etc. Microsoft Accredited or Industry recognized qualification for Microsoft SQL server will be preferred.
• Good understanding on how data management, cleansing and query optimisation influences pipeline and data model design.
• Experience using cloud technologies (AWS preferred)
• Experience with scripting languages (e. g. Java Script, C#)
• Demonstrably strong problem-solving skills to help design and implement solutions to data problems. Highly numerate and logical
• Experience of CICD technologies and Source control.
• Understand and apply infrastructure knowledge to develop and maintain an efficient environment.
• Modelling datasets in a way applicable for use in different visualisation tools (e. g. PowerBI)
• Strong stakeholder management skills
• Ability to clearly communicate and present outputs to stakeholders.
• Experience of working in fast paced environments to strict deadlines.
• Team player and can communicate effectively to technical and non-technical colleagues.
• Passionate about continuous improvement, collaboration and knowledge sharing.
• The ability to manage time, prioritise tasks, self-review your work and produce deliverables of a high quality under tight client deadlines in time pressured environments.
• It would be useful if you've got experience with some of these technologies- AWS Glue, AWS RDS, AWS Aurora, AWS S3, Amazon Athena, Amazon EMR, PostgreSQL, Python, Bitbucket, Liquibase, Jenkins, Octopus.
• Experience working with REST API.
• Good command of the English language written and oral

Nice to have

• Experience with building and maintaining ETL/ELT pipelines with SnapLogic as part of an automated workflow on high-volume, high-dimensionality data from varying sources.
• Experience of using project tracking and reporting system Monday, Zendesk
• Maritime sector experience

About OneOcean Group Limited

OneOcean is transforming the future of maritime intelligence. Born from the integration of LR OneOcean and Ocean Technologies Group, we unite decades of maritime expertise with cutting-edge digital innovation under one powerful brand. Our comprehensive portfolio spansLearning, Fleet Operations, Compliance, Voyage Planning, and Performance Management— trusted by thousands of maritime professionals worldwide. By connecting ship and shore, people and data, we help organisations operate more safely, efficiently, and sustainably through real-time intelligence and predictive insights.

We are part of Lloyd’s Register (LR) a global leader in marine and offshore engineering, technology, and digital solutions. With over260 years of trust, integrity, and leadership at sea, LR supports more than30,000 vessels worldwide. Together, OneOcean and LR combine the agility of innovation with the strength of a world-renowned institution, driving digital transformation and shaping a more connected, sustainable maritime industry.