IBP Data Engineer at Bestica Inc. IBP Data Engineer at Bestica Inc. in Convent Station, New Jersey Posted in about 5 hours ago.

Type:

full-time

Job Description:

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 Data Integration Architecture & Design 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. ETL/Data Pipeline Development 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. Optimize pipeline performance, manage data volumes,and ensure SLA compliance for data delivery. 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.