Industrial Engineering Systems Integration Specialist

Duties:
Responsible for designing, developing, and maintaining automated tools and workflows that enhance business and engineering processes. This role leverages advanced programming, data integration, and process modeling techniques to optimize operations across multiple enterprise platforms, including SAP, SharePoint, and MEMEX systems. Responsible for developing and maintaining automation tools, workflows, and data integrations to optimize engineering and business processes across platforms like SAP, SharePoint, and MEMEX.

Develops and maintains in-house engineering tools using Visual Basic for Applications (VBA). Creates batch scripts for scheduled maintenance of back-end systems, databases and servers. Designs, implements, and maintains workflows using Microsoft Power Automate to streamline business and engineering processes including flows with JSON-based logic, data parsing and structured data transformation. Customizes SharePoint UI using JSON formatting for views, forms, and conditional formatting.

Integrates Excel with multiple SAP modules using Open Database Connectivity (ODBC) standards. Develops and optimizes SQL queries to retrieve and manipulates data from relational databases. Administers SharePoint sites and maintains departmental websites for all PTUS locations. Supports and maintains Merlin-based MEMEX software for manufacturing execution. Uses Microsoft Visio to create detailed business process diagrams, flowcharts, and Entity Relationship Diagrams (ERDs).

Ensures the metadata of engineering drawings is maintained and accurately transformed across all integrated systems.