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 Solid 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

📌 Case Manager (Uttar Pradesh)
🏢 Webnyay
📍 Uttar Pradesh