Business Analyst (Commercial Trading Team)

Admix; Gurugram District; On-site; INR 600,000 - 1,200,000; Full time

Job summary

Admix in India seeks a Business Analyst to collect, validate, analyze, and interpret data across procurement, quality, production, inventory, and sales to generate MIS reports, dashboards, trends, and actionable insights for management to improve plant efficiency and profitability.

The role focuses on converting operational data into business intelligence through Power BI dashboards, Excel analytics, and SQL-based reporting to support cost control and optimization across production and

Qualifications

• Bachelor's degree in Statistics/Business Analytics/Data Analytics; MBA in Finance/Operations/Business Analytics/Supply Chain can be an advantage.
• 3-5 years of experience in manufacturing/commodity/FMCG operations; proficient in Advanced Excel, SQL and Power BI; experience in MIS reporting, production analysis, inventory management, procurement analytics, cost analysis and dashboard development.
• Strong understanding of manufacturing KPIs, data validation, variance analysis and business intelligence; ability to translate operational data into actionable insights for management.

Responsibilities

• Analyze daily production data for oilseed crushing/extraction and refining.
• MIS & Management Reporting - Prepare daily, weekly, and monthly MIS.
• Analyze procurement quantities and purchase prices of Raw material.
• Inventory Analysis.
• Cost & Profitability Analysis.
• Sales & Commercial Analysis.
• Prepare actual vs. budget/standard cost variance reports.
• Dashboard Development - Production, Procurement, Inventory, Profitability.
• Data Management & Automation.
• Cross-Functional Coordination.

Skills

Advanced Excel

SQL

Power BI

Data Analysis

MIS reporting

Production analysis

Inventory management

Procurement analytics

Cost analysis

Dashboard development

Education

Bachelor's degree in Statistics/Business Analytics/Data Analytics

Tools

ERP knowledge

Python

Job description

Job Summary

The Business Analyst will be responsible for collecting, validating, analyzing, and interpreting data related to procurement, raw-material quality, production, oil extraction, inventory, sales, costing, and plant operations. The role will convert operational and commercial data into MIS reports, dashboards, trends, forecasts, and actionable insights to help management improve plant efficiency, reduce losses, control costs, optimize inventory, and increase profitability.

Your Responsibilities

• Analyze daily production data for oilseed crushing/extraction and refining.
• MIS & Management Reporting - Prepare daily, weekly, and monthly MIS.
• Analyze procurement quantities and purchase prices of Raw material.
• Inventory Analysis.
• Cost & Profitability Analysis.
• Sales & Commercial Analysis.
• Prepare actual vs. budget/standard cost variance reports.
• Dashboard Development - Production, Procurement, Inventory, Profitability.
• Data Management & Automation.
• Cross-Functional Coordination.

Your Profile

• Bachelor's degree in Statistics/Business Analytics/Data Analytics
• An MBA in Finance, Operations, Business Analytics, or Supply Chain can be an advantage.
• Business Analyst with 3-5 years of experience in manufacturing/commodity/FMCG operations, proficient in Advanced Excel, SQL and Power BI, with experience in MIS reporting, production analysis, inventory management, procurement analytics, cost analysis and dashboard development. Strong understanding of manufacturing KPIs, data validation, variance analysis and business intelligence, with the ability to translate operational data into actionable insights for management. (MIS, Power BI dashboards, Management reporting, Automate MIS)

Required Technical Skills (Must-Have)

• Microsoft Excel - Advanced
• Power BI
• SQL
• Data Analysis & Statistics

Preferred Skills

• Python
• ERP Knowledge