Reagent Chemical & Research, LLC. is seeking an Integration & Report Developer to design, build, and maintain API integration between Datacor ERP Cloud and third-party logistics platforms to ensure seamless data flow across their ERP, transportation, and supply chain systems.
Requirements
- 3–5+ years of experience in API development and system integration.
- Proficiency in RESTful APIs, JSON, XML, and webhooks.
- Strong SQL skills and experience working with relational databases.
- Experience with integration platforms or custom middleware development.
- Strong programming/scripting skills (e.g., Python, JavaScript, VB Script etc.).
- Familiarity with authentication protocols (OAuth2, API keys, etc.).
- Experience with Power BI or similar reporting/analytics platforms.
Responsibilities
- Design and develop RESTful API integrations between Datacor ERP and external platforms.
- Design and implement integration workflows using custom middleware or enterprise integration platforms such as Azure Logic etc., ensuring efficient orchestration of data across systems.
- Write and optimize SQL queries to extract, transform, and analyze data from ERP and integrated systems.
- Develop and maintain reports and dashboards using Power BI or similar business intelligence tools.
- Ensure secure, scalable, and reliable communication between systems.
- Monitor integration performance and implement logging, alerting, and error handling.
- Work with JSON data formats for API payloads, data transformation, and validation.
Other
- Collaborate with ERP analysts and business stakeholders to define integration requirements and data mappings.
- Maintain technical documentation for integrations, including API specifications, data flows, and troubleshooting guides.
- Support testing, validation, and deployment of integration workflows.
- Support data governance initiatives, ensuring data quality, consistency, and compliance across systems.
- Ability to work independently and manage multiple integration projects simultaneously.
