Case Manager

Position Overview

We are seeking a dedicated and detail-oriented Case Manager 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