Data and Reporting Analyst

Panelmatic Inc. • Houston, TX

4h

About The Position

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.

Requirements

• 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

Nice To Haves

• 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 PowerBI dashboards
• Ability to extract data from ERP/MRP/CRM
• Ability to communicate effectively
• Advanced Microsoft Excel skills

Responsibilities

• 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

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

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Number of Employees: 101-250 employees