From a non-CS branch to data analytics or consulting

Can a Mechanical or Civil student become a data analyst?

Yes. Analyst roles at analytics and consulting firms test problem solving, SQL, Python or Excel, and how clearly you explain an analysis. Your branch matters much less than proof that you can do the work. Five of the seniors below came from Civil, Mechanical or Chemistry and now work in analytics or consulting.

One Mechanical senior said the hardest part was the noise: everyone kept saying data jobs were only for CS graduates. What changed things was a structured learning path and a portfolio, not a different degree. Forum threads also suggest the market is tighter than it was a few years ago, so treat projects and referrals as essential, not optional.

What to learn, and in what order

The seniors who moved fastest learned in a fixed order and did not start the next tool until they had used the last one on a real dataset.

• Excel: pivot tables, lookups and basic charts. One Metallurgy senior said they wished they had started here in second year.
• SQL basics: joins, group by, window functions. One senior took two weeks for the basics.
• Python for data analysis with pandas. The same senior did a four-week course before touching SQL.
• One visualisation tool, such as Power BI or Tableau, to present results.
• Then two end-to-end projects before learning anything else.

Projects that make a non-CS profile credible

Use your branch as an advantage. A Mechanical senior who joined ZS recommends two end-to-end mini-projects, such as a sales-data analysis or a predictive-maintenance model, plus quantified results from your branch projects on the resume. A Civil senior recommends posting small Kaggle analyses on GitHub to show steady progress.

Package every project the same way: the problem, your approach, the tools you used and the result. One senior recommends a one-page portfolio PDF in that format next to your GitHub links, so a recruiter can understand the work in a minute.

How to get the interview: off-campus, alumni and referrals

Campus drives for non-CS branches often list only core roles, and one senior's biggest mistake was applying only on campus. The seniors who got analytics offers reached out to alumni from their college working at ZS, IQVIA or similar firms, asked for short informational chats, and only then asked for referrals.

Cold emails work too. A Metallurgy senior emailed professors directly and landed an internship at IIM Bangalore within four months of starting to explore non-core fields, with no prior machine learning or business analysis background.

Consulting and management internships from an engineering branch

An Electrical senior from VNIT Nagpur got a management internship at IIM Mumbai in second year with no management background. They learned marketing basics from free NPTEL lectures, built small tech projects tied to real problems, and practised interviews with seniors and professors.

A Civil graduate worked on a large infrastructure project, joined Deloitte in infrastructure consulting, and later got an IIM Ahmedabad call. A Chemistry student from IIT Bombay moved into analytics consulting at Aspect Ratio through analytics internships and by framing their science background as problem-solving experience.

How long the switch takes

• About 8 months from a first coding course to joining ZS Associates (Mechanical, final year).
• 8 months of self-study while working in structural engineering, then an AI/ML analyst role at ZS (Civil).
• About 2 years after college to Associate Consultant at IQVIA (Civil).
• 4 months from starting to explore non-core fields to an IIM Bangalore internship (Metallurgy).

Mistakes these seniors say to avoid

• Learning every data tool at once instead of Python and SQL first.
• Taking theory-heavy courses without applying them to a project.
• Using a generic resume without quantified outcomes.
• Waiting until final year to network with people in data and consulting.
• Starting Python and SQL late. One Civil senior wished they had started in first year.

Real journeys from Atyant seniors

Frequently asked questions

Do analytics and consulting firms hire Civil or Mechanical graduates?

Yes. Atyant seniors from Civil and Mechanical were hired as analysts and consultants at ZS Associates and IQVIA. They showed Python, SQL and a few explainable projects, and most came in through off-campus applications and referrals.

Do I need a master's in data science to switch from a non-CS branch?

Not necessarily. Some forum advice recommends a full-time analytics degree in a tight market, but the seniors here switched with self-study, projects, internships and referrals, either in final year or within two years of graduating.

Should I learn Python or SQL first for a data analyst role?

Learn both early. One senior did a four-week Python-for-data-analysis course, then two weeks of SQL basics, then built two end-to-end projects before adding any other tool.

When should a non-CS student start preparing for analytics roles?

By second year if you can. Almost every senior here said they wished they had started Excel, Python and SQL one or two years earlier than they did.