Data & Integrations Engineer | Hybrid | Makati | Night Shift | Day 1 HMO

Emapta; Metro Manila; Hybrid; PHP 900,000 - 1,500,000; Full time

Benefits offered by this job

Day 1 HMO coverage with free dependent

Competitive Salary Package

Night differential pay

Hybrid work arrangement

Prime office location in Makati

Fixed weekends off

Salary Advance Program

Upskilling through Emapta Academy

Gym access 24/7

Lifestyle perks

Employee referral incentives

Government benefits

20 annual leaves

Mentorship & global exposure

Career growth opportunities

Job summary

Emapta in the Philippines seeks a Data & Integrations Engineer to transform migrations, ETL pipelines, and integrations into trusted operational foundations. You will apply PostgreSQL and scripting expertise to complex enterprise data challenges while supporting global IT initiatives from Manila.

The role offers full-time employment, a hybrid setup in Makati, night shift with weekends off, competitive salary, and a range of perks from medical coverage to skills development through Emapta

Qualifications

• More than 3 years of relevant professional experience.
• Advanced PostgreSQL and relational database expertise, with complex SQL queries, CTEs, constraints, window functions, and indexing strategies across high-migration schemas.
• Proven production ETL and scripting expertise using Python or TypeScript/Node.js.

Responsibilities

• Ingest, profile, and process legacy customer data from CSV, JSON, and DB extracts.
• Develop data transformation and loading scripts in Python or TypeScript/Node.js.
• Map and load legacy datasets into PostgreSQL schemas with accuracy.

Skills

PostgreSQL

ETL scripting

Data migration

SQL proficiency

Python/TypeScript

Data reconciliation

Supabase

RLS

Pandas

Polars

Tools

Pandas

Polars

Job description

Engineer Trusted Data Foundations for AI-Native Enterprise Operations

Complex enterprise systems are only as powerful as the data behind them. Bring order to legacy data as a Data & Integrations Engineer, transforming migrations, ETL pipelines, and integrations into trusted operational foundations. Apply your PostgreSQL and scripting expertise to global IT challenges and advance your international career without leaving the Philippines.

Your Career Snapshot

• Employment Type: Full-time
• Shift: Night Shift, Weekends Off
• Work Setup: Hybrid, Makati

Exciting Perks Await!

• Day 1 HMO coverage with free dependent
• Competitive Salary Package
• Night differential pay to maximize your earnings
• Hybrid work arrangement
• Prime office location in Makati (Easy access to MRT stations, restaurants, and banks)
• Fixed weekends off
• Salary Advance Program through our banking partner (Eligibility and approval subject to bank assessment. Available to account holders with minimum of 6 months company tenure.)
• Unlimited upskilling through Emapta Academy courses (Want to know more? Visit: https://emapta.com/training-calendar/))
• Free 24/7 access to our office gyms (Ortigas and Makati) with a free physical fitness trainer!
• Exclusive Emapta Lifestyle perks (hotel and restaurant discounts, and more!)
• Unlimited opportunities for employee referral incentives across the organization
• Standard government and Emapta benefits
• Total of 20 annual leaves to be used at your own discretion (including 5 credits convertible to cash)
• Fun engagement activities for employees
• Mentorship and exposure to global leaders and teams
• Career growth opportunities
• Diverse and supportive work environment

The Qualifications We Seek

• More than 3 years of relevant professional experience
• Advanced PostgreSQL and relational database expertise, with extensive experience in complex SQL queries, Common Table Expressions (CTEs), constraints, window functions, and indexing strategies across relational schemas with high migration volumes
• Proven production ETL and scripting expertise, with the ability to develop practical, production-grade data manipulation scripts using TypeScript/Node.js or Python libraries such as Pandas or Polars
• Meticulous approach to data reconciliation and validation, with strong mathematical rigor and a consistent practice of establishing control totals, checking boundary conditions, and verifying trial balance integrity before declaring a data load complete
• Hands-on data migration experience, with the ability to extract, clean, transform, and load complex production data from legacy ERP, financial, or CRM systems such as NetSuite, Sage, Dynamics, QuickBooks, or SAP and manage live cutovers
• Strong written and technical communication skills, with the ability to clearly explain data anomalies, mapping exceptions, and reconciliation summaries to technical leads and customer finance teams
• Familiarity with accounting principles, including double-entry bookkeeping, trial balances, and debit/credit balancing; Supabase and RLS enforcement; or regulated data requirements, including audit trails and lot traceability, strongly preferred

Your Daily Tasks

Enterprise Legacy Data Migrations

• Ingest, inspect, and profile complex legacy customer data from CSV, JSON, and direct database extracts
• Process complex datasets, including bills of materials, item master records, multi-currency open AR/AP, historical lot genealogy, vendor catalogs, and customer ledgers

ETL & Transformation Scripting

• Develop clean, maintainable data transformation and loading scripts using Python or TypeScript/Node.js
• Map and load legacy datasets accurately into PostgreSQL schemas

Auditing & Financial/Inventory Reconciliation

• Establish strict reconciliation protocols across migrated financial, inventory, and operational data
• Perform row-count verification, checksum validation, hash comparisons, general ledger trial balance tie-outs, and lot quantity reconciliation
• Verify zero data loss or silent mutation before production cutover

Recurring Ingestion Feeds & Connectors

• Build, deploy, and monitor recurring data feeds, including retailer point-of-sale files, EDI and supplier feeds, and document-parsing inputs
• Implement active anomaly detection and data-freshness alerts across recurring ingestion processes

Migration Tooling Architecture

• Convert bespoke, one-off migration scripts into reusable, modular importer tools
• Reduce customer onboarding time from weeks to days through scalable migration architecture

About the Client

Our client is an enterprise technology company behind an AI-native platform designed to unify critical business operations through one shared data model. They provide integrated capabilities across ERP, CRM, finance, manufacturing, quality, supply chain, sourcing, treasury, contracts, and product lifecycle management. Their technology connects data, workflows, and operational teams while simplifying migration from legacy systems. Through built-in automation, AI, validation, reconciliation, and enterprise controls, they help growing businesses replace fragmented software, improve visibility, streamline operations, and scale confidently.

Join the Top 1% Talent. A better career. A better life.

Welcome to Emapta Philippines: home to professionals who choose growth, balance, and impact. Recognized as one of HR Asia's Best Companies to Work For in Asia 2025 and winner of Inspiring Workplaces Australasia 2026, Emapta offers more than opportunities -- it provides a career environment where people thrive. Collaborate with global teams, build meaningful expertise, and grow in a culture that prioritizes both performance and well-being.