IT Data Engineer | Hybrid | Makati | Day 1 HMO | Weekends Off

Salary: Day 1 HMO, Weekends off

Complex Data Migrations Demand Exceptional PostgreSQL and ETL Expertise

Your expertise in PostgreSQL, advanced SQL, ETL development, and Python or TypeScript scripting can make enterprise data migrations faster, safer, and more reliable. As an IT Data Engineer, you'll work directly with complex relational databases, engineer production-ready data pipelines, and reconcile critical financial and operational records as businesses transition from legacy systems to a unified, AI-native platform. With Emapta, apply your specialized technical skills to meaningful international projects, collaborate with experienced professionals, and establish a long-term global career with opportunities for continuous growth.

Your Career Snapshot

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

The Qualifications We Seek

• More than 3 years of hands-on experience in data engineering, ETL development, database development, or enterprise data migration, with strong relational database and data integration expertise.
• Advanced PostgreSQL and SQL skills, including complex queries, CTEs, window functions, indexing, constraints, query optimization, and large-scale database operations.
• Proven experience developing, executing, monitoring, and troubleshooting production ETL pipelines and data integration workflows.
• Strong Python or TypeScript/Node.js scripting skills for data extraction, transformation, and automation, using libraries such as Pandas or Polars.
• Experience in relational database design, data modeling, schema mapping, and data integrity across complex, high-volume datasets.
• Hands-on experience migrating production data from ERP, CRM, or financial systems (NetSuite, Sage, Microsoft Dynamics, QuickBooks, or SAP), including live cutovers.
• Strong data validation, reconciliation, and quality assurance skills, including control totals, boundary checks, financial balancing, trial balance verification, and resolving data discrepancies, mapping errors, and integration failures.
• Strong analytical, troubleshooting, problem-solving, and communication skills, including explaining migration results and technical issues to engineering and finance stakeholders.
• Preferred: Knowledge of accounting principles, including double-entry bookkeeping, general ledgers, trial balances, and debit/credit reconciliation.
• Advantageous: Experience with Supabase, Row-Level Security (RLS), audit trails, regulated data requirements, or lot traceability.

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

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

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.

Apply now and experience the difference!