Director/Lead - BI & Analytics

The Planet Group
Chicago, IL

Our client is seeking a Director / Lead Senior BI & Analytics Development professional (BI Developer / Analytics Lead / Data Visualization Lead) to support a rapidly scaling analytics organization undergoing significant transformation.


This role is ideal for a hands-on BI leader / Senior Power BI Developer / Analytics Manager who has evolved from technical development into leadership and can guide teams through best practices in data modeling, reporting architecture, and BI governance.


You will play a key role in standardizing development practices, improving delivery quality, and enabling scalable enterprise reporting solutions in a fast-paced environment.


This is a technical leadership role (not traditional people management) with strong influence over architecture, delivery standards, and cross-functional alignment.


Key Responsibilities

BI Development & Technical Leadership

  • Lead end-to-end BI and analytics development using Power BI (DAX, Power Query, data visualization)
  • Act as a Power BI Lead / BI Architect supporting scalable enterprise reporting solutions
  • Provide technical direction, code reviews, and mentoring for BI developers and analysts
  • Ensure adherence to SDLC (requirements, design, development, testing, deployment)
  • Support delivery across multiple concurrent BI initiatives and reporting streams
  • Identify risks, dependencies, and delivery blockers in fast-paced environments


Data Modeling & Analytics Architecture

  • Design and enforce dimensional data models (star schema, fact/dimension tables)
  • Build scalable semantic models / datasets for enterprise reporting
  • Ensure proper implementation of:
  • Table relationships
  • Primary and foreign keys
  • Data integrity and normalization principles
  • Optimize Power BI performance, scalability, and usability


BI Governance & Data Standardization

  • Establish BI governance frameworks, KPI standardization, and reporting consistency
  • Develop reusable datasets and centralized data models
  • Align business definitions with technical BI implementations
  • Promote data quality, consistency, and reporting accuracy across teams


Stakeholder & Cross-Functional Collaboration

  • Partner with business stakeholders to define reporting and analytics requirements
  • Collaborate with data engineering, cloud teams, and external vendors/consultants
  • Work across upstream data dependencies and enterprise data environments
  • Improve documentation, communication, and cross-team alignment


Team Enablement & BI Best Practices

  • Mentor and support BI developers, analysts, and technical contributors
  • Drive adoption of structured BI development practices
  • Eliminate silos and promote reusable analytics assets
  • Act as a bridge between technical teams and leadership stakeholders


Project Environment

  • Large-scale CRM transformation initiative (enterprise reporting impact)
  • High-volume Power BI dashboard and reporting development
  • Evolving and partially defined requirements
  • Fast-paced delivery timelines with near-term UAT cycles
  • Collaboration with internal teams and external consulting partners
  • Growing need for BI standardization and governance maturity


Technical Environment

  • Power BI (primary BI & visualization platform)
  • SQL-based data environments
  • CRM platform (enterprise-level)
  • Power Platform (Power Apps exposure preferred)
  • Databricks or similar cloud data platforms


Required Qualifications

  • 8+ years in BI development, analytics engineering, or data visualization roles
  • 5+ years hands-on experience with Power BI (DAX, Power Query, datasets, dashboards)
  • 3+ years in a technical lead, BI lead, or analytics leadership role
  • Strong SQL skills (querying, transformations, validation)
  • Deep understanding of SDLC and BI development lifecycle
  • Strong expertise in:
  • Dimensional modeling (star schema, fact/dimension design)
  • Semantic layer development
  • Data modeling best practices
  • Experience with BI governance, KPI frameworks, and reporting standardization
  • Strong communication and stakeholder management skills
  • Ability to operate in fast-paced, ambiguous enterprise environments


Preferred Qualifications

  • Experience with Microsoft Dynamics or Salesforce environments
  • Exposure to CRM migrations or transformation programs
  • Experience with Databricks / cloud data platforms (Azure preferred)
  • Background in data pipeline optimization, scalability, and performance tuning

// // //