Manufacturing Data Analytics & IIoT Optimization

Socket.dev; North Carolina; On-site; USD 60,000 - 85,000; Full time

Job summary

The Operations Analyst at DNP Imagingcomm America Corporation will drive data collection, analysis, and reporting to support continuous improvement of KPIs across manufacturing and supply chain functions. You will harness tools like SQL, Excel, Access, and dashboards to turn data into actionable insights for cross-functional teams.

You will collaborate with IT and business stakeholders to optimize ERP and IIoT connectivity, develop automation with RPA, and train colleagues on new data tools and

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.

Responsibilities

• Establish/improve tools to collect, analyze, and interpret data to identify trends related to cost, variance, and efficiency in each production process.
• 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.

Skills

Advanced Microsoft Excel

Data analytics

VBA programming

Reporting and visualization

Cross-functional collaboration

Education

B.S. degree in technology/engineering/business analytics

Tools

SQL

MS Access

MS Excel (formulas, PivotTables, XLOOKUP, SUMIFS)

VBA

RPA

Smartsheet

OPCUA/IIoT connectivity

AWS/Azure/MT Connect

Epicor Kinetic ERP

Job description

The Operations Analyst at DNP Imagingcomm America Corporation will drive data collection, analysis, and reporting to support continuous improvement of KPIs across manufacturing and supply chain functions. You will harness tools like SQL, Excel, Access, and dashboards to turn data into actionable insights for cross-functional teams.

You will collaborate with IT and business stakeholders to optimize ERP and IIoT connectivity, develop automation with RPA, and train colleagues on new data tools and