Business Systems Integration Developer

Join a team of industry professionals who value your skills and talents. At OGI Process Equipment, our goal is to hire talented and motivated people. We offer a friendly work environment with competitive wages and benefits. From engineers to welders, salespeople to sandblasters, OGI has some of the best talent in the industry. Check out our job openings, and we look forward to working with you.

The Business Systems Integration Developer is responsible for developing, maintaining, supporting, and improving software tools, data interfaces, integrations, reports, dashboards, databases, workflows, and business systems used by OGI Process Equipment. This role supports Engineering, Drafting, Manufacturing, Quality, Service, Sales, Purchasing, Accounting, and Operations by helping ensure that company systems are reliable, secure, accurate, connected, and aligned with business processes.

The Business Systems Integration Developer works across OGI's core software environment, including Epicor, PRO.File PLM, Excel, SolidWorks, SharePoint, ClickUp, SQL, VEEAM, and C Sharp/C# applications. This position requires the ability to understand operational needs, translate process requirements into practical software solutions, create and modify data interfaces through APIs, work with JSON-based data structures, support users, troubleshoot system issues, document changes, and maintain strong data integrity across connected systems.

Essential Functions

Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

Business Systems Development & Support

• Develop, maintain, troubleshoot, and improve internal software tools, reports, integrations, scripts, dashboards, forms, and workflows used by OGI departments.

• Support Epicor-related programming, reporting, data extraction, process automation, workflow support, user troubleshooting, and integration needs in coordination with business stakeholders.

• Support PRO.File PLM related configuration, data flow, document control support, process improvement, reporting, and integration needs related to engineering and product lifecycle information.

• Support Excel-based tools, including structured workbooks, templates, formulas, data validation, macros, data cleanup, reporting, and controlled operational spreadsheets.

• Support SharePoint site structures, lists, libraries, permissions coordination, document workflows, data organization, and integration with Microsoft 365 tools.

• Support ClickUp configuration, workflows, dashboards, automations, reporting, task templates, and process visibility for engineering and operational teams.

• Support SolidWorks-related data processes, engineering workflow connections, file structure coordination, and integration needs related to design, drafting, and controlled engineering information.

Programming, Database & Integration Responsibilities

• Develop and maintain applications, utilities, scripts, and integrations using C Sharp/C# and other approved development methods used by the company.

• Create, maintain, and troubleshoot SQL queries, stored procedures, views, data extracts, reports, and database-related processes supporting business operations.

• Design, develop, document, test, and maintain Application Programming Interfaces (APIs) used to exchange information between Epicor, PRO.File PLM, SharePoint, ClickUp, SQL databases, customer systems, vendor systems, and other business applications.

• Develop, modify, and maintain RESTful API integrations and other approved interface methods to automate business processes, reduce manual data entry, and improve data consistency between systems.

• Create, modify, troubleshoot, and support JSON data payload structures used for system-to-system communications, including serialization, deserialization, validation, mapping, and transformation of data.

• Design and maintain secure data interfaces between ERP, PLM, document control, engineering, manufacturing, purchasing, inventory, project management, reporting, and accounting systems.

• Develop tools and services that consume, transform, validate, and publish JSON data across multiple software platforms.

• Configure and maintain middleware, web services, API endpoints, data connectors, and authentication methods necessary to support enterprise application integrations.

• Troubleshoot API communication failures, data mapping issues, synchronization errors, authentication failures, transaction errors, and interface performance problems.

• Analyze system data for accuracy, completeness, duplication, workflow gaps, and opportunities for process improvement.

• Build and support integrations between business systems where approved, including controlled data movement between ERP, PLM, project management, file management, reporting, and engineering-related platforms.

• Assist with data imports, exports, conversions, corrections, validation, and testing while maintaining appropriate controls and documentation.

• Follow change management practices, including testing, approval, documentation, revision tracking, backup coordination, and communication before deploying changes to production systems.

System Reliability, Security & Backup Support

• Support system reliability by monitoring recurring issues, investigating root causes, documenting corrective actions, and coordinating with internal stakeholders or external vendors as required.

• Support VEEAM-related backup, recovery, verification, monitoring, and documentation activities in coordination with management and any external IT resources.

• Assist with access control, permission review, user setup support, account changes, and data protection practices for supported systems when assigned.

• Protect company, customer, financial, engineering, and proprietary information by following company security, confidentiality, and data handling requirements.

• Maintain documentation for applications, reports, scripts, integrations, data structures, API endpoints, JSON payloads, data mapping documents, backup-related processes, user instructions, and troubleshooting procedures.

• Perform other related duties as assigned.

Required Skills and Qualifications

• Strong proficiency in C Sharp/C# programming, including the ability to develop, maintain, troubleshoot, and document business applications, utilities, services, and integrations.

• Strong understanding of object-oriented programming principles, software design methodologies, debugging practices, and software lifecycle management.

• Working knowledge of SQL, including queries, data analysis, troubleshooting, views, stored procedures, reporting support, data modeling, performance considerations, and data validation.

• Demonstrated experience creating, modifying, documenting, and supporting APIs, RESTful services, web services, and system-to-system data interfaces.

• Demonstrated experience working with JSON data structures, including serialization, deserialization, validation, transformation, data mapping, payload troubleshooting, and interface testing.

• Understanding API authentication and secure access methods, including API keys, token-based authentication, OAuth concepts, and secure credential handling.

• Ability to troubleshoot integration failures, transaction errors, mapping problems, synchronization issues, timeout issues, malformed JSON payloads, authentication errors, and interface performance bottlenecks.

• Ability to support or learn Epicor ERP workflows, data structures, reports, user support requirements, business process automation, and API or data interface requirements.

• Ability to support or learn PRO.File PLM workflows, document/product data structures, revision-related processes, engineering information control requirements, and data interface requirements.

• Strong Microsoft Excel skills, including formulas, structured tables, data validation, lookup functions, reporting workbooks, piv