Business Analyst - Process & Automation

Weekday; Mumbai; On-site; INR 500,000 - 1,500,000; Full time

Job summary

Bhalaria Metal Craft is seeking an Associate-level Business Analyst to map and optimize company processes in Mumbai. You will design automated solutions using Python, pandas and Excel, acting as the quality filter between the owner and team.

Role requires 3+ years of experience, strong Excel skills, and excellent communication to capture cross-department requirements and translate them into working, tested software solutions.

Qualifications

• Understand business processes by talking to people across departments and mapping current process flows.
• Experience designing and implementing automated analysis using Python/pandas/Excel.
• Strong Excel skills with auditing and error-checking.
• Excellent communication to extract process knowledge.

Responsibilities

• Map business processes across departments and identify gaps.
• Design and implement improved systems using Python/pandas/Excel.
• Review analytical work for errors, structure and logic before delivery.
• Translate owner requirements into tested, end-to-end solutions.

Skills

Python with pandas

Advanced Excel

Analytical thinking

Communication skills

Education

Graduate degree (engineering / statistics / commerce)

Tools

Python

Pandas

Excel

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)

₹5,00,000 - ₹15,00,000 a year

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

• 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