Data Analyst Intern

Candidates typically face a three‑stage process: an initial timed aptitude test, followed by a technical interview that includes SQL queries and a Python data‑manipulation case, and finally an HR round assessing cultural fit and communication. The difficulty is moderate; thorough preparation on data cleaning, basic statistics, and SQL fundamentals helps.

Novel Office promotes a collaborative and flexible work culture where employees are encouraged to experiment and take ownership of projects. The company offers a balanced work‑life environment with regular virtual team‑building activities and clear growth pathways for high‑performers.

Any graduate (B.Tech/B.Sc./B.Com./MBA) with a minimum of 60% aggregate or equivalent CGPA. Must have completed a Data Analytics certification or relevant coursework. No active backlogs. Open to candidates from the 2025 batch (or graduating in 2025). 0‑1 years of experience; fresh graduates are encouraged to apply.

Round 1: Online Aptitude Test → Round 2: Technical Interview (SQL & Python case study) → Round 3: HR Interview

Novel Office is a fast‑growing player in the Indian co‑working and serviced office space market. Founded as part of the Novel Group in 1993 in Dallas, USA, the company entered India with a unique business model that blends real‑estate investment with flexible office solutions. Headquartered in Marathahalli, Bengaluru, Novel Office offers fully furnished, customizable office spaces with no lock‑in or deposit, catering to startups, SMEs, and large enterprises. Their in‑house partition technology allows rapid reconfiguration of office layouts, minimizing material wastage and setting them apart in a competitive market. The organization has expanded its footprint across major Indian metros, leveraging a buy‑and‑lease‑back strategy that ensures a steady pipeline of premium office locations. This approach not only drives revenue stability but also creates a dynamic environment where employees get to work on real‑world business challenges in a thriving real‑estate ecosystem. As a result, Novel Office has earned a reputation for innovation, employee empowerment, and a customer‑centric culture. **Role Summary** As a Data Analyst Intern, you will be immersed in the end‑to‑end data lifecycle, supporting the Data Science & Analytics team in cleaning, exploring, visualising, and reporting on datasets that drive strategic decisions across the company. The internship is remote (work‑from‑home) for three months and is unpaid, making it an ideal opportunity for fresh graduates or final‑year students seeking hands‑on experience with industry‑standard tools. **Key Responsibilities** 1. Filter, clean, and preprocess raw data to ensure accuracy and completeness. 2. Handle missing values, outliers, and inconsistencies in HR recruiter datasets. 3. Perform exploratory data analysis using statistical techniques to uncover patterns and trends. 4. Develop visualisations, dashboards, and Excel reports that translate insights into actionable recommendations. 5. Prepare concise presentations and written reports for senior management and cross‑functional teams. 6. Collaborate with marketing, sales, and operations to understand their data requirements and deliver tailored analytical solutions. 7. Automate repetitive data‑processing tasks using Python scripts. 8. Assist in building and maintaining a central data repository for easy access by various departments. 9. Participate in weekly knowledge‑sharing sessions and contribute ideas for process improvement. 10. Stay updated with emerging data‑analysis tools and best practices. **Tech Stack**: Microsoft Excel, SQL (MySQL/PostgreSQL), Python (pandas, numpy, matplotlib/seaborn), Power BI/Tableau basics, Git for version control. **Growth Path**: High‑performing interns may be offered a full‑time Analyst role, with exposure to advanced analytics, machine‑learning projects, and leadership opportunities within the Data Science & Analytics division. **Why Join Novel Office?** The company offers a vibrant, startup‑like atmosphere within a stable, revenue‑generating business. Interns gain real impact, mentorship from seasoned analysts, and a chance to contribute to strategic decisions that shape the future of flexible workspaces in India.