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 sufficiently grown over the years 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.

Job Summary:

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.

Job Duties:

• 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

Minimum Qualifications:

• 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 extra 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

·Top of Form

Preferred Qualifications:

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

Requirements

3+ years of data analysis and tool automation

Experience in building PowerBI dashboards

Ability to extract data from ERP/MRP/CRM

Ability to communicate effectively

Advanced Microsoft Excel skills

Benefits

• Medical, dental, vision, HSA, term life, AD&D, STD, LTD
• 100% medical premium paid for by Panelmatic for the employee-only level medical coverage
1. 80% paid for by Panelmatic and 20% paid for 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