– Back Office Executive (Advanced Excel)

Position: Back Office Executive

Department: Back Office / Operations

Location: Mumbai

Experience: 2–5 years

Employment Type: Full-time

Job Summary

We are looking for a detail-oriented and proficient Back Office Executive with solid Advanced Excel skills to manage day-to-day data, documentation, MIS, reporting, and administrative coordination. The candidate should be comfortable working with large datasets, preparing reports, maintaining records, and providing accurate information to management and various departments.

Key Responsibilities

- Manage and maintain daily operational data and records in Excel.
- Prepare daily, weekly, and monthly MIS reports for management.
- Handle large datasets and ensure data accuracy and timely updates.
- Prepare and maintain sales, purchase, inventory, dispatch, receivables/payables, and other operational reports as required.
- Perform data analysis and provide meaningful reports and summaries.
- Create and maintain Excel dashboards, trackers, and automated reports.
- Coordinate with Sales, Purchase, Accounts, Stores, Quality, and other departments for data collection and verification.
- Monitor pending activities, follow-ups, and status reports.
- Prepare management reports using Excel and other reporting tools.
- Maintain proper documentation and filing of records.
- Identify discrepancies or errors in data and coordinate with the concerned department for correction.
- Assist management with ad-hoc reports, data analysis, and presentations.
- Ensure confidentiality and accuracy of company information.

Advanced Excel Skills Required The candidate should have hands-on knowledge of:
- VLOOKUP / HLOOKUP / XLOOKUP




- INDEX & MATCH
- IF, IFS, AND, OR, IFERROR
- SUMIF / SUMIFS
- COUNTIF / COUNTIFS
- TEXT, DATE & other commonly used functions
- Pivot Tables & Pivot Charts
- Advanced Filters & Sorting
- Conditional Formatting
- Data Validation
- Data Cleaning & Formatting
- Excel Dashboards
- Charts and Graphs
- Subtotals and Consolidation
- What-If Analysis
- Basic Excel automation / Macros or VBA would be an added advantage.
- Knowledge of Power Query / Power Pivot will be an advantage.

Required Skills
- Excellent knowledge of MS Excel.
- Strong analytical and problem-solving skills.
- Good numerical and data-handling ability.
- Excellent attention to detail.
- Good written and verbal communication skills.
- Ability to manage multiple tasks and meet deadlines.
- Good coordination and follow-up skills.
- Ability to work independently as well as with different departments.
- Good knowledge of MS Word, PowerPoint, and Outlook.

Qualification

Graduate in any discipline.

Candidates with a background in Commerce, Management, Business Administration, or related fields will be preferred.

Preferred Experience

- 2–5 years of experience in Back Office, MIS, Operations, Data Management, or similar roles.
- Experience in manufacturing, trading, engineering, or steel industry will be an added advantage.

Key Performance Areas (KPIs)
- Accuracy of data and reports.
- Timely submission of MIS and management reports.
- Efficiency in handling large datasets.
- Accuracy of Excel calculations and analysis.
- Timely follow-up and coordination with departments.
- Reduction of manual reporting through Excel automation.

Pay: ₹10,729.77 - ₹25,000.00 per month

Work Location: In person

📌 Back Office Executive (Grant Road)
🏢 Valour Alloys
📍 Grant Road