Data Analyst Intern

Candidates typically face a three‑stage process: an online aptitude test lasting 30‑40 minutes, followed by a technical interview where interviewers probe SQL query writing, Excel pivot/tableau basics, and Python data‑wrangling. The final HR round assesses communication, motivation, and cultural fit. Overall difficulty is moderate; thorough preparation on core analytics tools and clear articulation of past projects greatly improve chances.

Novel Office promotes a flexible, results‑oriented work culture where employees are encouraged to experiment and take ownership of projects. The company offers a balanced work‑life environment with remote‑first policies, regular learning sessions, and clear growth pathways for high‑performers.

Any graduate (B.Tech/B.Sc./B.Com./BA) or postgraduate degree; any discipline; minimum 60% aggregate or CGPA 6.0/10; batch years 2023‑2026; no active backlogs at the time of joining; strong interest in data analytics and willingness to learn.

Round 1: Online Aptitude Test → Round 2: Technical Interview (focus on Excel, SQL, Python and data‑analysis concepts) → Round 3: HR Interview (fit, communication and internship expectations)

Novel Office is a fast‑growing player in the Indian co‑working and serviced office space market. Established as part of the Novel Group in 1993, the company has a strong legacy of providing fully‑furnished, customizable office solutions across major Indian metros. With its headquarters in Bengaluru and a business model that blends real‑estate investment with flexible leasing, Novel Office offers a dynamic environment where technology and operations intersect. The firm’s culture emphasizes innovation, customer‑centricity, and a collaborative spirit, making it an attractive place for fresh talent eager to contribute to a sector that is reshaping how businesses work. The Data Analyst Intern role is a three‑month, work‑from‑home opportunity designed for students and recent graduates who want hands‑on exposure to the end‑to‑end data lifecycle. Interns will be embedded within the Data Science & Analytics team, supporting real‑world projects that directly influence recruitment, space utilization, and strategic decision‑making. The position offers a practical learning curve: from cleaning raw HR and operational datasets to building visual dashboards that senior leadership can act upon. **Key Responsibilities** 1. Filter, clean, and preprocess raw datasets to ensure accuracy and completeness, handling missing values and outliers. 2. Conduct exploratory data analysis using statistical techniques to uncover patterns, correlations, and trends. 3. Develop interactive Excel reports and dashboards that visualise key performance indicators for HR recruiters and operations managers. 4. Write concise analytical reports and presentations that translate data insights into actionable recommendations. 5. Collaborate with cross‑functional teams (HR, Operations, Sales) to understand data requirements and deliver tailored solutions. 6. Automate repetitive data‑preparation tasks using Python scripts and SQL queries. 7. Maintain documentation of data pipelines, assumptions, and methodology for future reference. 8. Participate in weekly team stand‑ups, sharing progress and seeking feedback to refine analyses. 9. Assist in ad‑hoc data requests and support the senior analysts in larger strategic projects. 10. Stay updated with industry best practices in data analytics and suggest improvements to existing workflows. **Tech Stack**: Microsoft Excel (advanced functions, Power Query, PivotTables), SQL (MySQL/PostgreSQL), Python (pandas, numpy, matplotlib/seaborn), data‑visualisation tools (Power BI or Tableau – optional), and basic statistical packages. **Growth Path**: Successful interns may be considered for a full‑time Analyst position or a longer‑term contract, with clear avenues to specialize in Business Intelligence, Data Engineering, or Product Analytics within Novel Office’s expanding analytics function. **Why Join**: This internship offers a rare blend of real‑world impact and mentorship in a sector that is booming post‑pandemic. Interns gain exposure to both the real‑estate business model and cutting‑edge analytics, building a portfolio that stands out to future employers. The remote‑first setup provides flexibility while still fostering a supportive community through regular virtual interactions and knowledge‑sharing sessions.