Database Specialist

OneOcean Group; Philippines; On-site; PHP 600,000 - 1,200,000; Full time

Job summary

OneOcean is hiring a Database Specialist in the Philippines. You will design, develop and maintain data ingestion, transformation and modelling pipelines as part of our analytics landscape and data ecosystem.

The role focuses on providing timely, accurate data to internal stakeholders and customers to enable informed decision making. We are re-designing our data/reporting approach and looking for innovative data professionals to help deliver value from data to the business and customers.

Qualifications

• Experience with MSSQL/MySQL/PostgreSQL on-premises or cloud.
• Knowledge of data management, cleansing and query optimisation.
• Experience with cloud technologies (AWS preferred).
• Scripting in JavaScript or C#.
• Strong problem-solving and numerical abilities.
• Experience with CI/CD and source control.
• Model datasets for BI visualisation (PowerBI).
• Excellent stakeholder communication skills.
• Ability to work under tight deadlines in fast-paced environments.
• Experience with REST APIs.

Responsibilities

• Create and maintain data pipeline architecture from multiple sources.
• Assemble large, complex data sets meeting business requirements.
• Identify and implement internal process improvements for data delivery.
• Build infrastructure for ETL/ELT from diverse sources.
• Ensure robust data validation for reporting accuracy.
• Develop and maintain data warehousing models and pipelines.
• Keep data secure and separated per best practices.
• Coordinate with business units to ensure data availability.
• Stay up-to-date with cloud data technologies.
• Document data models and operations for effective use.

Skills

SQL databases

Cloud data platforms

Data pipelines

Scripting (JavaScript/C#)

CI/CD & Source control

Data modelling

PowerBI data viz

Stakeholder management

English communication

Problem solving

ETL/ELT pipelines

REST API

Tools

AWS Glue

Jenkins

Bitbucket

Liquibase

Python

PowerBI

Job description

Database Specialist

Department: Operations

Employment Type: Fixed Term Contract

Location: Philippines

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 note 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