Power BI Consultant (Analytics & Reporting)

Posted Yesterday
Be an Early Applicant
Detroit, MI, USA
In-Office
80-80 Hourly
Senior level
Artificial Intelligence • Cloud • Consulting • Cybersecurity
The Role
Design, build, and optimize enterprise Power BI reports, dashboards, semantic models, and DAX measures. Manage Power BI Service workspaces, security, deployment pipelines, refreshes, and gateways. Integrate data from ERP, manufacturing, supply chain, finance, warehouses, and lakes while improving performance through model optimization, aggregations, and incremental refresh. Partner with stakeholders and data engineers to establish governance, translate requirements, and enable adoption through documentation and training.
Summary Generated by Built In
Role Overview

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

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

Key Responsibilities
Power BI Solution Design & Development
  • Design and build Power BI reports, dashboards, and semantic models for enterprise audiences
  • Develop optimized DAX measures for complex KPIs, trends, and performance analysis
  • Implement star‑schema and dimensional models to support scalable analytics
  • Apply best practices for visual design, usability, and performance
Modern Microsoft Analytics Stack
  • Leverage Power BI Service capabilities including:
    • Apps, workspaces, deployment pipelines
    • Row‑level security (RLS) and object‑level security
    • Scheduled refresh and data gateways
  • Work with Microsoft Fabric‑aligned architectures, including:
    • Lakehouse / warehouse concepts
    • Direct Lake or DirectQuery strategies (where applicable)
  • Partner with data engineers on data pipelines, refresh strategies, and model optimization
Data Integration & Performance
  • Consume data from multiple enterprise sources, such as:
    • ERP and operational systems
    • Manufacturing, supply chain, and finance platforms
    • Cloud data warehouses and lakes
  • Optimize report and model performance by:
    • Reducing model size and cardinality
    • Optimizing DAX and relationships
    • Implementing aggregation and incremental refresh strategies
Stakeholder Enablement & Governance
  • Partner with business stakeholders to understand reporting and analytics needs
  • Translate requirements into clear, trusted dashboards and insights
  • Establish governance standards for datasets, metrics, and reporting consistency
  • Support user adoption through documentation, walkthroughs, and enablement sessions


Requirements

Qualifications
Required
  • 5–8+ years of hands‑on experience with Power BI
  • Strong expertise in:
    • DAX
    • Data modeling (star schema, fact/dimension design)
    • Power BI Service & workspace management
  • Experience working with large, complex datasets
  • Strong SQL skills for data analysis and validation
  • Proven ability to build executive‑ready dashboards and operational reports
  • Experience working in enterprise or global organizations
  • Excellent communication skills with technical and non‑technical stakeholders
Nice to Have (Highly Valued)
  • Experience with Microsoft Fabric concepts (Lakehouse, Warehouse, OneLake)
  • Power BI performance tuning and capacity optimization experience
  • Background in manufacturing, supply chain, or industrial data environments
  • Experience with Azure data services (Synapse, Data Factory, Databricks)
  • Familiarity with data governance and semantic model standardization
What Success Means in This Role
  • Business leaders rely on Power BI as a single source of truth
  • Dashboards are fast, accurate, and easy to interpret
  • Data models scale without constant rework
  • Reporting cycles are shortened and manual reporting is reduced
  • Insights drive measurable improvements in operational and financial performance


Benefits
Engagement Notes
  • Maximum rate: $80/hour (1099)
  • No visa sponsorship provided
  • Candidates must be authorized to work in the United States


Skills Required

  • 5–8+ years of hands-on Power BI experience
  • Strong expertise in DAX
  • Strong expertise in data modeling, including star schema and fact/dimension design
  • Strong expertise in Power BI Service and workspace management
  • Experience working with large, complex datasets
  • Strong SQL skills for data analysis and validation
  • Ability to build executive-ready dashboards and operational reports
  • Experience working in enterprise or global organizations
  • Excellent communication skills with technical and non-technical stakeholders
  • Experience with Microsoft Fabric concepts, including Lakehouse, Warehouse, and OneLake
  • Power BI performance tuning and capacity optimization experience
  • Background in manufacturing, supply chain, or industrial data environments
  • Experience with Azure data services, including Synapse, Data Factory, or Databricks
  • Familiarity with data governance and semantic model standardization
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
38 Employees
Year Founded: 2025

What We Do

Palo Alto Labs is a new-age management consulting firm that helps organizations address complex business challenges through strategy, transformation, and managed services. It combines AI, automation, cloud, data engineering, cybersecurity, and enterprise-platform expertise to break down organizational silos, improve operational performance, and deliver measurable business outcomes. The firm positions itself as a strategic execution partner for ambitious enterprises navigating growth and technological change.

Similar Jobs

Remote or Hybrid
US
15100 Employees
96K-150K Annually

CDW Logo CDW

Senior Security Engineer

Information Technology
Remote or Hybrid
US
15100 Employees
109K-151K Annually

Edmunds Logo Edmunds

Account Executive

AdTech • Automotive • Big Data • Consumer Web
Hybrid
Detroit, MI, USA
500 Employees
100K-175K Annually
Remote or Hybrid
US
15100 Employees
78K-108K Annually

Similar Companies Hiring

Legora Thumbnail
Artificial Intelligence • Legal Tech • Software
New York, New York
700 Employees
Hanover Park Thumbnail
Artificial Intelligence • Fintech • Software • Financial Services
New York, New York
42 Employees
Onshore Thumbnail
Artificial Intelligence • Fintech • Software • Financial Services
New York, New York
60 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account