#997 - Data Engineer (Odoo)

Job Opportunity only available for LATAM Professionals . Venon Solutions is seeking a Senior Data Engineer to support a client's modernization of its legacy data environment and transition to an AWS-hosted architecture centered around PostgreSQL and Odoo. The current environment includes AS400 and IBM DB2/400. This role will focus on extracting, transforming, and migrating legacy data into PostgreSQL; building reliable integrations with Odoo; and enabling reporting, dashboards, and business intelligence capabilities. Responsibilities Design and implement the migration of legacy operational data into PostgreSQL within an AWS-based environment. Build and maintain ETL/ELT pipelines for scheduled data extraction, transformation, validation, and loading. Create and support a nightly proprietary data replication process for reporting and analytics. Analyze legacy data structures, mappings, and business logic in collaboration with internal stakeholders and technical subject-matter experts. Support the transition from the existing legacy environment to a PostgreSQL- and Odoo-centereddata ecosystem. Build reporting-ready datasets, views, and data models for dashboards and custom reporting. Partner with business users to translate reporting and operational needs into scalable data solutions. Ensure data quality, consistency, monitoring, security, error handling, and documentation across pipelines and integrations. Troubleshoot data discrepancies, integration failures, and performance issues. Requirements Advanced English level (B2/C1/C2) to ensure fluent communication across teams. Strong Experience as a Data Engineer. Proven experience delivering data migration , modernization, or system-integration projects. Experience migrating data from legacy databases or mainframe-style environments. Experience with AS400 / IBM i environme nts. Experience with IBM DB2, including DB2/400. Familiarity with Odoo data models and ERP-related integrations . Advanced SQL skills in MySQL , particularly PostgreSQL . Knowledge of non-relational or Open-source databases. Experience designing and building ETL/ELT pipelines and scheduled data workflows. Experience with Data Visualization tools. Experience with AWS -based data architectures and cloud services. Experience with data modeling, reporting datasets, business intelligence tools, and dashboard development. Ability to understand unfamiliar legacy systems, data structures, and business processes. Strong problem-solving and communication skills, with the ability to work directly with business and technical stakeholders. Preferred Qualifications Experience with Power BI or similar cloud-based reporting tools. Experience supporting Excel-based reporting and exports. Familiarity with retail, inventory, e-commerce, ERP, or operational-data environments. Experience using AI-assisted development and analysis tools such as Claude or Codex to accelerate documentation, data mapping, query development, and troubleshooting What do we offer? Salary in USD . 100% Remote work. Contract duration: Short-Term (with possibility of extension) Type of contract: Independent contractor with Venon Solutions LLC. Paid Holidays from the US Calendar. 2 weeks of Paid Time Off ( PTOs ). Working hours: CST full-time, fully committed.