BI Data Analyst: Real-Time Power BI Dashboards

Panelmatic Inc; Georgia; On-site; USD 90,000 - 130,000; Full time

Benefits offered by this job

Medical coverage

Dental coverage

Vision coverage

HSA

Life Insurance

AD&D

STD/LTD

401(k) matching

Educational reimbursement

Paid time off

Paid holidays

Career advancement

Competitive wages

Family-friendly

Job summary

Panelmatic Inc. seeks a Business Intelligence Data Analyst to own enterprise reporting and KPI governance, delivering real-time visibility into revenue, backlog, margin, and labor utilization.

You will partner with Finance, Operations, Sales, and project teams to define metrics and standardize reporting. You will design dashboards in Power BI, build semantic models, and implement modern cloud data solutions with Microsoft Fabric.

Qualifications

• Bachelor’s degree in Business Analytics, Data Analytics, Information Systems, Computer Science, Finance, or 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.

Responsibilities

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

Skills

Power BI

SQL

DAX

Dimensional Modeling

Microsoft Fabric

Education

Bachelor's degree in related field

Tools

Power Query

Python

Job description

Panelmatic Inc. seeks a Business Intelligence Data Analyst to own enterprise reporting and KPI governance, delivering real-time visibility into revenue, backlog, margin, and labor utilization.

You will partner with Finance, Operations, Sales, and project teams to define metrics and standardize reporting. You will design dashboards in Power BI, build semantic models, and implement modern cloud data solutions with Microsoft Fabric.