Panelmatic · 1 day ago
Data and Reporting Analyst
Houston, TX
Full-time
Onsite
Mid Level
3+ years expPanelmatic, Inc. is a company that designs and builds custom electrical control panels for various manufacturing industries. The Data and Reporting Analyst is responsible for building and maintaining tools and dashboards to support the SIOP process for Demand Planning and Supply Planning while coordinating with various departments.
Electrical DistributionElectronicsManufacturing
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
Qualification
Required
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
3+ years of data analysis and tool automation
Experience in building PowerBI dashboards
Ability to communicate effectively
Advanced Microsoft Excel skills
Preferred
Knowledge of demand planning, supply planning, production planning, and scheduling
Working knowledge of Python or equivalent
Experience with Syteline ERP
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
Company
Panelmatic
Panelmatic serve manufacturing industries with the design & manufacture of custom electrical, instrument & pneumatic control panels.
201-500 employees
H1B Sponsorship
Panelmatic has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (5)
2024 (2)
Funding
Current Stage
Growth StageLeadership Team
Lyle Larkworthy
Chief Executive Officer
Sean Fightmaster, CPA
Chief Financial Officer
Company data provided by crunchbase