Business Analyst - Process & Automation

Weekday (YC W21); Mumbai; On-site; INR 900,000 - 1,300,000; Full time

Job summary

Business Analyst – Process & Automation in Mumbai, India, reporting to the Owner. The role requires 3+ years experience with a focus on mapping processes and building automated solutions in Python/pandas and Excel.

You will act as the quality filter between the owner and the team, reviewing quotations, models, and formulas for errors and logic before delivery.

Qualifications

• Strong Excel skills with formulas and auditing.
• Python with pandas or equivalent data tools.
• Analytical, structured, logical with keen accuracy.
• Effective communication to extract process knowledge.

Responsibilities

• Map business processes by talking to departments and outlining current flows.
• Identify gaps, design improved systems, and implement them in software.
• Build and maintain automation for recurring analysis and reporting.
• Review team Excel work before submission to owner for errors.
• Translate owner requirements into tested end-to-end solutions.

Skills

Excel

Python/pandas

Analytical thinking

Communication

Education

Graduate in engineering / statistics / commerce

Job description

This role is for one of our clients

Seniority level: Associate level

Min Experience: 3+ years

Location: Mumbai, Maharashtra, India

JobType: full-time

POSITION: Business Analyst – Process & Automation

COMPANY: Bhalaria Metal Craft — manufacturer, white-labeller and exporter of stainless steel kitchenware, tableware and barware (10,000+ SKUs)

REPORTS TO: Owner (directly)

We may use artificial intelligence (AI) tools to support parts of the hiring process, such as reviewing applications, analyzing resumes, or assessing responses and identifying potential inconsistencies or verification signals in application materials based on available information. These tools assist our recruitment team but do not replace human judgment. Final hiring decisions are ultimately made by humans. If you would like more information about how your data is processed, please contact us.

Work directly with the owner to map business processes, find and fix gaps, design improved systems, and execute them in software (Python / pandas / Excel). Act as the quality filter between the owner and the team — reviewing all incoming analytical work (quotations, Excel models, formulas) for errors, structure and logic.

Requirements

KEY RESPONSIBILITIES:

• Understand business processes by talking to people across departments and asking the right questions; map current process flows (production planning, forecasting, costing, and similar areas)
• Identify gaps in processes, design improved systems, and implement them using Python/pandas/Excel or equivalent tools
• Build and maintain automation for recurring analysis and reporting
• Review the team's Excel work — quotations, formulas, models — as a filter before it reaches the owner: check for errors, structure and logic
• Translate the owner's requirements into working, tested solutions and execute end to end

MUST-HAVE SKILLS:

• Strong Excel: formulas, structuring workbooks, auditing other people's sheets
• Python with pandas (or equivalent data tools — must be able to deliver the same outcomes)
• Analytical, structured, logical mind with strong error-catching ability — accuracy is critical in this role
• Good communication skills — comfortable talking to people to extract process knowledge; personable and easy to talk to, not a silent back-office profile

GOOD TO HAVE:

• Business/commercial awareness (costing, quotations, planning)
• Manufacturing or SME exposure
• Graduate in engineering / statistics / commerce with a strong quantitative bent

Must-have skills

Python, Business Process Mapping

Good-to-have skills

Computer Science, engineer