Data Analyst

Duetto; Worcester; On-site; GBP 30,000 - 40,000; Full time

Job summary

A leading hospitality analytics company in Worcester is seeking a Database Administrator to maintain the quality of the HotStats database and manage data sources. The candidate will perform data integrity checks, assist in producing reports, and contribute to data analysis projects. Strong administration skills and technical knowledge of Excel are essential. This is an excellent opportunity for those looking to progress in a dynamic, customer-facing environment.

Qualifications

• Able to read and understand hotel profit and loss statements.
• Eager to develop skills in data management and analysis.
• Experience or knowledge of accounting relevant to the hospitality sector.

Responsibilities

• Maintain the quality of the HotStats database and manage assigned data sources.
• Perform integrity checks on monthly performance data.
• Assist in producing monthly reports and data analysis.

Skills

Strong administration skills

Technical IT capabilities

Understanding of hotel profit and loss statements

Technical knowledge of Excel

Excellent written and verbal communication skills

Job description

HotStats provides a unique profit and loss benchmarking service to hoteliers worldwide, enabling monthly comparisons of hotel performance against competitors. It offers over 500 performance metrics across 70 areas of hotel revenue, cost, profit, and statistics, providing deeper insights than any other tool. The HotStats database currently includes data from over a million hotel rooms globally, and the platform continues to grow.

Additionally, HotStats offers market intelligence reports to assist developers and investors in decision-making. The company has developed distinctive management information tools for the hospitality sector.

The Role:

Working within the HotStats operations department, you will be part of a multi-disciplinary team. Your role will be pivotal in supporting the rapid development of HotStats and its related services for the hotel industry.

Skills / Competencies:

This position requires strong administration skills combined with technical IT capabilities. The successful candidate will need to:

• Have a working knowledge of accounting or relevant industry operational experience.
• Be able to read, understand, and interrogate hotel profit and loss statements.
• Possess sound technical knowledge of Excel and an understanding of database operations. Training will be provided.
• Be eager to develop skills in these areas with appropriate training.
• Exhibit excellent written and verbal communication skills.

Motivation:

We seek a candidate who:

• Wants to progress in a challenging, customer-facing environment.
• Is willing to work hard.
• Prefers to be highly visible in a small team rather than lost in a large corporate structure.
• Aims to contribute significantly to a critical company function and be recognized for it.

Job Functions and Tasks:

The HotStats Database

Your main responsibility will be maintaining the quality of the HotStats database and managing your assigned data sources. This includes building relationships with data contacts and responding to customer inquiries.

Data Maintenance:

Monthly:

• Perform integrity checks on monthly performance data using standard routines and spot checks.
• Process P&L data using translation tools and input into the database.
• Update hotel status, alerts, and notes in the database.

Ongoing:

• Conduct regular data quality audits and spot checks.
• Ensure compliance with the Uniform System of Accounts.
• Liaise with customers to resolve data quality issues.

Reporting Functions:

Monthly:

• Assist in producing monthly reports.
• Run PR data, market data, and bespoke reports.
• Check report quality.

As needed:

• Prepare hotel market performance reports for external clients.

Data Analysis:

• Support data analysis for specific projects or presentations.
• Conduct original research for PR or publications.

Company Profile:

HotStats offers a unique profit and loss benchmarking service to hoteliers worldwide, with over 500 performance metrics across 70 hotel revenue and cost areas. The database includes data from over a million hotel rooms globally and is expanding. The company also provides market intelligence reports to aid industry decision-making and has developed distinctive management tools for the hospitality sector.