Internship Application: Last Mile Engineering & Data Analytics

Round 1: Online Aptitude Test (quantitative, logical reasoning, data interpretation) → Round 2: Technical Interview (SQL queries, Excel case studies, data analysis scenarios) → Round 3: HR Interview (behavioral questions, fitment, internship expectations)

Delhivery promotes a fast‑paced, merit‑based culture where ideas are encouraged and ownership is rewarded. Employees benefit from continuous learning programs, mentorship, and a collaborative environment that balances challenging projects with work‑life flexibility. The company’s emphasis on technology and innovation provides ample growth opportunities for early‑career professionals.

Delhivery’s interview process typically starts with a timed online aptitude test covering quantitative, logical, and data‑interpretation questions. Shortlisted candidates face a technical interview focusing on SQL query writing, Excel case studies, and scenario‑based data analysis. The final HR round assesses communication skills, cultural fit, and motivation for the internship. Overall difficulty is moderate; thorough preparation of fundamentals and clear articulation of past projects are key to success.

B.Tech / BE / B.E. in Engineering (Computer Science, Electronics, Mechanical, Electrical, or related fields). Must be in 3rd or 4th year of study (or recent graduate) with a minimum of 60% aggregate (or CGPA 6.0/10). No active backlogs at the time of application. Candidates should have basic knowledge of SQL, Excel, and data reporting. Strong analytical mindset and good communication skills are essential.

Delhivery is one of India’s leading logistics and supply‑chain technology companies, founded in 2015 and headquartered in Bangalore. With a network that spans more than 2,000 cities and towns, the firm handles over 1.5 million parcels daily, leveraging advanced analytics, AI‑driven route optimization, and a robust last‑mile delivery fleet. The company’s mission is to make commerce accessible to every corner of the country, and it has earned multiple awards for innovation, rapid growth, and employee satisfaction. Delhivery’s culture emphasizes data‑driven decision making, continuous learning, and a start‑up mindset despite its large scale, offering interns exposure to real‑world challenges that shape the future of Indian e‑commerce logistics. The Last Mile Engineering & Data Analytics internship is designed for 3rd and 4th‑year engineering students who are passionate about electric‑vehicle (EV) integration, logistics optimization, and data analytics. Interns will work closely with the operations, product, and analytics teams to support projects that improve delivery efficiency, reduce carbon footprint, and enhance the overall customer experience. The role offers hands‑on experience with SQL databases, advanced Excel reporting, and MIS dashboards, while also providing a platform to develop business communication skills in a fast‑paced environment. Key Responsibilities: 1. Collect, clean, and analyze large datasets related to delivery routes, vehicle performance, and EV adoption. 2. Develop and maintain SQL queries and stored procedures to extract actionable insights for the operations team. 3. Create dynamic Excel models and dashboards for daily, weekly, and monthly MIS reporting. 4. Assist in designing data pipelines that feed real‑time metrics into the company’s logistics platform. 5. Participate in cross‑functional meetings to translate business requirements into analytical solutions. 6. Conduct root‑cause analysis of delivery delays and propose data‑backed improvement plans. 7. Support the evaluation of EV pilot programs by tracking key performance indicators such as energy consumption and cost savings. 8. Prepare concise presentations and reports for senior leadership, highlighting findings and recommendations. 9. Collaborate with software engineers to integrate analytical tools into existing workflows. 10. Stay updated with industry trends in logistics, EV technology, and data analytics to bring fresh ideas to the team. Tech Stack: SQL (MySQL/PostgreSQL), Microsoft Excel (Power Query, PivotTables), Python (pandas, matplotlib) for advanced analysis, Tableau/PowerBI for visualization, and basic knowledge of cloud platforms (AWS/GCP) is a plus. Growth Path: Successful interns may receive a full‑time offer as Data Analyst, Business Analyst, or Operations Analyst, with clear progression to senior analyst, manager, and leadership roles based on performance. Why Join Delhivery? The internship offers exposure to a high‑impact domain, mentorship from industry experts, and the chance to contribute to sustainability initiatives through EV projects. Interns gain a portfolio of real‑world analytics projects, enhancing employability in the booming logistics and data‑science sectors.