Access Control, Biotech and Pharmaceutical, Business Intelligence, Cloud Computing, Customer Relationship Management (CRM), Data Analysis, Data Management, Data Modeling, Data Quality, Dimensional Modeling, Documentation Models, ERP (Enterprise Resource Planning), Electricity, Financial Operations, Food and Beverage Industry, Identify Issues, Maintain Compliance, Manufacturing, Manufacturing Operations, Manufacturing Systems, Metrics, Microsoft Product Family, Network Operations Center, Oil and Gas, Operational Improvement, Performance Analysis, Performance Metrics, Performance Tuning/Optimization, Power BI, Process Improvement, Project Execution, Quality Control, Quality Metrics, Query Optimization, Reporting Dashboards, Reporting Skills, SQL (Structured Query Language), Sales, Scorecarding, Standards Development, Star Schema, Strategic Analysis, Testing, Training Data Sets
About Us:
Panelmatic, Inc. was founded in 1957 in Youngstown, OH to serve manufacturing industries with the design and build 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 data center, chemical, food & beverage, pulp & paper, material handling, oil & gas, pharmaceutical, renewables, metals, and utility markets. We also deliver equipment for use worldwide. Our rigorous methodology ensures 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, 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 Business Intelligence Data Analyst owns enterprise reporting, KPI governance, and operational performance visibility, enabling real-time insight into revenue, backlog, margin, labor utilization, and project execution metrics.
This role partners closely with Finance, Operations, Sales, and project teams to define metrics, standardize reporting, build dashboards, and surface actionable insights that improve execution and business performance.
Job Duties:
- Design and develop interactive dashboards, scorecards, and enterprise reports in Microsoft Power BI to provide visibility into revenue, backlog, margin, labor utilization, and project execution metrics.
- Build and optimize semantic models, datasets, and scalable data models using star schema and dimensional modeling techniques.
- Develop advanced calculations, measures, and business logic using DAX to support standardized KPI reporting and decision-making.
- Implement and support Microsoft Fabric solutions, including Lakehouse architectures, data pipelines, and cloud-based enterprise reporting capabilities.
- Create and maintain data transformation workflows using Power Query, SQL, and Fabric pipelines to integrate and prepare data from ERP, MES, CRM, financial, operational, and manufacturing systems.
- Collaborate with Finance, Operations, Sales, and other business stakeholders to define KPIs, metrics, reporting requirements, and governance standards.
- Establish and maintain reporting governance, data quality standards, documentation, security models, row-level security, and data access controls.
- Monitor report performance, optimize query efficiency, and troubleshoot reporting, refresh, and data integration issues.
- Support self-service BI initiatives through user enablement, training, and scalable reporting solutions that reduce manual effort and improve adoption.
- Assist with enterprise data strategy, analytics modernization, and broader cloud data initiatives to improve operational and financial insight across the business.