Director, Business Intelligence & Reporting

Rectangle Health•White Plains, NY

3d•$180,000 - $230,000

About The Position

The Director, Business Intelligence & Reporting leads the strategy, architecture, development, governance, and continuous improvement of enterprise reporting and analytics. As the organization’s subject matter expert for Microsoft Power BI, the role connects complex data infrastructure with executive and operational decision-making. The Director works with Finance, Data Platform, Engineering, IT, Security, and business leaders to establish scalable reporting standards, consistent KPI definitions, trusted semantic models, and production-grade dashboards that deliver actionable insights. The role maintains critical reporting continuity while transitioning manual and legacy processes into a governed enterprise environment. It also supports the Enterprise Data Strategy by aligning dashboards, reporting logic, data-quality controls, and source-system reconciliation with the future-state data platform. The Director defines the enterprise Power BI roadmap; leads dashboard, management-reporting, and executive-reporting delivery; and architects advanced Power BI solutions using DAX and Power Query/M. The role partners on data integration and dimensional modeling, establishes validation and reconciliation controls, governs KPI definitions and reporting standards, and advises executives and department leaders. It also guides reporting transformation and enterprise data strategy alignment, provides technical direction and quality oversight to analysts, developers, consultants, and vendors, and evaluates emerging capabilities such as AI-assisted analytics and Microsoft Copilot for Power BI.

Requirements

Bachelor’s degree in Data Analytics, Computer Science, Information Systems, Business Intelligence, Finance, or a related field, or equivalent professional experience.
8+ years of progressive experience in Business Intelligence, analytics, enterprise reporting, or advanced data visualization, including ownership of enterprise-scale Power BI solutions.
Expert proficiency with Power BI Desktop and Power BI Service, including semantic models, DAX, Power Query/M, gateways, workspaces, security, deployment pipelines, and performance optimization.
Advanced SQL proficiency and strong knowledge of dimensional modeling, star-schema design, data warehousing principles, and ETL/ELT concepts.
Demonstrated experience reconciling reporting outputs to source-system data and establishing reporting validation and quality-control processes.
Experience defining enterprise KPIs, metric standards, reporting governance, documentation, and data-lineage expectations.
Ability to translate complex business requirements and ambiguous questions into clear technical specifications and decision-useful reporting solutions.
Strong executive communication, stakeholder management, analytical, problem-solving, and documentation skills.
Experience partnering across Finance, Data, Engineering, IT, Security, Sales, Operations, and Product functions.

Nice To Haves

Experience with Microsoft Fabric or a comparable modern enterprise data platform.
Experience modernizing or migrating legacy reporting environments and consolidating redundant dashboards and reports.
Experience supporting financial, customer, sales, operational, and executive or Board-level reporting.
Experience with enterprise data governance, master data management, data cataloging, or data-lineage initiatives.
Microsoft Certified: Power BI Data Analyst Associate (PL-300), Fabric Analytics Engineer Associate (DP-600), or comparable credentials.

Responsibilities

Define and execute the enterprise roadmap for Power BI reporting and analytics, and partner with engineering and business teams to transition legacy reporting into scalable semantic models, governed data hubs, and reusable assets.
Own the design, development, maintenance, and continuous improvement of enterprise dashboards and recurring management and executive reporting across Finance, Sales, Operations, Product, and other business functions.
Architect and deliver complex interactive Power BI reports and dashboards; develop optimized DAX calculations and Power Query/M transformations; and promote performance across large, multi-source datasets.
Partner with data engineers and cross-functional teams to integrate data from disparate enterprise systems, design dimensional and star-schema models, and clarify relationships between reporting outputs and source data.
Lead migration from manual, spreadsheet-based, and legacy processes to repeatable, scalable, consistent, documented reporting solutions while maintaining continuity of critical reporting.
Establish controls that validate reporting outputs against source systems, business definitions, formulas, and cutoff dates; identify exceptions and inconsistencies; and coordinate their resolution with data and business owners.
Partner with stakeholders to establish consistent KPI definitions, calculation methodologies, ownership, lineage, and conflict-resolution processes; document report logic, source systems, dependencies, and business use.
Partner with IT and Security on Power BI workspace governance, access protocols, security standards, deployment practices, and performance monitoring; standardize user experience, visual design, layouts, and calculation conventions.
Advise executives and department leaders, translating business questions into analytical requirements and decision-ready dashboards, reports, and insights.
Represent reporting and analytics in the Enterprise Data Strategy and partner with the Data Platform organization to determine which reporting assets to retain, redesign, consolidate, migrate, or retire.
Provide technical direction and quality oversight to analysts, developers, consultants, and vendors; establish development standards, review solutions, and promote knowledge transfer and documentation.
Evaluate emerging capabilities, including AI-assisted analytics, Microsoft Copilot for Power BI, and advanced predictive features, with Data, IT, Security, and business stakeholders.

Benefits

Competitive medical health plans with low, mid, and high options.
Employer-paid low medical plan for employee and dependents (HSA eligible).
Employer-paid dental and vision coverage for employee.
Employer-paid life insurance for employee.
Employer-paid long-term disability for employee.
Employer-paid hospital confinement coverage for employee if enrolled in medical.
Voluntary supplemental insurance coverage options.
20 days of PTO and 7 sick days annually.
10 fixed paid holidays off annually.
401(k) matching up to 3%.