Data Pipeline Architect (12-Month Contract)

OneOcean Group; Cebu City; On-site; PHP 650,000 - 900,000; Full time

Job summary

OneOcean is seeking a Database Specialist to design, develop and maintain data ingestion, transformation, and modelling pipelines as part of our analytics landscape and wider data ecosystem. In this role you will provide the right data at the right time to enable decision making by internal stakeholders and our customers.

We are embarking on an exciting journey, re-designing our company's approach to data and reporting.

Qualifications

• Experience with databases on-premises and cloud environments (MSSQL, MySQL, PostgreSQL, SQL Azure, Aurora MySQL).
• Understanding of data management, cleansing and query optimization for pipelines.
• Experience with cloud technologies (AWS).
• Scripting in JavaScript or C# and CI/CD with source control.

Responsibilities

• Create and maintain data pipeline architecture from multiple sources.
• Assemble large, complex data sets to meet business requirements.
• Identify and implement internal process improvements; automate data delivery.
• Build infrastructure for ETL/ELT data extraction and loading from diverse sources.
• Ensure robust data validation and data quality for reporting.
• Develop and maintain data warehousing, modelling and pipelining for storage/retrieval.
• Keep data separated and secure per best practices.
• Ensure data from information sources is accurate and coordinate with other functions.
• Stay up-to-date with latest cloud data technology.
• Produce documentation: data models, specifications, and data operation communications.
• Provide data exports for verification and external system integrations.
• Data mining and analysis; migrate documents as needed.
• Experience with REST API usage and integration.
• Communicate outputs effectively to stakeholders; work in fast-paced environments.

Skills

SQL databases

Data modelling

Data warehousing

Cloud technologies

Scripting (JavaScript/C#)

REST API

CI/CD

PowerBI/BI tools

English communication

Team collaboration

Tools

MSSQL

MySQL

PostgreSQL

SQL Azure

Aurora MySQL

AWS

Python

Bitbucket

Liquibase

Jenkins

Octopus

Job description

OneOcean is seeking a Database Specialist to design, develop and maintain data ingestion, transformation, and modelling pipelines as part of our analytics landscape and wider data ecosystem. In this role you will provide the right data at the right time to enable decision making by internal stakeholders and our customers.

We are embarking on an exciting journey, re-designing our company's approach to data and reporting.