Power BI Consultant (Analytics & Reporting)

Palo Alto Labs

Detroit, Michigan

JOB DETAILS
SKILLS
Best Practices, Communication Skills, Consulting, Data Analysis, Data Modeling, Data Quality, Data Sets, Decision Support, Dimensional Modeling, ERP (Enterprise Resource Planning), Finance, Manufacturing, Manufacturing Operations, Microsoft Product Family, Needs Assessment, Operational Improvement, Operational Measurement, Performance Analysis, Performance Metrics, Performance Modeling, Performance Tuning/Optimization, Power BI, Process Improvement, Reporting Dashboards, SQL (Structured Query Language), Star Schema, Supply Chain, Trend Analysis, Usability Engineering, Warehousing
LOCATION
Detroit, Michigan
POSTED
3 days ago

Role Overview
<\/h2>

We are seeking a Power BI Consultant<\/b> to design, build, and optimize enterprise‑grade analytics and reporting solutions<\/b> that support executive decision‑making, operational performance, and financial visibility across a complex, global organization.
<\/p>

This role focuses on delivering scalable, governed, and high‑performance Power BI solutions<\/b> using modern Microsoft analytics capabilities<\/b>, including Power BI Service, DAX, semantic models, and Microsoft Fabric‑aligned architectures<\/b>. The ideal candidate combines strong technical depth with a solid understanding of business KPIs, manufacturing or operations‑centric data, and stakeholder communication.
<\/p>

Key Responsibilities
<\/h2>

Power BI Solution Design & Development
<\/h3>
  • Design and build Power BI reports, dashboards, and semantic models<\/b> for enterprise audiences
    <\/li>
  • Develop optimized DAX measures<\/b> for complex KPIs, trends, and performance analysis
    <\/li>
  • Implement star‑schema and dimensional models<\/b> to support scalable analytics
    <\/li>
  • Apply best practices for visual design, usability, and performance<\/b>
    <\/li><\/ul>

    Modern Microsoft Analytics Stack
    <\/h3>
    • Leverage Power BI Service<\/b> capabilities including:
      • Apps, workspaces, deployment pipelines
        <\/li>
      • Row‑level security (RLS) and object‑level security
        <\/li>
      • Scheduled refresh and data gateways
        <\/li><\/ul><\/li>
      • Work with Microsoft Fabric‑aligned architectures<\/b>, including:
        • Lakehouse / warehouse concepts
          <\/li>
        • Direct Lake or DirectQuery strategies (where applicable)
          <\/li><\/ul><\/li>
        • Partner with data engineers on data pipelines, refresh strategies, and model optimization
          <\/li><\/ul>

          Data Integration & Performance
          <\/h3>
          • Consume data from multiple enterprise sources, such as:
            • ERP and operational systems
              <\/li>
            • Manufacturing, supply chain, and finance platforms
              <\/li>
            • Cloud data warehouses and lakes
              <\/li><\/ul><\/li>
            • Optimize report and model performance by:
              • Reducing model size and cardinality
                <\/li>
              • Optimizing DAX and relationships
                <\/li>
              • Implementing aggregation and incremental refresh strategies
                <\/li><\/ul><\/li><\/ul>

                Stakeholder Enablement & Governance
                <\/h3>
                • Partner with business stakeholders to understand reporting and analytics needs
                  <\/li>
                • Translate requirements into clear, trusted dashboards and insights
                  <\/li>
                • Establish governance standards for datasets, metrics, and reporting consistency
                  <\/li>
                • Support user adoption through documentation, walkthroughs, and enablement sessions
                  <\/li><\/ul><\/div>

                  <\/div><\/span>

                  Requirements<\/h3>

                  <\/div>

                  Qualifications
                  <\/h2>

                  Required
                  <\/h3>
                  • 5–8+ years<\/b> of hands‑on experience with Power BI<\/b>
                    <\/li>
                  • Strong expertise in:
                    • DAX
                      <\/li>
                    • Data modeling (star schema, fact/dimension design)
                      <\/li>
                    • Power BI Service & workspace management
                      <\/li><\/ul><\/li>
                    • Experience working with large, complex datasets
                      <\/li>
                    • Strong SQL skills for data analysis and validation
                      <\/li>
                    • Proven ability to build executive‑ready dashboards and operational reports
                      <\/li>
                    • Experience working in enterprise or global organizations
                      <\/li>
                    • Excellent communication skills with technical and non‑technical stakeholders
                      <\/li><\/ul>

                      Nice to Have (Highly Valued)
                      <\/h3>
                      • Experience with Microsoft Fabric<\/b> concepts (Lakehouse, Warehouse, OneLake)
                        <\/li>
                      • Power BI performance tuning and capacity optimization experience
                        <\/li>
                      • Background in manufacturing, supply chain, or industrial data environments
                        <\/li>
                      • Experience with Azure data services (Synapse, Data Factory, Databricks)
                        <\/li>
                      • Familiarity with data governance and semantic model standardization
                        <\/li><\/ul>

                        What Success Means in This Role
                        <\/h2>
                        • Business leaders rely on Power BI as a single source of truth<\/b>
                          <\/li>
                        • Dashboards are fast, accurate, and easy to interpret
                          <\/li>
                        • Data models scale without constant rework
                          <\/li>
                        • Reporting cycles are shortened and manual reporting is reduced
                          <\/li>
                        • Insights drive measurable improvements in operational and financial performance
                          <\/li><\/ul><\/div>

                          <\/div><\/span>

                          Benefits<\/h3>

                          Engagement Notes
                          <\/h3>
                          • Maximum rate:<\/b> $80/hour (1099)
                            <\/li>
                          • No visa sponsorship provided<\/b>
                            <\/li>
                          • Candidates must be authorized to work in the United States
                            <\/li><\/ul><\/div>

                            <\/div><\/span>

About the Company

P

Palo Alto Labs