SIOP Data Analyst: Forecasts & Inventory Insights

MacDermid Alpha Electronics Solutions; Piscataway Township (NJ); On-site; USD 71,822 - 107,732; Full time

Benefits offered by this job

Health, dental, and vision insurance

Wellness Program

PTO/Holidays

401(k) retirement plan with company 1:

Job summary

MacDermid Alpha Electronics Solutions, part of Element Solutions Inc., seeks a SIOP Data Analyst to support Sales, Inventory and Operations Planning through data analysis, reporting and master data management. The role focuses on data readiness, accuracy and cross-functional collaboration across Supply Chain, Operations, Sales and Finance.

The ideal candidate is detail-oriented, analytical and proficient in Excel, with experience in planning systems and data visualization tools to drive informed

Qualifications

• Bachelor's degree required in a related field.
• 0–3 years of analytics, planning, supply chain, or related functions.
• Advanced Microsoft Excel skills (Pivot Tables, Power Query, lookups, data visualization).
• Strong analytical, problem-solving and organizational skills.
• Ability to work with large datasets and ensure data accuracy.
• Experience with planning systems (JDE, SAP, SAP IBP) preferred; SQL knowledge preferred.
• Experience with Power BI, Tableau or similar tools preferred.

Responsibilities

• Collect, validate, and maintain data from ERP, planning, and business systems.
• Develop and maintain SIOP reports, dashboards, and KPIs.
• Track and report KPIs: Forecast Accuracy, Bias, DII, OTD, Schedule Compliance, Master Data completeness.
• Analyze trends and provide insights for planning decisions.
• Maintain master data in ERP and planning systems; support data governance.
• Identify and resolve data quality issues impacting planning processes.
• Assist with data cleansing, standardization and system validation for enhancements.

Skills

Advanced Excel

Analytical thinking

Communication

Collaboration

SQL basics

Data visualization

Problem solving

Education

Bachelor's degree in supply chain / business analytics

Tools

Power BI

Tableau

JDE

SAP

SAP IBP

SQL

Job description

MacDermid Alpha Electronics Solutions, part of Element Solutions Inc., seeks a SIOP Data Analyst to support Sales, Inventory and Operations Planning through data analysis, reporting and master data management. The role focuses on data readiness, accuracy and cross-functional collaboration across Supply Chain, Operations, Sales and Finance.

The ideal candidate is detail-oriented, analytical and proficient in Excel, with experience in planning systems and data visualization tools to drive informed