Build the Data Backbone of Integral AI-Native Enterprise TechnologyGive 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 global businesses.
Deepen your PostgreSQL, ETL, Python, and integration expertise while building international career value-without leaving Colombia.Employment Type: Indefinite Term ContractWork Setup: Hybrid, Connecta 26, Colombia5 days work week20 vacation days in totalFully-customized Emapta laptop and peripheralsDirect exposure to our clientsDiverse and supportive work environmentUnlimited upskilling through Emapta Academy courses (Want to know more? Visit Qualifications We SeekMore than 3 years of relevant experience in data engineering, data migration, ETL, or a related technical fieldAdvanced 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 volumesStrong 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 PolarsStrong 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 completeHands-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 managementStrong written and technical communication skills, with the ability to clearly explain data anomalies, mapping exceptions, and reconciliation summaries to technical leads and customer finance teamsFamiliarity with accounting principles, including double-entry bookkeeping, trial balances, and debit/credit balancing, strongly preferredFamiliarity with Supabase and Row-Level Security (RLS) enforcement, strongly preferredFamiliarity with regulated data requirements, including audit trails and lot traceability, strongly preferredYour Daily TasksIngest, inspect, and profile complex legacy customer data from CSV, JSON, and direct database extractsProcess complex datasets, including bills of materials, item master records, multi-currency open AR/AP, historical lot genealogy, vendor catalogs, and customer ledgersETL & Transformation ScriptingDevelop clean, maintainable data transformation and loading scripts using Python or TypeScript/Node.jsMap and load legacy datasets accurately into PostgreSQL schemasEstablish strict reconciliation protocols across migrated financial, inventory, and operational dataPerform row-count verification, checksum validation, hash comparisons, general ledger trial balance tie-outs, and lot quantity reconciliationRecurring Ingestion Feeds & ConnectorsBuild, deploy, and monitor recurring data feeds,



including retailer point-of-sale files, EDI and supplier feeds, and document-parsing inputsImplement active anomaly detection and data-freshness alerts across recurring ingestion processesConvert bespoke, one-off migration scripts into reusable, modular importer toolsReduce customer onboarding time from weeks to days through scalable migration architectureAbout the ClientOur 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 ****, 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.
#J-*****-Ljbffr

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