Senior Business Intelligence Analyst

Responsibilities

• Work closely with business, to capture, analyze and understand business requirements, translating activities and business objectives into analytical reporting and analysis.
• Partner collaboratively with other functional teams to access data elements, understanding the data being analyzed and identifying improvement opportunities.
• Develop well-organized and insightful reports, dashboards, and other forms of data visualizations to support business awareness and decision-making.
• Proactively interface with Highgate operating disciplines to gather and validate reporting and analysis requirements including data elements and report owners.
• Automate business processing using process automation.
• Complete ad hoc analyses as requested by senior management with the expectation of presenting deliverables to a large and varied audience.
• Support the redesign of monthly, quarterly, and annual business reporting for presentation to hotel ownership groups, including public lodging REITs and private real estate investment firms and financing groups.
• Creatively determine areas of opportunity to develop materials that communicate key successes and / or management company performance trends to support business development and investor relations for the organization.

Qualifications

• Minimum of three (3) years of prior, relevant professional experience, preferably for a hotel management or ownership company focusing on: BI, Analytics, Process Automation, Reporting Platform and Deployment Strategy.
• Minimum of two (2) years of hands-on experience in architecting, designing, and implementing advanced analytics model.
• Prior experience with IBM Planning Analytic TM1 is required for this role.
• Prior experience in the hotel, hospitality or travel industry is favorable.
• Demonstrated, exceptional analytical and technical capabilities, including but not limited to: Large data collection, organization, synthesis, and distribution working with advanced data analytics tools such as IBM Planning Analytic TM1, Oracle EPM, Anaplan. Visualization tools Power BI (preferred) or Tableau. Experience using Microsoft SQL Server for performing data profiling, formatting, and ad hoc analysis.
• Understanding of data warehousing concepts, relational data models and the data flow process end-to-end from ingestion to consumption.
• Comprehension of Microsoft Excel VBA.
• General knowledge and understanding of financial statements and commonly used hospitality- related performance metrics.
• Ability to review and understand commonly used industry operating reports (i.e., STR reports, group booking pace, revenue segmentation, etc.).
• Strong verbal and written business communication skills.
• An affinity for creating and producing work product in a detail-oriented and self-sufficient manner, including meticulous and methodical self-checking habits.
• Adept organizational and project management skills, including time management and priority setting.
• Ability to work within a dynamic, nimble, and entrepreneurial environment and collaborate across multiple internal disciplines to achieve goals and produce deliverables in a timely and accurate fashion.