Hotel Reporting & Analysis: Produce and distribute weekly hotel performance reports, including data validation, trend analysis and concise written insights for internal stakeholders.
Develop and maintain monthly hotel reporting, synthesizing performance trends, seasonality and market dynamics.
Data includes both current hotel performance, as well as forward-looking trends.
Build and maintain reporting tables using advanced Excel functionality, including pivot tables, lookups, calculated fields and structured templates.
Contribute to Tableau dashboards used for hotel and market performance reporting, ensuring data accuracy and clear visual storytelling.
Visitor Trends & Market Analysis: Analyze visitor trends under the direction of the Research Manager to support organizational insights and strategic planning.
Assist with visitor segmentation analysis, including demographic, behavioral, geographic and trip-purpose segments.
Support cohort studies to understand changes in visitor behavior over time (e.g., repeat visitation, seasonality, booking patterns).
Analyze and synthesize government and public-sector visitation data (e.g., census, transportation, border, or tourism datasets) to inform market profiles.
Help build visitor profiles, summary presentations and fact sheets for internal teams, members and external stakeholders.
Translate complex datasets into clear, well-structured tables, charts, and narratives appropriate for non-technical audiences.
Ad Hoc Analysis: Provide ad hoc analytical support to the research, sales, membership and marketing teams under the direction of the VP of Research, including market performance summaries and custom data requests.
Translate quantitative analysis into clear, actionable insights aligned with marketing and organizational priorities.
Support the creation of summary tables, charts and visuals in Excel and Tableau for presentations and internal readouts.
Research Operations & Communications: Monitor and answer the research email inbox daily and ensure responses are sent within 24 hours, escalating complex inquiries to the Research Manager and Research VP when appropriate.
Monitor and maintain the membership research portal, ensuring content is accurate, up to date and easy to navigate.
Apply consistent tagging and metadata standards to all research collateral (reports, presentations, datasets) to support discoverability and knowledge management.

Requirements

Required Bachelor’s degree in economics, statistics, finance, marketing, data analytics, hospitality, urban planning or a related field.
Strong proficiency in Excel, including pivot tables, formulas, lookups and data cleaning/manipulation.
Working knowledge of Tableau, including building or updating dashboards and basic data visualizations.
Strong analytical skills with the ability to identify trends and summarize insights clearly.
Excellent written communication skills and high attention to detail.
Ability to manage multiple deadlines across weekly, monthly and annual reporting cycles.
Appropriate sense of urgency in completing work is required.
Preferred Familiarity with hotel performance metrics such as occupancy, ADR and RevPAR.
Experience working with recurring reporting cadences or standardized dashboards.
Prior internship, coursework, or professional experience involving applied data analysis or business intelligence tools.
Interest in tourism, destination marketing, consumer insight, New York City government or hospitality analytics.

Benefits

Hybrid Schedule: 3 days in-office (Tues/Wed required + 1 flex day); Fridays remote.
Generous Time Off: PTO days and sick time.
Holidays: up to 12 paid company holidays, plus extended Winter Break.
Floating Holiday: 1 per year, front-loaded.
Healthcare: Premium medical, dental, and vision plans, plus HRA and DCA.
Retirement & Development: Retirement savings plan and professional development opportunities.
Perks: Quarterly cell phone credit to subsidize your plan and monthly transit/commuter allowance.

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

data validationtrend analysisExcelpivot tableslookupsTableaudata cleaningdata manipulationquantitative analysisvisitor segmentation

Soft Skills

analytical skillswritten communicationattention to detailtime managementorganizational skillsability to manage deadlinessense of urgencyclear storytellingcollaborationproblem-solving