Company: Hindustan Gold Industries

Location: Sindhu Bhavan, Ahmedabad

Department: MIS / Business Operations

Experience: 2–5 Years

Roles & Responsibilities
Prepare and maintain daily, weekly, and monthly MIS reports using Microsoft Excel.
Manage multiple Excel files, reports, worksheets, and data sources.
Develop management dashboards, trackers, summaries, and analytical reports.
Use advanced Excel functions, Pivot Tables, XLOOKUP, INDEX-MATCH, Power Query, Charts, and Conditional Formatting.
Perform data validation, reconciliation, cross-checking, and error identification.
Handle rate-based calculations, unit conversions, and business-related data calculations.
Support conversion and comparison of measurement units used in business operations.
Analyze trends, variances, and changes and present meaningful insights to management.
Automate repetitive Excel-based reporting wherever possible.
Coordinate with different departments to collect and validate data.
Prepare ad-hoc reports and analysis as required by management.
Maintain accuracy, confidentiality, and consistency of business data.

Candidate Profile
Graduate in Commerce, Business Administration, Mathematics, Statistics, Computer Applications, or related discipline.




2–5 years of experience in MIS, reporting, data analysis, business reporting, or similar roles.
Excellent working knowledge of Microsoft Excel is mandatory.
Robust command over Excel formulas, Pivot Tables, lookups, dashboards, data validation, and reporting.
Comfortable working with multiple Excel reports and complex calculations.
Robust numerical ability and attention to detail.
Valuable analytical and problem-solving skills.
Experience with Power BI / ERP will be an added advantage.
Precious metals, bullion, commodity, jewellery, or manufacturing exposure will be preferred.

Pay: ₹25,000.00 - ₹50,000.00 per month

Benefits
Health insurance
Paid sick time
Paid time off
Provident Fund

Application Question(s):
Are you currently located in Ahmedabad?
How many years of experience do you have in MIS Reporting?
Have you worked with multiple Excel reports, calculations, reconciliations rather than only large datasets? Please briefly describe.
Which advanced Excel functions are you highly proficient in?
Current Salary
Expected Salary
Notice Period

Work Location: In person

📌 Mis Executive Ahmedabad
🏢 Hindustan Gold Industries
📍 Ahmedabad