What are the responsibilities and job description for the Data Integration Specialist position at The C.W. Zumbiel Company?
Data Integration Specialist
Reports to: Director of Information & Technology
Position Status: Salary
Company Overview:
Zumbiel Packaging is a fourth-generation family-owned business that has been in the printing business for over 170 years. We are a printing company offering a wide range of products from beverage to consumer, and one of the leading in the industry. This is a company that offers the opportunity for a career and a unique culture with our family-owned atmosphere.
Why work for us?
- Medical, Dental, Vision, and 401k with company match
- Culture and engagement committee
- Unique family-owned culture
- Wellness program
- Room for growth and development
Position Description:
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. 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.
Key Responsibilities:
- 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.
- 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.
- Data Quality & Validation: Ensure the integrity and accuracy of the data being collected from manufacturing equipment and processes, implementing validation and error-checking protocols.
- 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.
Qualifications
- Bachelor’s degree in Computer Science, Engineering, or a related field (or equivalent experience).
- Prior experience in data center operations and manufacturing experience preferred.
- Proficient in server, storage, and networking technologies.
- Strong troubleshooting and analytical skills.
Location:
- Hebron, KY.
Must be authorized to work in the United States
Zumbiel Packaging provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.
