Data Analyst Intern & IT HR Project Coordinator
Global Consulting GC.
Mumbai, Maharashtra, IndiaFresher6d agovia LinkedIn
About the Role
Global Consulting (GC) is seeking a Data Analyst Intern to support the business operations, marketing, and growth of Weekend Villa, a luxury hospitality and holiday villa project. This is a practical internship designed for freshers and students to gain hands-on experience in data analytics and business intelligence.
Key Responsibilities
- Maintain and analyze booking enquiries, reservations, occupancy, and revenue data.
- Prepare daily, weekly, and monthly reports using Microsoft Excel and Google Sheets.
- Track booking sources, customer enquiries, conversion rates, and guest feedback.
- Analyze weekday vs. weekend occupancy, seasonal demand, holidays, and booking patterns.
- Research competing villas, resorts, and holiday properties to compare pricing, amenities, offers, and availability.
- Analyze pricing and help identify opportunities to improve occupancy and revenue.
- Monitor website traffic, social media engagement, and digital marketing performance.
- Create dashboards, charts, and management reports to present key insights.
- Assist with revenue forecasting and future booking analysis.
- Identify trends and opportunities to improve booking conversions, marketing performance, and guest experience.
- Coordinate with marketing, guest relations, and operations teams to collect and organize data.
Requirements & Tech Stack
- Basic Knowledge:
- Excel or Google Sheets
- Formulas
- Sorting
- Filtering
- Organizing data
- Good to Have:
- Pivot Tables
- VLOOKUP/XLOOKUP
- Power BI
- SQL
- Google Analytics
- Dashboards
- Charts
- Basic Python
Qualifications
- Freshers, students, graduates, undergraduates, and diploma holders are welcome.
- Candidates from B.Com, BMS, BAF, BBA, B.Sc, BCA, IT, Computer Science, Statistics, Mathematics, Business Analytics, Data Analytics, Hospitality Management, and other educational backgrounds can apply.
- Good analytical ability.
- Attention to detail.
- Basic computer knowledge.
- An interest in working with data.
Prior professional experience is not required. Training and guidance will be provided.