NEWLY CREATED ROLE - Manufacturing Data Integration Specialist
Mackie Search, LLC Cincinnati
We have partnered with an Industry Leading Manufacturer in the Cincinnati area to lead a search for an exciting NEWLY CREATED role in their IT Department.
Manufacturing Data Integration Specialist (Job description)
Job Overview:
We are seeking a highly skilled Manufacturing Data Integration Specialist with expertise in SQL, experience with API calls, and a strong understanding of manufacturing systems, particularly PLC integration(link removed) This individual will be responsible for bridging the gap between our manufacturing systems, databases, and business intelligence platforms, ensuring seamless data flow and integration across the enterprise.The ideal candidate will collaborate with the engineering, IT, and production teams to build robust data solutions that enable real-time monitoring and decision-making.
Must Haves
This is NOT a sit behind your desk role all day. Must be willing to be on the plant floor and communicate effectively with Plant Floor personnel. An outgoing personality will thrive in this role.
Experience in a manufacturing environment is a MUST HAVE!
Data Integration Background in Finance or Banking background is NOT a fit!- SQL Development & Database Management: Write complex SQL queries to retrieve and manipulate manufacturing data from various databases (e.g., SQL Server, MySQL) to support production reporting, analytics, and business intelligence.
- API Integration & Development: Develop and maintain APIs for seamless integration between manufacturing systems (e.g., PLCs, SCADA) and enterprise data platforms, ensuring real-time data flow for monitoring and reporting.
- PLC Integration: Work with the production team to integrate PLC systems (e.g., Siemens, Allen-Bradley) with centralized data storage or cloud platforms for real-time data monitoring and system control.
- Data Quality & Validation: Ensure the integrity and accuracy of the data being collected from manufacturing equipment and processes, implementing validation and error-checking protocols.
Key Responsibilities:
- Manufacturing Data Systems: Assist in the design and implementation of data solutions to support production systems, including real-time data acquisition, visualization, and reporting dashboards.
- Troubleshooting & Support: Diagnose and resolve issues related to data connectivity, API failures, and PLC integration in production environments.
- Collaboration: Work closely with IT, engineering, and production teams to gather requirements, implement system improvements, and ensure that manufacturing data is available for analytics and operational decision-making.
- Documentation & Reporting: Document system architectures, API workflows, database schemas, and integration processes. Provide clear reporting and updates on the status of data integration projects.
Skills & Qualifications:
- Technical Skills:
- Strong proficiency in SQL, including writing complex queries, stored procedures, and optimizing database performance.
- Experience with API development (REST, SOAP, or similar technologies) and integration with third-party systems (e.g., ERP, MES, SCADA).
- Experience with PLC systems (e.g., Siemens, Allen-Bradley, Mitsubishi), including data extraction and integration into enterprise-level data systems.
- Familiarity with industrial protocols (e.g., Modbus, OPC) for PLC and sensor communication.
- Understanding of manufacturing systems (e.g., MES, SCADA) and their role in production operations.
- Experience with cloud platforms (AWS, Azure) and their data integration services is a plus.
Cincinnati
Overview:
Day or night. You’re there when you’re needed most.
You know that people feel better when they’re at home, and you’re passionate about bringing nursing care to your patient’s front door. You pride yourself on your ability to think on your...
Cincinnati
Overview:
Under the direction of the Sous Chef, the incumbent maintains standards established in the preparation and presentation of food including tasting, presentation, and sanitation.
Responsibilities:
Responsibilities:
• Assists the Sous Chef...
Cincinnati
Overview:
The Cincinnati, OH of Lewis Brisbois is seeking a legal secretary with litigation experience. The primary responsibilities of this position include working for a minimum of (4) attorneys. Essential functions of this role include docketing...