Data Analyst - Chemical Manufacturing Industry

The-Search-House; Palghar; On-site; INR 600,000 - 900,000; Full time

Job summary

The-Search-House is seeking a Data Analyst for our chemical manufacturing vertical to collect, validate, and analyze production, inventory, quality, and maintenance data. You will generate insights for management using Excel and Power BI, supporting decision-making across manufacturing operations.

Applicants should have a Bachelor’s degree in a related field, strong MS Excel skills, and familiarity with Power BI; SQL basics are a plus.

Qualifications

• Proficient in MS Excel with advanced functions and dashboards.
• Experience with Power BI preferred; SQL basics advantageous.
• Strong analytical and problem-solving skills in manufacturing data.

Responsibilities

• Data collection and validation from production ERP and reports.
• Perform production, inventory, quality, and maintenance analyses.
• Develop MIS and management reports in Excel and Power BI.
• Analyze raw materials, procurement, and cost drivers.
• Monitor manpower, maintenance metrics, and efficiency indicators.
• Coordinate data integration across ERP systems and dashboards.

Skills

MS Excel

Pivot Tables

XLOOKUP/VLOOKUP

SUMIFS

IF functions

Dashboards

Data cleaning

Power BI

SQL basics

Analytical thinking

Manufacturing processes

Data presentation

Education

Bachelor's Degree in Statistics/ Operations Management/ Mathematics/ Commerce/ Finance

Data Analytics / Business Analytics / Computer Science

Tools

Power BI

SQL

Job description

Data Analyst - Chemical Manufacturing Industry

Job Summary:
The Data Analyst will be responsible for collecting, validating, analyzing, and presenting manufacturing and operational data to support management in making informed decisions. The role will focus on production, raw materials, inventory, quality, sales, manpower, maintenance, wastage, dispatch, and overall factory performance. All activites related to day to day operations & management reports are mandatory to generate from Excel & Power BI.
Key Responsibilities :-
A. Data Collection & Management
B. Production & Manufacturing Analysis
C. Raw Material & Inventory Analysis
D. Quality Data Analysis
E. Manpower & HR Analytics
F. Maintenance Analytics
G. MIS & Management Reporting
H. Cost & Efficiency Analysis
I. ERP & Data Integration
Key Performance Indicators (KPIs)

• Accuracy of MIS and analytical reports
• Timeliness of daily/weekly/monthly reports
• Production Plan vs. Actual variance
• Reduction in data errors and discrepancies
• Inventory and consumption variance
• Reduction in production wastage and rejection
• Machine downtime analysis accuracy
• Timely identification of operational deviations
• Dashboard/report automation
• Quality of management insights and recommendations
• ERP data accuracy and reconciliation
• Improvement in reporting turnaround time

Required Skills

• Strong knowledge of MS Excel , including Pivot Tables, XLOOKUP/VLOOKUP, SUMIFS, IF functions, charts, dashboards, and data cleaning.
• Knowledge of Power BI is preferred.
• Basic understanding of SQL/database concepts will be an advantage.
• Strong analytical and problem-solving skills.
• Good understanding of manufacturing processes and factory operations.
• Ability to work with large volumes of data.
• Strong attention to detail and accuracy.
• Good communication and coordination skills.
• Ability to convert complex data into simple management reports.

Educational Qualification
Bachelor's Degree in:

• Statistics/ Operations Management
• Mathematics / Commerce / Finance
• Data Analytics
• Business Analytics
• Computer Science

A certification in Data Analytics / Power BI / Advanced Excel is mandatory
Preferred Experience
Candidates with experience in FMCG, chemical, cleaning & hygiene products, manufacturing, pharma, food, or similar production environments will be preferred.
Experience in analyzing production, inventory, quality, manpower, maintenance, and operational data will be an advantage.
About Company:-
Our client is a Goregaon (West), Mumbai-based, ISO 9001:2015 & ISO 14001:2015 certified manufacturer of cleaning and hygiene chemicals, with over four decades of industry experience. Its range spans housekeeping, kitchen, laundry, personal care and disinfectant products, plus specialised solutions for the dairy, pharma, food and travel sectors. The company serves leading hotels, hospitals, airports and corporates through a distribution network across 30+ Indian cities