Crestline Hotels & Resorts · 2 months ago
BI & Financial Planning Manager
Fairfax, VA
Full-time
Onsite
Senior Level
5+ years expCrestline Hotels & Resorts is seeking a BI & Financial Planning Manager to enhance their Microsoft data ecosystem. This role involves architecting and maintaining Power BI models for financial and operational analytics, collaborating with various departments to translate needs into scalable models.
HospitalityHotel
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
Qualification
Required
Bachelor's Degree in Finance, Accounting, Data Analytics, Computer Science, or a related field required
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
Benefits
Health and Welfare plans to include Medical/Dental/Vision options
Competitive Paid Time Off
401k Savings Plan with Company Match
Volunteer Opportunities
Educational Assistance
Travel Discounts
Company
Crestline Hotels & Resorts
Crestline Hotels & Resorts is a hospitality management company.
5001-10000 employees
H1B Sponsorship
Crestline Hotels & Resorts has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2023 (1)
2020 (1)
Funding
Current Stage
Late StageLeadership Team
James Carroll
President & CEO
Mónica Bernstein
Executive Vice President & General Counsel
Recent News
Hotel Management Network
2026-01-22
2026-01-20
Company data provided by crunchbase