Data Analyst

Panelmatic Inc.; Georgia; On-site; USD 80,000 - 100,000; Full time

Benefits offered by this job

Medical, dental, vision coverage

401(k) contributions matched 100% up to 4%

Paid volunteerism and development programs

Job summary

Panelmatic Inc. is searching for a Business Intelligence Data Analyst in Georgia. This role is essential for delivering enterprise reporting and insights into performance metrics, directly enhancing the business's operational effectiveness.

The ideal candidate will work with various teams to develop interactive dashboards and reports using Microsoft Power BI, optimize data workflows using SQL, and contribute to data governance initiatives.

Benefits include comprehensive health coverage, competitive wages, and opportunities for career advancement in a family-friendly environment.

Qualifications

• 3+ years of experience in business intelligence or data analysis.
• Advanced proficiency in Microsoft Power BI for dashboard development.
• Strong SQL skills for data extraction and transformation.

Responsibilities

• Design and develop interactive dashboards in Microsoft Power BI.
• Optimize data models using star schema and dimensional modeling techniques.
• Collaborate with business stakeholders to define KPIs and metrics.

Skills

Microsoft Power BI

SQL

DAX

Data analysis

Analytical skills

Education

Bachelor’s degree in Business Analytics or related field

Tools

Microsoft Fabric

Power Query

Job description

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.

Minimum Qualifications

• Bachelor’s degree in Business Analytics, Data Analytics, Information Systems, Computer Science, Finance, or a related field; equivalent experience considered.
• 3+ years of experience in business intelligence, data analysis, enterprise reporting, or operational analytics.
• Advanced proficiency in Microsoft Power BI, including dashboard development, semantic models, and enterprise reporting solutions.
• Strong SQL skills and experience with Power Query for data extraction, transformation, and preparation.
• Experience developing DAX calculations, measures, and business logic to support KPI reporting and analytics.
• Understanding of scalable data modeling concepts, including star schema and dimensional modeling techniques.
• Utilize AI/ML techniques and generative AI tools to enhance analytics and automate processes.
• Experience integrating and validating data from ERP, MES, CRM, financial, operational, or manufacturing systems.
• Working knowledge of Microsoft Fabric, data pipelines, Lakehouse concepts, or other modern cloud data platforms.
• Strong analytical, problem-solving, communication, and stakeholder management skills.
• Ability to manage multiple priorities in a fast-paced environment while maintaining accuracy and attention to detail.

Preferred Qualifications

• Experience building executive dashboards and operational scorecards in a manufacturing, project-based, or industrial environment.
• Familiarity with manufacturing, supply chain, operations, finance, and sales analytics.
• Working knowledge of DAX, Power Query, Python, or other data transformation and analytics tools.
• Experience with Infor CloudSuite Industrial (CSI v10 multi-tenant cloud environment preferred).
• Familiarity with KPI governance, master data management, and data quality best practices.
• Experience with statistical analysis, forecasting, trend analysis, and predictive modeling.

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 by Panelmatic and 20% paid by the employee on all other level medical coverage (i.e. employee plus child, employee plus spouse, family)
• 401(k) contributions matched 100% up to 4%
• 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