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. We have produced control packages for many of America's top corporations in the chemical, environmental, food, pulp and paper, rubber, petroleum, pharmaceutical, glass, metals, and utilities industries.

We also deliver equipment for use worldwide. Our rigorous methodology assures compliance with domestic and international standards. We can meet the needs of our diverse clientele from start to finish through sales, design, fabrication, testing, and delivery.

Since 1957, we have been known for our high-quality, custom-built control packages, our comprehensive service, and our technological and manufacturing expertise. This expertise assures you of our ability to handle the largest and most complex packages quickly and efficiently.

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 various departments including Demand Planning, Supply Planning, Sales, Finance, and Operations.

• Works 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.
• Works with Demand Planner to create KPI dashboards using Power BI, Tableau or web-based program to report on Forecast Performance metrics.
• Supports SIOP Director, Demand Planner, and Supply Planner to build scenario tools to review upside and risk to the monthly forecast for sales and operations.
• Builds 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
• Builds automation tools to simulate and create factory schedules
• Builds KPI dashboards for supply

• 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

Ability to physically push, pull, and lift 50lbs or more required

Ability to stoop and bend required

Ability to sit, stand, and walk for four-plus hours at a time required

Alignment with company core values 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 by Panelmatic for the employee-only level medical coverage
• 80% paid for by Panelmatic and 20% paid by the employee on all other level medical coverage (ie employee plus child, employee plus spouse, family)
• 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