Business Analyst Intern - 6 Months (Performance based PPO)

The interview process typically starts with a 50‑minute aptitude test covering quantitative and logical reasoning. Successful candidates move to a one‑hour technical assessment focused on SQL queries, Excel automation, and data visualization. The final stage includes a video interview followed by two detailed discussions with senior team members, assessing problem‑solving ability, business acumen, and cultural fit. Preparation should focus on real‑world data scenarios and clear communication of analytical insights.

TravClan promotes an informal, high‑ownership culture with a focus on rapid execution and learning. Employees enjoy a flat hierarchy, free snacks, and the freedom to experiment, though the pace is intense with 10‑12 hour workdays. Growth is merit‑based, offering fast promotions and salary increments for high performers.

Graduates (B.Tech/B.E., B.Sc., B.Com, BBA, or equivalent) from any discipline with a minimum of 60% aggregate (or CGPA 6.0/10). No active backlogs at the time of joining. Freshers from the 2024, 2025 or 2026 batch are preferred. Strong analytical mindset and willingness to work 10‑12 hours per day, including Saturdays.

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

TravClan is a fast‑growing B2B travel‑tech startup that is redefining how travel agents sell and deliver holiday packages across the globe. With a GMV of over INR 1,000 crore and backing of more than USD 5.5 million from global investors, the company has built a robust platform that lets agents book flights, hotels, and holiday packages while also offering end‑to‑end on‑ground services. The founding team brings deep experience from successful internet ventures such as Cars24, Oyo, TravelTriangle, and FabFurnish, ensuring strong product and technology leadership. Their culture is built around high ownership, informal dress code, and a no‑politics environment, which makes it an attractive destination for ambitious freshers. The Business Analyst Intern role is a 6‑month performance‑based program that offers a stipend of Rs 25,000 per month for the first three months and Rs 30,000 per month thereafter. The internship culminates in a certificate, a letter of recommendation, and the possibility of a Pre‑Placement Offer (PPO) with a CTC ranging between 5 to 7 LPA. Interns will work directly with the founders and a young, passionate team, gaining exposure to real‑world business problems and data‑driven decision making. Key responsibilities include: 1. Preparing daily, weekly, and monthly business performance reports. 2. Designing and maintaining interactive dashboards using Google Data Studio or Tableau. 3. Conducting health checks, cleaning, and validating large datasets. 4. Developing Excel‑based automation tools and VBA/App Script solutions. 5. Writing advanced SQL queries for data extraction and analysis. 6. Collaborating with product, technology, and operations teams to translate business needs into analytical solutions. 7. Monitoring key metrics and flagging anomalies for rapid action. 8. Documenting processes and creating standard operating procedures for data workflows. 9. Assisting in ad‑hoc analytical projects that drive strategic decisions. 10. Continuously learning new tools and techniques to improve analytical efficiency. The tech stack revolves around SQL, advanced Excel/Google Sheets, VBA/App Script, and visualization tools like Google Data Studio or Tableau. Growth prospects are rapid – high performers can transition to full‑time Business Analyst roles with accelerated salary hikes and leadership opportunities. Joining TravClan means being part of a high‑velocity environment where you can make a tangible impact, learn from seasoned founders, and fast‑track your career in the travel‑tech domain.