Data and Reporting Analyst

About Us

Panelmatic, Inc. was founded in 1957 in Youngstown, OH to serve manufacturing industries with the design and building of custom electrical, instrument, and pneumatic control panels. Our business has grown to support expansion for our clients and we deliver equipment worldwide. Our methodology assures compliance with domestic and international standards, and we meet the needs of our diverse clientele from start to finish through sales, design, fabrication, testing, and delivery.

The Data and Reporting Analyst is responsible for building and maintaining tools and dashboards to support the Panelmatic SIOP process for Demand Planning, Supply Planning, Master Production Scheduling, and Scenario Building. This role coordinates with Demand Planning, Supply Planning, Sales, Finance, and Operations.

• Work with Demand Planner to build a monthly demand plan tool using data extracts from Salesforce Opportunities and open backlog from Syteline, as well as Budget and Strategic Plan.
• Work with Demand Planner to create KPI dashboards using Power BI, Tableau or web-based programs to report on Forecast Performance metrics.
• Support SIOP Director, Demand Planner, and Supply Planner to build scenario tools to review upside and risk to the monthly forecast for sales and operations.
• Build automation tools to translate the demand plan to the supply plan using factory allocations and existing schedule data to create a monthly operations plan for determining labor requirements and capital investment.
• Build automation tools to simulate and create factory schedules.
• Build KPI dashboards for supply performance.

• Bachelor’s degree in computer science or equivalent
• 3+ years in data analysis
• Power BI, SQL
• Advanced Excel Skills
• Strong analytical and problem-solving skills
• Excellent communication and organizational abilities
• Ability to work in a fast-paced, dynamic environment and manage multiple priorities
• Ability to extract data from ERP/MRP/CRM systems to build tools
• Ability to pass physical, drug, driving, and background check required

• Knowledge of demand planning, supply planning, production planning, and scheduling
• Working knowledge of Python or equivalent
• Experience with Syteline ERP

3+ years of data analysis and tool automation

Experience in building Power

BI dashboards

Ability to extract data from ERP/MRP/CRM

Ability to communicate effectively

Advanced Microsoft Excel skills

• Medical, dental, vision, HSA, term life, AD&D, STD, LTD
• 100% medical premium paid for employee-only level medical coverage by Panelmatic
• 80% paid by Panelmatic and 20% paid by the employee on all other level medical coverage
• 401K, profit sharing, and ESOP contributions
• Scholarships, educational reimbursement, paid volunteerism, and paid personal and professional development provided
• PTO and paid holidays provided
• Career advancement opportunities
• Competitive wages
• Family-friendly environment with average employee tenure above five years