Data Engineer

Apex Group; Makati; On-site; PHP 700,000 - 1,100,000; Full time

Job summary

Apex Group is seeking a Data Engineer to own the management and development of our Snowflake data warehouse, supporting ESG data models, analytics and client reporting. You will design and maintain pipelines between Oracle, Snowflake and client warehouses, enabling secure data delivery and visualization.

You'll collaborate with software engineers, data scientists and product teams, implement best-practice data models, and advance automation and security across the data platform, including Row

Qualifications

• At least 4 years of data engineering experience in a SaaS, consultancy or data-intensive environment.
• Experience with Data Warehousing and Data Modelling.
• Strong Snowflake experience including administration, schema/view design, performance optimization and security.
• Experience with ETL/ELT and data pipelines between Oracle and Snowflake and client warehouses.
• Experience with data lakes, cloud data warehouses and visualization integration.
• Proficient in SQL and Python; familiar with messaging systems and cloud workflow tools.
• Excellent communication and cross-functional collaboration skills.

Responsibilities

• Manage, develop and optimise the Holtara Snowflake data warehouse, including schemas, views, tables and environments.
• Build and maintain data pipelines between Oracle, Snowflake and client warehouses.
• Design client-specific data tables and views with Row Level Security and connect to exports and visualizations.
• Choose appropriate data engineering tools and design patterns to meet business needs.
• Prepare and expose data for downstream consumption and APIs.
• Identify improvements to move to faster data delivery and automate pipelines.
• Document and support the modern data platform and ensure security and access controls.
• Guide downstream data consumers and coordinate with internal and external teams.

Skills

Snowflake

SQL

Python

Kafka

Azure Functions

Education

Bachelor's degree in Computer Science or related

Tools

Azure Data Factory

Fivetran

Stitch

Oracle

Job description

Time zone: Must overlap a minimum of 6-4 hours with CET/GMT+1 (Madrid/London)

General description of the job

As a Data Engineer, you will own the management and development of our Snowflake data warehouse — the central repository underpinning our ESG data model, analytics and client reporting. Working alongside software engineers, data scientists, product managers, and the wider technology and architecture functions, you’ll build and maintain the pipelines that move data between our Holtara.io application database (Oracle), our Snowflake environment, and client-specific data warehouses.

Our data warehouse holds “business data” structured around our proprietary systems that lets us track, transfer, benchmark and report data across our client base. You’ll play a key role in centralizing more of this data into Snowflake, reducing manual transformations and files, and enabling downstream consumption through data visualizations (with Row Level Security) and automated exports.

As the business grows, we want our staff to grow with us, so there will be plenty of opportunities to learn and upskill. While much of the work follows business requirements and design concepts, you will also play a key role in the continuous improvement of design patterns and automation processes.

Responsibilities

Manage, develop and optimise the Holtara Snowflake data warehouse, including schemas, views, tables and environments (e.g. staging/testing environments that replicate production).

Build and maintain data pipelines and integrations between the Holtara.io application database (Oracle), Holtara Snowflake, and client-specific warehouses — including client Snowflake instances.

Design and build client‑specific data tables/views in Snowflake, applying Row Level Security (RLS) per client and connecting these to client‑facing exports and data visualizations.

Determine the most appropriate data engineering tools, methods, and design patterns to meet business requirements.

Prepare and expose data for downstream consumption, including exports and APIs.

Proactively identify and suggest improvements (e.g. moving from weekly to same‑day data delivery through more efficient pipelines).

Document, support, manage, and maintain the modern data platform built within your squad, ensuring security and data‑access requirements are maintained.

Provide guidance to downstream data consumers (analysts, product, data services, client‑facing teams).

Comply with all company policies, including data security and access‑control standards.

Requirements & Skills

At least 4 years of data engineering experience, ideally within a SaaS, consultancy and/or data‑intensive environment.

Experience with Data Warehousing and Data Modelling.

Strong hands‑on experience with Snowflake (administration, schema/view design, performance optimization and security) — essential.

Experience integrating and building pipelines to/from relational databases, particularly Oracle (and/or similar solutions such as SQL Server, PostgreSQL).

Experience with Data Lakes (Azure Data Lake).

Experience with other Cloud Data Warehouses (Azure Synapse) — desirable.

Experience with ETL/ELT/Pipeline tools (Azure Data Factory, Fivetran, Stitch).

Strong programming skills in SQL and Python (Scala or Java a plus), including writing scripts to transform and populate data (e.g. auto‑populating export templates from Snowflake).

Knowledge of messaging systems (Azure ASQ, Kafka, RabbitMQ).

Experience with cloud workflow services (Azure Logic Apps, Camunda).

Experience with event and schedule management (Azure Functions).

Experience connecting data warehouses to visualization tools, including implementing Row Level Security (RLS) for multi‑tenant, client‑facing dashboards — highly desirable.

Excellent communication and interpersonal skills, with the ability to work with internal teams (Data, Tech, Product) and external clients across multiple geographies.

Working knowledge of Agile Software Development Lifecycles.

Experience with Git‑based development workflows

Experience designing and maintaining data models, datasets and data flows that support machine learning and AI use cases.

Experience working with Oracle databases, including schema design, query optimization, data extraction and integration with downstream data platforms.

What you will get in return:

A genuinely unique opportunity to be part of an expanding large global business.

Exposure to all aspects of the business, cross‑jurisdiction and to working with senior management directly.

A dynamic, professional working environment with broad operational responsibility.

Additional information:

We are an equal opportunity employer and ensure that no applicant is subject to less favourable treatment on the grounds of gender, gender identity, marital status, race, colour, nationality, ethnicity, sexual orientation, socio‑economic, responsibilities for dependants, physical or mental disability. Any hiring decision are made on the basis of skills, qualifications and experiences.

We measure our success as a business, not only by delivering great products and services and continually increasing our assets under administration and market share, but also by how we positively impact people, society and the planet.

For more information on our commitment to Corporate Social Responsibility (CSR) please visit https://theapexgroup.com/csr-policy/

Personal data provided by job applicant(s) will be used for recruitment purposes only and will be treated strictly confidential. Such personal data can be accessed by different Apex stakeholders within and out of China for the consideration of the job application hereunder. Application made by the job applicant(s) constitutes the irrevocable consent of the job applicant for her/his personal data to be used by Apex stakeholders within or outside China for the purpose of this recruitment.