to join our dispute resolution team. The successful candidate will facilitate the resolution of disputes by managing case files, coordinating with parties and mediators, and ensuring timely progression through the resolution process. This role requires exceptional proficiency in Microsoft Excel, particularly advanced functions like VLOOKUP, to effectively analyze data, track case progress, and generate comprehensive reports.
Key Responsibilities
Data Management & Analysis
Utilize advanced Microsoft Excel functions including VLOOKUP, SUMIFS, COUNTIFS, and pivot tables to manage case data
Create and maintain comprehensive databases tracking case progress, outcomes, and metrics
Generate detailed reports and case summaries for internal review and stakeholders
Perform data analysis to identify trends, patterns, and process improvements
Develop and update spreadsheets for case tracking, resource allocation, and performance monitoring
Client Relations & Communication
Serve as primary point of contact for clients throughout the dispute resolution process
Provide guidance and support to parties involved in disputes
Respond promptly to client inquiries and maintain exceptional client relations
Ensure compliance with dispute resolution policies and procedures
Documentation & Reporting
Prepare comprehensive reports and presentations using Excel's advanced charting and visualization capabilities
Maintain accurate and up-to-date records of all case activities and outcomes
Ensure confidentiality and security of sensitive information throughout the process
Technical Skills - Microsoft Excel Proficiency
Advanced Excel proficiency is essential
, including mastery of:
o
VLOOKUP and XLOOKUP functions
for data retrieval and cross-referencing
o
INDEX MATCH functions
for complex data lookups
o
SUMIFS, COUNTIFS, and AVERAGEIFS
for conditional calculations
o
Pivot Tables
for data analysis and summarization
o
Advanced formulas and functions
including IF statements, nested functions
o
Data validation and conditional formatting
for data integrity
o
Charts and graphs
for data visualization and reporting
Proficiency in other Microsoft Office applications
Core Competencies
Strong analytical and problem-solving abilities
Excellent written and verbal communication skills
Outstanding organizational and time management capabilities
Ability to manage multiple cases simultaneously and meet deadlines
Cultural competency and sensitivity to diverse backgrounds
Strong attention to detail and accuracy in documentation
Ability to handle sensitive information with confidentiality and professionalism
Job Type: Full-time
Pay: ₹10,000.00 - ₹25,000.00 per month
Work Location: In person
Beware of fraud agents! do not pay money to get a job
MNCJobsIndia.com will not be responsible for any payment made to a third-party. All Terms of Use are applicable.