Business Analyst Intern - 6 Months (Performance based PPO)

Candidates typically face a 50‑minute aptitude test followed by a one‑hour technical assessment focused on SQL queries, Excel automation, and data visualization. Successful candidates then attend a video interview and two in‑depth discussions with senior team members, assessing analytical thinking, business acumen, and cultural fit. Preparation should include practicing SQL joins, pivot tables, and scenario‑based business questions.

Logo Careers fosters a high‑energy, merit‑based environment where ideas are judged on impact rather than seniority. Employees enjoy rapid career progression, frequent appraisals, and a flat hierarchy that encourages open communication. While the workload is intense, the team values learning, ownership, and a collaborative spirit.

Graduates or final‑year students (2024‑2026) in Engineering, B.Tech/B.E., B.Sc., B.Com, MCA, or related fields; minimum 60% aggregate; no active backlogs; strong analytical mindset; proficiency in Excel and SQL; willingness to work 10‑12 hours per day, 6 days a week.

Round 1: Aptitude Test → Round 2: Technical Assessment Task → Round 3: Personal Interviews (1 video interview + 2 detailed discussions) → Round 4: Offer Extension

Logo Careers is a fast‑growing B2B travel‑tech startup that is redefining how travel agents sell and deliver travel experiences across the globe. By offering a single platform for booking flights, hotels, and holiday packages, the company streamlines the end‑to‑end travel journey for agents and their customers. With a gross merchandise value (GMV) exceeding INR 1,000 crore and backing of more than USD 5.5 million from prominent global investors, Logo Careers combines a robust business model with a relentless focus on customer delight. The found ing team brings deep expertise from leading internet and travel ventures – Ashish (ex‑CTO Cars24, FabFurnish, Gaadi), Arun (ex‑Cars24, TravelTriangle, TripFactory, IIM Bangalore) and Chirag (ex‑Oyo, TravelTriangle, IIM Ahmedabad, IIT Roorkee) – ensuring strong strategic direction and operational excellence. The Business Analyst Intern will play a pivotal role in translating raw data into actionable insights that drive product, sales, and operational decisions. Reporting to senior leadership, the intern will collaborate with cross‑functional teams, including product, engineering, and operations, to build data‑driven solutions that improve efficiency and enhance the customer experience. This is a performance‑based internship with a potential Pre‑Placement Offer (PPO) that can translate into a full‑time role with a CTC of INR 5‑7 LPA for high‑performing candidates. Key Responsibilities (8‑10 points): 1. Prepare daily, weekly, and monthly performance reports for senior management. 2. Design and maintain interactive dashboards using Google Data Studio or Tableau. 3. Conduct regular health‑checks, data validation, and cleansing of large travel‑booking databases. 4. Develop Excel‑based automation tools and VBA/App Script macros to streamline repetitive tasks. 5. Write advanced SQL queries to extract, transform, and analyze transactional data. 6. Create ad‑hoc analytical models to answer business questions and support strategic initiatives. 7. Collaborate with product managers to define key metrics and track feature adoption. 8. Assist in building predictive models for demand forecasting and pricing optimization. 9. Document data pipelines, reporting standards, and best practices for knowledge sharing. 10. Participate in weekly stakeholder meetings to present insights and recommend actions. Tech Stack: Advanced SQL, Google Sheets, Microsoft Excel, VBA, Google Apps Script, Google Data Studio, Tableau, basic Python (optional). Growth Path: Successful interns receive a certificate, a letter of recommendation, and may be offered a PPO leading to a full‑time Business Analyst role with rapid salary hikes and promotion opportunities. The startup environment provides high ownership, exposure to senior founders, and the chance to shape product strategy. Why Join: Apart from a competitive stipend and performance‑linked incentives, interns enjoy an informal dress code, free snacks, a young and passionate team, and a culture that rejects hierarchy and politics. The role offers hands‑on experience with real‑world travel data, fast‑track career growth, and the possibility of a lucrative full‑time offer after six months.