Data Integration Developer

Data Integration Developer

Requirements

• Bachelor’s degree in Computer Science, Data Engineering, Information Systems, or a related field.
• 10+ years of experience in data engineering and integration, focusing on ETL/ELT processes and system connectivity.
• Experience integrating core applications like the ERP, MES, & PLM to each other and downstream applications.
• Hands-on experience with NetSuite ERP, including customization, integration.
• Proven experience developing and maintaining web applications, ideally for custom MES or similar systems.
• Strong proficiency in SuiteScript 2.0 for scripting, custom records, workflows, and Suitelets.
• Experience with SuiteCloud Development Framework for building and deploying custom applications.
• Proficiency in HTML for creating custom UI components, forms, and Suitelets in NetSuite.
• Familiarity with SuiteTalk (SOAP/REST APIs), SuiteAnalytics, and ODBC for data extraction and integration.
• Strong proficiency in React, JavaScript, and TypeScript for building and maintaining the MES.
• Experience with unit testing, integration, and end-to-end test frameworks (e.g., Jest, Cypress, CodeceptJS) to ensure MES application reliability.
• Familiarity with modern front-end build pipelines and tools (e.g., Babel, Webpack, NPM) for efficient MES development workflows.
• Experience with version control via Git/GitHub for collaborative MES development.
• Knowledge of modern authorization mechanisms, such as JSON Web Token (JWT), for secure MES application access.
• Proficiency in programming languages like Python, Java, or Node.js for data processing and integration.
• Strong SQL knowledge for querying and transforming data.
• Experience with cloud platforms (e.g., AWS, Azure, Google Cloud) and data services (e.g., AWS Glue, Azure Data Factory).
• Familiarity with data warehousing solutions (e.g., Snowflake, Redshift, BigQuery).
• Knowledge of APIs, middleware, ODBC, and integration patterns (e.g., REST, SOAP).
• Experience with version control systems (e.g., Git) and CI/CD pipelines.
• Strong problem-solving and analytical skills.
• Excellent communication and collaboration abilities.
• Ability to manage multiple priorities in a fast-paced environment.

Responsibilities

• Design, build, and optimize scalable data pipelines for ETL/ELT processes, extracting, transforming, and loading data from NetSuite ERP, custom MES, and other systems into data warehouses or integration platforms.
• Develop and maintain integrations between NetSuite ERP, custom MES, and third-party systems using APIs, middleware, ODBC, and integration tools to ensure real-time data synchronization and interoperability.
• Leverage SuiteScript 2.0 and SuiteCloud Development Framework to create custom scripts, workflows, forms, and integrations within NetSuite. Use HTML for custom UI components and Suitelets to enhance user experience.
• Contribute to the development and maintenance of the custom MES, using React, JavaScript, and TypeScript to build robust, user-friendly interfaces and backend logic for manufacturing operations. Implement unit, integration, and end-to-end tests to ensure code quality.
• Create and maintain data models to support analytics, reporting, and operational needs across enterprise systems.
• Implement data validation, cleansing, and monitoring to ensure data accuracy, consistency, and compliance with organizational standards.
• Optimize data pipelines, integrations, and application performance for scalability and reliability.
• Work with cross-functional teams, including business analysts, developers, and data scientists, to gather requirements and deliver data solutions.
• Document data pipelines, integration workflows, custom scripts, and system architectures for maintainability and knowledge transfer.
• Monitor and resolve issues in data pipelines, integrations, NetSuite customizations, and MES functionalities, ensuring minimal downtime.

Preferred Qualifications

• Experience with integration platforms like Celigo, MuleSoft, or Dell Boomi (NetSuite-specific).
• Familiarity with real-time data streaming technologies (e.g., Apache Kafka, AWS Kinesis).
• Knowledge of manufacturing processes and their data requirements, aligned with ISA-95 standards.
• Experience with Tailwind CSS or similar frameworks for MES UI development.
• Experience using and contributing to UI design systems to ensure consistent and reusable MES interfaces.
• Experience using Apollo Client or Urql for efficient GraphQL data fetching and state management in MES applications.
• Certifications in NetSuite (e.g., SuiteFoundation, SuiteCloud Developer) or cloud platforms.