Director/Lead - BI & Analytics

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