Website Novel Office

Apply for the 3-month remote Data Analyst Internship at Novel Office (Bengaluru). Gain hands-on experience in data cleaning, Excel reporting, and data preparation for HR systems using Python and SQL.

About the Company: Novel Office

Novel Office is a premier commercial real estate and flexible workspace provider belonging to the Dallas, Texas-based Novel Group (established in 1993). Disrupting the office space market with a unique business model, Novel Office specialises in providing fully furnished, customizable managed offices, co-working networks, and serviced commercial properties with flexible “No Lock-in, No Deposit” options. The firm designs and constructs class-A properties, leveraging a waste-free, in-house partition concept to dynamically scale and layout office configurations to match client needs.

This specialised tracking role is hosted within the Data Science & Analytics Department. Operating out of the corporate regional head office in Marathahalli, Bengaluru, this team leverages information parsing, database logic, and business metrics to optimise property metrics, streamline back-office operations, and accelerate internal departmental performance.

About the Role: Data Analyst Intern (3-Month Remote Program)

Are you looking to break into the field of data analytics, master operational workflows, and apply your programming skills to real-world corporate challenges? Novel Office is hiring a Data Analyst Intern for a 3-Month, Unpaid, Remote (Work from Home) learning program. This temporary contractual track is designed for current university students, proactive fresh graduates, or career changers who want to build a portfolio by mastering data cleaning, predictive pattern spotting, and metric visualisation.

As a Data Analyst Intern, you will serve as a core analytical bridge supporting internal enterprise units—specifically working in close alignment with the Human Resources division. Your primary focus will center on building and preparing clean, audited consumer and applicant datasets to optimise calling queues for internal HR recruiters. Utilising Excel, SQL, and Python, you will profile data to fix missing variables, build scannable performance dashboards, and compile analytical reports that directly guide management choices and office space policy.

Key Responsibilities & Analytical Intern Workflows

  • HR Dataset Cleansing & Prep: Filter, deduplicate, and organise outbound calling datasets for HR Recruiters, verifying complete accuracy and handling missing data points to maximise recruitment dialing efficiency.

  • Data Profiling & Exploratory Analysis: Apply basic statistical tools to explore internal data, identifying patterns, customer relationships, and operational trends.

  • Excel Dashboard & Chart Architecture: Build interactive pivot tables, conditional formatting templates, and visual data representations to present findings in a clear, scannable format.

  • Cross-Departmental Reporting: Create structured performance summaries and data presentations to clearly communicate data findings to internal business stakeholders.

  • Operational Pipeline Collaboration: Partner directly with adjacent departments to map out their unique data tracking needs, providing raw analytical support to improve daily output.

Candidate Prerequisites & Key Technical Skills

Successful candidates must combine a strong conceptual grasp of analytical methodologies with an organised approach to validating database records.

Required Experience & Educational Baseline:

  • Academic Enrolment / Graduate Standing: Open to any current student or graduate holding a Bachelor’s, Undergraduate, or Postgraduate degree.

  • Professional Status: 0 to 1 year of experience. Optimised for enthusiastic freshers seeking verified corporate internship credentials.

  • Analytics Training Baseline: Completion or ongoing pursuit of any verified Data Analytics course certification.

  • Core Soft Skills: Strong written and verbal communication skills to interact effectively across a distributed remote workforce.

Core Technical Stack Requirements:

  • Spreadsheet Mastery: Practical comfort using Microsoft Excel (formulas, formatting, and standard chart building).

  • Database Querying: Foundational knowledge of SQL to extract and filter records.

  • Programming Concepts: Basic script-writing literacy in Python for data manipulation or file processing loops.

Core Position Specifications

  • Position Title: Data Analyst Intern

  • Hiring Organisation: Novel Office (Novel Group)

  • Corporate Work Location: 100% Remote (Work from Home) / Hiring Hub: Bengaluru, Karnataka

  • Program Duration: 3-Month Fixed-Term Engagement

  • Remuneration Structure: Unpaid Internship (Hands-on Portfolio & Experience Focus)

  • Employment Framework: Part-Time / Temporary / Contractual

  • Functional Focus: HR Data Ingestion, Data Cleansing, Excel Modelling, and Pattern Recognition

  • Industry Placement: Commercial Real Estate / Co-working & Flexible Managed Spaces

  • Functional Department: Data Science & Analytics

Upload your CV/resume or any other relevant file. Max. file size: 2 GB.