BI & Financial Planning Manager

Crestline Hotels & Resorts•Fairfax, VA

58d

About The Position

The Manager of Business Intelligence and Financial Planning Applications reports to the Vice President of Business Intelligence and plays a key role in scaling and governing the organization's Microsoft data ecosystem, which includes SQL Server, Azure Managed Instance, Power BI, and Excel. This position is responsible for architecting, enhancing, and maintaining enterprise-wide Power BI semantic models that serve as the foundation for financial and operational analytics across the hotel portfolio. The ideal candidate combines strong financial acumen with advanced technical proficiency in Power BI, Tabular Editor, SQL Server, and Excel. This is a highly hands-on role that partners closely with stakeholders across Finance, Sales, Operations, and Revenue Management to design and refine analytical solutions. The candidate will work directly with business users to translate operational and financial needs into scalable models, perform rigorous data validation, and enable self-service analytics through robust, standardized data architecture.

Requirements

5+ years of experience in Business Intelligence, Financial Analysis, or Data Analytics.
Expert-level proficiency in Power BI, including DAX, data modeling, and performance tuning.
Foundational knowledge of standard relational database architecture, tabular modeling, and star schema design
Strong experience with Tabular Editor for scripting, deployment, and calculation group management.
Working knowledge of SQL Server and Azure SQL, including stored procedures, scalar/table-valued functions, and query optimization.
Advanced Excel skills, including dynamic arrays, VBA automation, Power Query, and Power BI data connections.
Strong understanding of financial reporting principles and key hotel performance metrics (RevPAR, ADR, Occupancy, GOP, etc.).
Excellent analytical, communication, and problem-solving skills, with the ability to work independently and manage multiple priorities.

Responsibilities

Architect and maintain scalable, governed Power BI semantic models aligned with enterprise data standards.
Partner with Finance, Operations, and IT to translate business requirements into data models, KPIs, and dashboards that support strategic and operational objectives.
Develop advanced DAX measures and calculation groups using Tabular Editor to standardize and optimize reporting logic across workspaces.
Write and validate SQL queries, stored procedures, functions, and other programmable objects within SQL Server and Azure environments to support model development and data validation.
Collaborate with the Data Engineering to build, test, and deploy structured datasets that are optimized to work within a Tabular Star Schema architecture
Implement and enforce Power BI governance standards, including workspace structure, naming conventions, data lineage documentation, and deployment pipelines.
Build and maintain Excel-based analytics tools leveraging: Dynamic Arrays for flexible modeling and scenario analysis Visual Basic for Applications (VBA) for automation and process control Power BI connections (PivotTable connections, CUBEVALUE/CUBEMEMBER functions) to surface semantic model data directly in Excel
Validate report outputs, troubleshoot data integrity issues, and ensure consistency across reporting layers.
Contribute to continuous improvement initiatives for data accessibility, performance, and user experience.