Analytical Excel Specialist

Navkar Business Services; Mumbai City; On-site; INR 450,000 - 650,000; Full time

Job summary

Navkar Business Services in Mumbai is seeking an Analytical Excel Specialist to join our Data Analytics / Finance team. This role focuses on supporting financial analysis, report generation, and data-driven decision-making by leveraging advanced Excel and SQL skills.

The successful candidate will develop and analyze financial reports, create dynamic dashboards, and identify key insights to drive business operations, with strong attention to detail and the ability to work independently under

Qualifications

• Strong proficiency in Microsoft Excel with advanced functions and dashboards.
• Experience in handling large datasets.
• Knowledge of integrating data into Excel reports.
• Familiarity with task automation and data simulations.
• Strong financial acumen including P&L, Balance Sheets, ratios, and cash flow.

Responsibilities

• Create dynamic Excel dashboards to summarize complex data and enhance strategic decisions.
• Provide comprehensive reporting and analytical support to leadership and other business teams.
• Identify problems, recommend improvements, and support implementation of data solutions.
• Perform account reconciliations and necessary process adjustments to maintain data accuracy.
• Train and assist team members in Excel-based reporting tools and techniques.

Skills

Microsoft Excel

PivotTables

INDEX-MATCH

VLOOKUP

SQL

Dynamic dashboards

Financial reporting

Data analysis

Data reconciliation

Automation in Excel

Job description

Analytical Excel Specialist

Department: Data Analytics / Finance

Shift Timing: 9:30 PM 6:30 AM (Monday to Friday)

Weekends Off: Saturday & Sunday

Reports To: Supervisor

Job Summary

We are looking for a detail-oriented and analytical Excel Specialist to join our growing team. This role is critical in supporting financial analysis, report generation, and data-driven decision-making by leveraging advanced Excel and SQL skills. The ideal candidate will be responsible for developing and analyzing financial reports, creating dynamic dashboards, and identifying key insights to support business operations.

Key Responsibilities

• Create dynamic Excel dashboards to summarize complex data and enhance strategic decisions.
• Provide comprehensive reporting and analytical support to leadership and other business teams.
• Identify problems, recommend improvements, and support implementation of data solutions.
• Perform account reconciliations and necessary process adjustments to maintain data accuracy.
• Train and assist team members in Excel-based reporting tools and techniques.

Requirements & Skills

• Strong proficiency in Microsoft Excel (PivotTables, INDEX-MATCH, VLOOKUP, IF, SUM, advanced charts, etc.)
• Working knowledge of integrating data into Excel reports
• Experience managing and analyzing large datasets.
• Familiarity with task automation, data simulations, and advanced formatting techniques.
• Strong financial acumen, including understanding of P&L, Balance Sheets, Ratios, and cash flow analysis
• Attention to detail, high level of accuracy, and ability to work independently under pressure
• Excellent problem-solving, communication, and time-management skills.
• Ability to motivate and support team members and share knowledge.
• Proficiency in other Microsoft Office applications (Word)
• Prior experience in a reporting or financial analyst role is preferred.