IBP Data Engineer

Bestica Inc.; East Hanover (NJ); On-site; USD 110,000 - 160,000; Full time

Job summary

Bestica Inc. in the United States seeks an experienced O9 / IBP Data Engineer to design and maintain data pipelines connecting ERP systems to o9 Solutions, ensuring data quality and integrity.

You will work on data mapping, master data management, and data governance within a supply chain context, collaborating with ERP teams and data engineers to deliver scalable solutions.

Qualifications

• Minimum 5+ years of experience in data engineering, ETL development, or data integration projects.
• Hands-on experience with o9 Solutions / o9 DigitalBrain, including data models, APIs, and integration requirements.
• Strong proficiency in ETL/ELT tools (e.g., SAP Data Services, Talend, Informatica, MuleSoft, custom Python/SQL) or equivalent programming experience.
• Expert-level SQL skills and experience designing and optimizing database queries and transformations.
• Deep understanding of o9 data models, planning data structures, and master data requirements.
• Experience integrating with enterprise ERP systems (SAP, Oracle, Microsoft Dynamics, etc.).
• Strong knowledge of data integration concepts: data mapping, master data management, reference data, and data quality frameworks.
• Experience with API development and RESTful/SOAP web services.
• Proficiency in version control systems (Git) and CI/CD pipelines.
• Strong analytical skills, problem-solving abilities, and attention to detail.
• Experience with SIT/UAT activities and production deployments.

Responsibilities

• Design and architect end-to-end data integration solutions between ERP systems (SAP, Oracle, etc.) and o9 Solutions.
• Define data flow requirements, integration patterns, and technical specifications for master data and transactional data.
• Evaluate and recommend integration tools and technologies based on requirements and scalability.
• Develop and maintain ETL processes and data pipelines for ingesting data from ERP and other source systems into o9.
• Build data transformation logic, mapping rules, and complex business logic to ensure accurate data representation in o9.
• Implement data validation, cleansing, and reconciliation processes to maintain data quality and integrity.
• Data Mapping & Master Data Management and documentation across source systems and o9 models.
• Support master data ingestion and synchronization (products, locations, suppliers, customers, hierarchies).
• Implement data governance standards and manage data lineage and versioning.
• Monitor data pipelines, identify data quality issues, and perform root-cause analysis of integration failures.
• Develop data validation rules, quality metrics, and automated alerting mechanisms.
• Troubleshoot data discrepancies and implement corrective actions.
• Participate in data validation activities during SIT, UAT, and production cutover.
• Support data migration activities, parallel runs, and reconciliation during go-live.
• Develop regression test plans and data-related test cases for integration and functional testing.
• Provide ongoing production support for data pipelines, including monitoring, troubleshooting, and performance optimization.

Skills

o9 Solutions

ETL development

SQL proficiency

Data integration

APIs & web services

Git & CI/CD

Python scripting

Tools

SAP Data Services

Talend

Informatica

MuleSoft

Python

SQL

Job description

We are seeking an experienced O9 / IBP Data Engineer with strong expertise in data integration, ETL development, and data engineering practices. The ideal candidate will design and maintain robustdata pipelines that connect ERP systems to o9 Solutions, ensuring data quality, consistency, and integrity. This role combines technical proficiency with an understanding of supply chain data models and o9 platform architecture to drive successful implementations and ongoing data management.

Key Responsibilities

• Design and architect end-to-end data integration solutionsbetween ERP systems(SAP, Oracle, etc.) and o9 Solutions.
• Define data flow requirements, integration patterns, and technical specifications for master data and transactional data.
• Evaluate and recommend integration tools and technologies (APIs, middleware, customcode) based on requirements and scalability.
• Develop and maintain ETL processes and data pipelinesfor ingesting data from ERP and other source systemsinto o9.
• Build data transformation logic, mapping rules,and complex businesslogic to ensureaccurate data representation in o9.
• Implement data validation, cleansing, and reconciliation processesto maintain data quality and integrity.
• Data Mapping & MasterData Management
• Create and maintain comprehensive data mapping documentation between source systemsand o9 data models.
• Support master data management (products, locations, suppliers, customers, hierarchies) ingestion and synchronization.
• Implement data governance standardsand manage data lineage and versioning.
• Data Quality & Troubleshooting
• Monitor data pipelines, identifydata quality issues,and perform root-cause analysis of integration failures.
• Develop and implement data validation rules,quality metrics, and automated alertingmechanisms.
• Troubleshoot data discrepancies, reconciledata between systems,and implement corrective actions.
• Testing & Deployment Support
• Participate in data validation activities during SIT, UAT, and production cutover.
• Support data migration activities, parallel runs, and reconciliation duringgo-live.
• Develop regression test plans and data-related test cases for integration and functional testing.
• Production Support& Optimization
• Provide ongoing production supportfor data pipelines, including monitoring, troubleshooting, and performance optimization.

Required Skills & Experience

• Minimum 5+ years of experience in data engineering, ETL development, or data integration projects.
• Hands-on experience with o9 Solutions / o9 DigitalBrain, including data models, APIs, and integration requirements.
• Strong proficiency in ETL/ELTtools (e.g., SAP Data Services, Talend, Informatica, MuleSoft,custom Python/SQL) or equivalent programming experience.
• Expert-level SQL skills and experience designingand optimizing databasequeries and transformations.
• Deep understanding of o9 data models,planning data structures, and master data requirements.
• Experience integrating with enterprise ERP systems (SAP, Oracle, MicrosoftDynamics, etc.).
• Strong knowledge of data integration concepts:data mapping, masterdata management, referencedata, and data quality frameworks.
• Experience with API development and RESTful/SOAP web services.
• Proficiency in version controlsystems (Git) and CI/CD pipelines.
• Strong analytical skills, problem-solving abilities, and attention to detail.
• Experience with SIT/UAT activities and production deployments.

Preferred Qualifications

• o9 Solutions certification or advanced technical training.
• Experience with cloud-based data platforms (Snowflake, BigQuery, Azure Data Lake, AWS).
• Programming experience with Python, Java,or Scala for data processing.
• Experience with data warehousing and dimensional modeling(Kimball, Inmon methodologies).
• Knowledge of supply chain planning conceptsand data requirements.
• Experience with monitoring and logging tools (Splunk, DataDog,etc.).
• Agile/Scrum experience and familiarity with agile development practices.