Job Description – Back Office Executive (Advanced Excel)
Position Details
- Job Title: Back Office Executive
- Department: Operations
- Location: Rajkot, Gujarat
- Employment Type: Full-Time
About Khushbu Auto Finance Limited (KAFL)
Khushbu Auto Finance Limited (KAFL) is a Non-Banking Financial Company (NBFC) specializing exclusively in 3-Wheeler Vehicle Finance. Incorporated in 1994, KAFL is a wholly-owned subsidiary of Atul Auto Limited (AAL), one of India's leading three-wheeler manufacturers. Registered with the Reserve Bank of India (RBI), KAFL operates through a network of 100+ branches across multiple states, delivering reliable and customer-focused financial solutions.
Key Responsibilities
- Prepare, maintain, and analyze MIS reports using Advanced Microsoft Excel.
- Manage and update large datasets with high accuracy.
- Create and maintain dashboards, reports, and trackers for management review.
- Perform data analysis to support business decision-making.
- Use VLOOKUP/XLOOKUP, HLOOKUP, INDEX-MATCH, IF, SUMIFS, COUNTIFS, TEXT Functions, Pivot Tables, Pivot Charts, Data Validation, Conditional Formatting, Power Query (preferred), and advanced formulas.
- Prepare daily, weekly, and monthly operational reports.
- Verify data accuracy and resolve discrepancies.
- Coordinate with different departments for timely collection and submission of data.
- Maintain proper documentation and digital records.
- Generate reports as per management requirements within defined timelines.
Required Skills
- Excellent knowledge of Advanced Microsoft Excel (Mandatory).
- Strong command of:
- Pivot Tables & Pivot Charts
- VLOOKUP, XLOOKUP & HLOOKUP
- INDEX-MATCH
- IF, Nested IF
- SUMIF/SUMIFS, COUNTIF/COUNTIFS
- Data Validation
- Conditional Formatting
- Text & Date Functions
- Power Query (Preferred)
- Good analytical and problem-solving skills.
- Strong attention to detail.
- Good communication and coordination skills.
- Ability to work with large volumes of data.
Educational Qualification
- Bachelor's Degree in Commerce, Business Administration, Computer Applications, or any relevant discipline.
- Certification in Advanced Excel will be an added advantage.
Experience
- 1–3 Years of experience in Back Office, MIS, Data Management, or Operations.
- Experience in NBFC, Banking, Finance, or Vehicle Finance will be preferred.
Salary
- CTC: ₹2.20 – ₹3.00 LPA (Depending on experience and skills)
Employee Benefits
- Provident Fund (PF)
- ESIC (as applicable)
- Gratuity (as per statutory norms)
- Group Personal Accident Insurance
- Group Medical Insurance (Coverage up to ₹1.25 Lakhs)
- 35 Paid Leaves per year after completion of one year of service
Key Competencies
- Advanced Excel & MIS Reporting
- Data Analysis
- Report Preparation
- Time Management
- Accuracy & Attention to Detail
- Team Coordination
- Documentation & Record Management
- Problem Solving
- Confidentiality & Data Integrity
Pay: ₹13,000.00 - ₹14,500.00 per month
Benefits:
- Health insurance
- Life insurance
- Paid sick time
- Provident Fund
Work Location: In person
