Manager BI and Financial Planning Applications
About The Position
The Manager of Business Intelligence and Financial Planning Applications reports to the Vice President of Business Intelligence and helps scale and govern the organization’s Microsoft data ecosystem, including SQL Server, Azure Managed Instance, Power BI, and Excel. The role architects, enhances, and maintains enterprise-wide Power BI semantic models that support financial and operational analytics across the hotel portfolio. This hands-on role combines financial knowledge with technical expertise in Power BI, Tabular Editor, SQL Server, and Excel. The manager partners with stakeholders across Finance, Sales, Operations, Revenue Management, and IT to translate business needs into scalable models, KPIs, dashboards, and self-service analytics. The role also supports data validation, standardized data architecture, governance, performance, and user experience.
Requirements
- Bachelor’s degree in Finance, Accounting, Data Analytics, Computer Science, or a related field.
- At least 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.
- Knowledge of Power BI’s PBIP file structure and CI/CD and deployment pipelines through GitHub and Microsoft Fabric.
- Exposure to agentic coding workflows focused on Power BI and SQL, including creating skills to streamline processes.
- Foundational knowledge of relational database architecture, tabular modeling, and star schema design.
- Strong experience with Tabular Editor for scripting, deployment, and calculation group management.
- Advanced knowledge of SQL Server and Azure SQL, including T-SQL, stored procedures, and creating and modifying views.
- Advanced Excel skills, including dynamic arrays, VBA automation, Power Query, and Power BI data connections.
- Strong understanding of financial reporting principles and hotel performance metrics such as RevPAR, ADR, Occupancy, and GOP.
- Excellent analytical, communication, and problem-solving skills, with the ability to work independently and manage multiple priorities.
Nice To Haves
- Experience with Visual Studio and Claude Code; exposure to other LLMs is acceptable.
Responsibilities
- Architect and maintain scalable, governed Power BI semantic models aligned with enterprise data standards.
- Use AI coding agents, such as Claude Code, to optimize, scale, and maintain Power BI semantic models, visual reporting, and the user interface.
- Partner with Finance, Operations, and IT to translate business requirements into data models, KPIs, and dashboards.
- Develop 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 in SQL Server and Azure environments.
- Collaborate with Data Engineering to build, test, and deploy structured datasets optimized for 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 analytics tools using dynamic arrays, VBA, and Power BI connections such as PivotTable connections and CUBEVALUE/CUBEMEMBER functions.
- Validate report outputs, troubleshoot data integrity issues, and ensure consistency across reporting layers.
- Contribute to continuous improvement in data accessibility, performance, and user experience.
Benefits
- Health and welfare plans, including medical, dental, and vision options.
- Competitive paid time off.
- 401(k) savings plan with company match.
- Volunteer opportunities.
- Educational assistance.
- Travel discounts.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Manager
