Build the Data Backbone of Integral AI-Native Enterprise Technology

Give legacy data a future in intelligent enterprise technology. As a Data & Integrations Engineer , you'll transform complex ERP, financial, and operational data into trusted foundations for AI-powered general businesses. Deepen your PostgreSQL, ETL, Python, and integration expertise while building international career value-without leaving Colombia.

Your Career Snapshot

- Employment Type: Indefinite Term Contract
- Shift: Day Shift, Weekends Off
- Work Setup: Hybrid, Connecta 26, Colombia

Exciting Perks Await!

- 5 days work week
- Weekends off
- Hybrid work arrangement
- 20 vacation days in total
- Prepaid medicine
- Fully-customized Emapta laptop and peripherals
- Direct exposure to our clients
- Career growth opportunities
- Diverse and supportive work environment
- Prime Office Locations - Bogotá and Medellin
- Unlimited upskilling through Emapta Academy courses (Want to know more? Visit https://emapta.com/training-calendar/)

The Qualifications We Seek

- More than 3 years of relevant experience in data engineering, data migration, ETL, or a related technical field
- Advanced PostgreSQL and relational database expertise , with extensive experience writing complex SQL queries, Common Table Expressions (CTEs) , constraints, window functions, and indexing strategies across relational schemas with high migration volumes
- Strong production ETL and scripting expertise , with proven ability to develop practical, production-grade data manipulation scripts using TypeScript/Node.js or Python frameworks such as Pandas or Polars
- Strong reconciliation and validation expertise, with meticulous mathematical rigor in establishing control totals, checking boundary conditions, and verifying trial balance integrity before declaring a data load complete
- Hands-on data migration experience in extracting, cleaning, and loading complex production data from legacy ERP, financial,



or CRM systems such as NetSuite, Sage, Microsoft Dynamics, QuickBooks, or SAP , including live cutover management
- 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 , strongly preferred
- Familiarity with Supabase and Row-Level Security (RLS) enforcement , strongly preferred
- Familiarity with 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 developing an AI-native platform that unifies complex business operations through one shared data model. They provide 13 connected modules spanning CRM, finance, manufacturing, quality, supply chain, sourcing, contracts, projects, treasury, and product lifecycle management.

Their technology combines built-in AI, intelligent agents, automation, APIs, and connected workflows with powerful data migration capabilities. They help growing businesses replace fragmented legacy systems, centralize operational data, streamline processes, strengthen visibility, and scale through intelligent enterprise technology.

Join the Top 1% Talent. A Better Career. A Better Life.

Join Emapta Latam and contribute to our legacy of transforming global outsourcing. Since 2010, Emapta has pioneered personalized outsourcing solutions, empowering businesses to thrive with bespoke teams and seamless integration. Our commitment to excellence is reflected in our state-of-the-art facilities, competitive compensation, and a supportive work environment that fosters professional growth.

With over 1,200 clients worldwide and a team of more than 12,000 talented professionals , Emapta continues to set new standards in the industry.

Apply now to be part of our success story in Colombia, where your skills are valued, and your career ambitions are supported.

EmaptaEra

📌 Data & Integrations Engineer (Bogotá)
🏢 Emapta Global
📍 Bogotá