Job description

Job Purpose: The Operations Analyst will be integral to the collection, analysis, reporting, and use of data that drives continuous improvement on key performance indicators. The operations analyst will use their knowledge and skill in a variety of software applications to streamline processes and improve cross functional collaboration. Through the application of recent technology (including A.I.), support the transformation of people, process and procedural data and information into on-demand, interactive content. Responsibilities: • Establish/improve tools to collect, analyze, and interpret data to identify trends related to cost, variance, and efficiency in each production process. • Further develop and support existing SQL, MS Access, and MS Excel based applications integral to the operation’s daily functions. • Support the continued efforts on plant connectivity through IIoT and Cloud Data Services that gather machine and process level data for more informed decision making. • Collaborate with IT on the structure, security, integration, and support of ERP systems and integrations, internal and self-developed applications, Software, and Hardware solutions. • Partner with internal and external stakeholders to improve the Sales, Inventory, and Operations Planning (SIOP) process. • Create interactive dashboards and reports that simplify the presentation and visualization of data and critical process information. • Develop, Implement, and Train others on technology and tools focused on optimizing internal processes and work instructions to simplify operator level direction. • Manage operations level tools such as Smartsheet for Project Management and Robotic Process Automation (RPA) for desktop applications. Qualifications • B.S. degree in a technology/engineering/business analytics discipline. • In lieu of degree, at least 3 years direct experience in a data analytics role in manufacturing or supply chain organization. • Advanced Microsoft Excel user / developer, experienced in creating advanced Formulas, Pivot Tables, Charts, using XLOOKUP and SUMIFS, and linking data to Access database tables and queries. • Experience developing and debugging complex VBA code. • Demonstrated ability to develop, implement, and improve data collection, presentation, analysis, and reporting. Preferred Competencies/Capability • Advanced Microsoft Access user / developer experienced in creating databases, tables, advanced queries, linking tables, advanced forms, automatic updates/links, and VBA code. • Demonstrated experience using Robotic Process Automation (RPA) and/or machine learning/artificial intelligence tools. • IIoT, Machine Data Connectivity via OPCUA, Ethernet, etc. and Cloud Systems (AWS, Azure, MT Connect) • ERP use and knowledge, Epicor Kinetic preferred. Physical Demands • Must be able to sit/stand for 8 hours • The ability to use arms/hands/fingers to feel and reach • Must be able to hear and talk to communicate with team members • Must be able to push/pull/ lift at least 15 lbs. individually and 50 lbs. with the help of a team member Reasonable accommodations may be made to enable individuals with disabilities to perform essential functions. DNP IAM is a 100 percent U.S. subsidiary of Dai Nippon Printing Co., Ltd. (DNP) – the world’s largest manufacturer of dye-sublimation media for photo printers and thermal transfer ribbons and barcode printers. DNP Imagingcomm America Corporation has the broadest selection of solutions for the photo retail market and products designed to address retailer’s specific business goals and objectives—backed by the quality and reliability today’s customers expect. Manufacturing, sales, and development offices of dye-sublimation media for photo printers are in Concord, NC, and more information is available at www.dnpphoto.com/en-us/ . DNP Imagingcomm America Corporation is an equal opportunity employer that does not discriminate based on race, national origin, gender, gender identity, sexual orientation, protected veteran status, disability, age, or other legally protected status.

Requirements

Must-haves

Establish/improve tools to collect, analyze, and interpret data to identify trends related to cost, variance, and efficiency in each production process.
Further develop and support existing SQL, MS Access, and MS Excel based applications integral to the operation’s daily functions.
Support the continued efforts on plant connectivity through IIoT and Cloud Data Services that gather machine and process level data for more informed decision making.
Collaborate with IT on the structure, security, integration, and support of ERP systems and integrations, internal and self-developed applications, Software, and Hardware solutions.
Partner with internal and external stakeholders to improve the Sales, Inventory, and Operations Planning (SIOP) process.
Create interactive dashboards and reports that simplify the presentation and visualization of data and critical process information.
Develop, Implement, and Train others on technology and tools focused on optimizing internal processes and work instructions to simplify operator level direction.
Manage operations level tools such as Smartsheet for Project Management and Robotic Process Automation (RPA) for desktop applications.
B.S. degree in a technology/engineering/business analytics discipline.
In lieu of degree, at least 3 years direct experience in a data analytics role in manufacturing or supply chain organization.
Advanced Microsoft Excel user / developer, experienced in creating advanced Formulas, Pivot Tables, Charts, using XLOOKUP and SUMIFS, and linking data to Access database tables and queries.
Experience developing and debugging complex VBA code.
Demonstrated ability to develop, implement, and improve data collection, presentation, analysis, and reporting.
Advanced Microsoft Access user / developer experienced in creating databases, tables, advanced queries, linking tables, advanced forms, automatic updates/links, and VBA code.
Demonstrated experience using Robotic Process Automation (RPA) and/or machine learning/artificial intelligence tools.
IIoT, Machine Data Connectivity via OPCUA, Ethernet, etc. and Cloud Systems (AWS, Azure, MT Connect)
Physical Demands
Must be able to sit/stand for 8 hours
The ability to use arms/hands/fingers to feel and reach
Must be able to hear and talk to communicate with team members
Must be able to push/pull/ lift at least 15 lbs. individually and 50 lbs. with the help of a team member
Reasonable accommodations may be made to enable individuals with disabilities to perform essential functions.

Nice-to-haves

Preferred Competencies/Capability
ERP use and knowledge, Epicor Kinetic preferred.

Application prep

Use the role’s language and application details while tailoring your materials.

Keywords to mirror

sqlmachine learningawsazure

Platform: adp-workforce-now
Effort: medium