Data Engineer

theapexgroup; Philippines; On-site; PHP 1,000,000 - 1,800,000; Full time

Job summary

The Apex Group is hiring a Data Engineer in Makati City. You will own the Snowflake data warehouse, build pipelines between Oracle, Snowflake, and client warehouses, and implement row-level security for client dashboards.

You will work with software engineers, data scientists, and product teams to centralize data, automate exports, and improve data delivery. Opportunities to learn and grow are available in a collaborative, global environment.

Qualifications

• At least 4 years of data engineering experience in SaaS/consultancy or data-heavy environments.
• Experience with Data Warehousing and Data Modelling.
• Strong Snowflake expertise (administration, schema/view design, security).
• Experience integrating pipelines to/from Oracle and relational databases.
• Experience with Data Lakes and Azure cloud data warehouses (Azure Synapse).
• ETL/ELT tools: Azure Data Factory, Fivetran, Stitch.
• Proficient in SQL and Python; scripting for data exports.
• Knowledge of messaging systems (Azure ASQ, Kafka, RabbitMQ).
• Experience with cloud workflow tools (Azure Logic Apps, Camunda) and scheduling (Azure Functions).
• Ability to collaborate with cross-geo teams and external clients.

Responsibilities

• Manage and optimise the Holtara Snowflake data warehouse including schemas, views, and environments.
• Build and maintain data pipelines between Oracle, Holtara Snowflake, and client warehouses.
• Create client-specific Snowflake tables/views with Row Level Security for multi-tenant dashboards.
• Choose data engineering tools and design patterns to meet business needs.
• Prepare and expose data for exports and APIs for downstream consumption.
• Suggest pipeline optimisations, e.g., faster data delivery.
• Document and support the data platform within the squad with security in mind.
• Guide downstream data consumers and teams across locations.
• Ensure compliance with data security and access policies.

Skills

Data engineering

SQL

Python

Communication skills

Tools

Snowflake

Azure Data Factory

Fivetran

Stitch

Azure Synapse

Azure Data Lake

Kafka

RabbitMQ

Job description

The Apex Group was established in Bermuda in 2003 and is now one of the world's largest fund administration and middle office solutions providers.

Our business is unique in its ability to reach globally, service locally and provide cross-jurisdictional services. With our clients at the heart of everything we do, our hard-working team has successfully delivered on an unprecedented growth and transformation journey, and we are now represented by over circa 13,000 employees across 112 offices worldwide.Your career with us should reflect your energy and passion.

That\'s why, at Apex Group, we will do more than simply 'empower' you. We will work to supercharge your unique skills and experience.

Take the lead and we\'ll give you the freedom to be a positive disrupter and turn big ideas into bold, industry-changing realities.

For our business, for clients, and for you

Position: Data Engineer

Location: Makati city, Ayala Avenue

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, 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.


• API management / development experience - desirable.


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