Alternate Channel - Mid Office - Sales - South
Kotak Securities · Remote
Source and collection record
Last observed by our collector: . This is not a manual review or a confirmation from the employer.
Job type and experience labels are automated discovery categories. The employer determines eligibility. Original experience wording was not retained separately; check the current employer page.
Your application evidence checklist
Mark the statements you can support after reading the employer source. This checklist stays on this page; it does not score your eligibility or submit an application.
0 of 2 checks marked. Keep unresolved requirements as questions for the employer.
Collected role description
<p class="elementtoproof" style="background:#FAFAFA;"><b><span style="color:#242424;">Key Responsibilities</span></b></p><p></p><p class="elementtoproof" style="background:#FAFAFA;"><b><span style="color:#242424;">MIS Reporting & Data Management</span></b></p><p></p><ul style="margin-top:0cm;" type="disc"> <li class="MsoNormal" style="color:#242424;background:#FAFAFA;"><span>Prepare daily, weekly, and monthly MIS reports for management review.</span><span style="font-size:10pt;"></span><p></p></li> <li class="MsoNormal" style="color:#242424;background:#FAFAFA;"><span>Consolidate data from multiple sources and maintain data integrity.</span><span style="font-size:10pt;"></span><p></p></li> <li class="MsoNormal" style="color:#242424;background:#FAFAFA;"><span>Ensure timely delivery of business reports with high accuracy.</span><span style="font-size:10pt;"></span><p></p></li> <li class="MsoNormal" style="color:#242424;background:#FAFAFA;"><span>Develop and maintain reporting templates and databases.</span><span style="font-size:10pt;"></span><p></p></li> </ul><p class="elementtoproof" style="background:#FAFAFA;"><b><span style="color:#242424;">Dashboard & Analytics</span></b></p><p></p><ul style="margin-top:0cm;" type="disc"> <li class="MsoNormal" style="color:#242424;background:#FAFAFA;"><span>Create and manage dashboards using Excel, Power BI, or other reporting tools.</span><span style="font-size:10pt;"></span><p></p></li> <li class="MsoNormal" style="color:#242424;background:#FAFAFA;"><span>Analyse operational and customer service performance metrics.</span><span style="font-size:10pt;"></span><p></p></li> <li class="MsoNormal" style="color:#242424;background:#FAFAFA;"><span>Generate insights and recommendations based on data trends.</span><span style="font-size:10pt;"></span><p></p></li> <li class="MsoNormal" style="color:#242424;background:#FAFAFA;"><span>Support leadership with ad-hoc analysis and reporting requirements.</span><span style="font-size:10pt;"></span><p></p></li> </ul><p class="elementtoproof" style="background:#FAFAFA;"><b><span style="color:#242424;">Process Automation</span></b></p><p></p><ul style="margin-top:0cm;" type="disc"> <li class="MsoNormal" style="color:#242424;background:#FAFAFA;"><span>Identify opportunities to automate manual reporting processes.</span><span style="font-size:10pt;"></span><p></p></li> <li class="MsoNormal" style="color:#242424;background:#FAFAFA;"><span>Develop automated reports using Excel formulas, Power Query, Power Pivot, VBA, Python or Power Automate.</span><span style="font-size:10pt;"></span><p></p></li> <li class="MsoNormal" style="color:#242424;background:#FAFAFA;"><span>Improve reporting efficiency and reduce manual intervention.</span><span style="font-size:10pt;"></span><p></p></li> </ul><p class="elementtoproof" style="background:#FAFAFA;"><b><span style="color:#242424;">Performance Tracking</span></b></p><p></p><ul style="margin-top:0cm;" type="disc"> <li class="MsoNormal" style="color:#242424;background:#FAFAFA;"><span>Track KPIs and business performance indicators.</span><span style="font-size:10pt;"></span><p></p></li> <li class="MsoNormal" style="color:#242424;background:#FAFAFA;"><span>Monitor SLA adherence, productivity, quality scores, customer complaints, and other operational metrics.</span><span style="font-size:10pt;"></span><p></p></li> <li class="MsoNormal" style="color:#242424;background:#FAFAFA;"><span>Highlight performance gaps and areas requiring management attention.</span><span style="font-size:10pt;"></span><p></p></li> </ul><p class="elementtoproof" style="background:#FAFAFA;"><b><span style="color:#242424;">Data Quality & Governance</span></b></p><p></p><ul style="margin-top:0cm;" type="disc"> <li class="MsoNormal" style="color:#242424;background:#FAFAFA;"><span>Validate data accuracy and consistency across reports.</span><span style="font-size:10pt;"></span><p></p></li> <li class="MsoNormal" style="color:#242424;background:#FAFAFA;"><span>Maintain proper documentation and version control of reports.</span><span style="font-size:10pt;"></span><p></p></li> <li class="MsoNormal" style="color:#242424;background:#FAFAFA;"><span>Ensure confidentiality of business data.</span><span style="font-size:10pt;"></span><p></p></li> </ul><p class="elementtoproof" style="background:#FAFAFA;"><span style="color:#242424;"> </span></p><p></p><div class="MsoNormal" align="center" style="text-align:center;background:#FAFAFA;"><span style="color:#000000;"> </span></div><p class="elementtoproof" style="background:#FAFAFA;"><b><span style="color:#242424;">Key Performance Indicators (KPIs)</span></b></p><p></p><ul style="margin-top:0cm;" type="disc"> <li class="MsoNormal" style="color:#242424;background:#FAFAFA;"><span>Report Accuracy</span><span style="font-size:10pt;"></span><p></p></li> <li class="MsoNormal" style="color:#242424;background:#FAFAFA;"><span>On-Time Report Submission</span><span style="font-size:10pt;"></span><p></p></li> <li class="MsoNormal" style="color:#242424;background:#FAFAFA;"><span>Dashboard Utilization</span><span style="font-size:10pt;"></span><p></p></li> <li class="MsoNormal" style="color:#242424;background:#FAFAFA;"><span>Data Quality Score</span><span style="font-size:10pt;"></span><p></p></li> <li class="MsoNormal" style="color:#242424;background:#FAFAFA;"><span>Automation Initiatives Implemented</span><span style="font-size:10pt;"></span><p></p></li> <li class="MsoNormal" style="color:#242424;background:#FAFAFA;"><span>Turnaround Time for Ad-hoc Requests</span><span style="font-size:10pt;"></span><p></p></li> <li class="MsoNormal" style="color:#242424;background:#FAFAFA;"><span>Reporting Process Efficiency</span><span style="font-size:10pt;"></span><p></p></li> </ul><div class="MsoNormal" align="center" style="text-align:center;background:#FAFAFA;"><span style="color:#000000;"> </span></div><p class="elementtoproof" style="background:#FAFAFA;"><b><span style="color:#242424;">Qualifications</span></b></p><p></p><ul style="margin-top:0cm;" type="disc"> <li class="MsoNormal" style="color:#242424;background:#FAFAFA;"><span>Bachelor's Degree in related field.</span><span style="font-size:10pt;"></span><p></p></li> <li class="MsoNormal" style="color:#242424;background:#FAFAFA;"><span>1-4 years of experience in MIS Reporting, Data Analysis, or Business Reporting.</span><span style="font-size:10pt;"></span><p></p></li> <li class="MsoNormal" style="color:#242424;background:#FAFAFA;"><span>Experience in customer service, operations, or BPO environments will be an added advantage.</span><span style="font-size:10pt;"></span><p></p></li> </ul><div class="MsoNormal" align="center" style="text-align:center;background:#FAFAFA;"><span style="color:#000000;"> </span></div><p class="elementtoproof" style="background:#FAFAFA;"><b><span style="color:#242424;">Technical Skills</span></b></p><p></p><p class="elementtoproof" style="background:#FAFAFA;"><b><span style="color:#242424;">Mandatory</span></b></p><p></p><ul style="margin-top:0cm;" type="disc"> <li class="MsoNormal" style="color:#242424;background:#FAFAFA;"><span>Advanced Microsoft Excel</span><span style="font-size:10pt;"></span><p></p><ul style="margin-top:0cm;" type="circle"> <li class="MsoNormal" style="color:#242424;background:#FAFAFA;"><span>Pivot Tables</span><span style="font-size:10pt;"></span><p></p></li> <li class="MsoNormal" style="color:#242424;background:#FAFAFA;"><span>XLOOKUP/VLOOKUP</span><span style="font-size:10pt;"></span><p></p></li> <li class="MsoNormal" style="color:#242424;background:#FAFAFA;"><span>INDEX-MATCH</span><span style="font-size:10pt;"></span><p></p></li> <li class="MsoNormal" style="color:#242424;background:#FAFAFA;"><span>IF, SUMIFS, COUNTIFS</span><span style="font-size:10pt;"></span><p></p></li> <li class="MsoNormal" style="color:#242424;background:#FAFAFA;"><span>Data Validation</span><span style="font-size:10pt;"></span><p></p></li> <li class="MsoNormal" style="color:#242424;background:#FAFAFA;"><span>Conditional Formatting</span><span style="font-size:10pt;"></span><p></p></li> <li class="MsoNormal" style="color:#242424;background:#FAFAFA;"><span>Dashboard Creation</span><span style="font-size:10pt;"></span><p></p></li> </ul></li> </ul><p class="elementtoproof" style="background:#FAFAFA;"><b><span style="color:#242424;">Preferred</span></b></p><p></p><ul style="margin-top:0cm;" type="disc"> <li class="MsoNormal" style="color:#242424;background:#FAFAFA;"><span>Power BI</span><span style="font-size:10pt;"></span><p></p></li> <li class="MsoNormal" style="color:#242424;background:#FAFAFA;"><span>Power Query</span><span style="font-size:10pt;"></span><p></p></li> <li class="MsoNormal" style="color:#242424;background:#FAFAFA;"><span>Power Pivot</span><span style="font-size:10pt;"></span><p></p></li> <li class="MsoNormal" style="color:#242424;background:#FAFAFA;"><span>Power Automate</span><span style="font-size:10pt;"></span><p></p></li> <li class="MsoNormal" style="color:#242424;background:#FAFAFA;"><span>Power Apps</span><span style="font-size:10pt;"></span><p></p></li> <li class="MsoNormal" style="color:#242424;background:#FAFAFA;"><span>Python</span><span style="font-size:10pt;"></span><p></p></li> <li class="MsoNormal" style="color:#242424;background:#FAFAFA;"><span>VBA/Macros</span><span style="font-size:10pt;"></span><p></p></li> <li class="MsoNormal" style="color:#242424;background:#FAFAFA;"><span>SQL Basics</span><span style="font-size:10pt;"></span><p></p></li> <li class="MsoNormal" style="color:#242424;background:#FAFAFA;"><span>Microsoft Office Suite</span><span style="font-size:10pt;"></span><p></p></li> </ul><div class="MsoNormal" align="center" style="text-align:center;background:#FAFAFA;"><span style="color:#000000;"> </span></div><p class="elementtoproof" style="background:#FAFAFA;"><b><span style="color:#242424;">Behavioural Competencies</span></b></p><p></p><ul style="margin-top:0cm;" type="disc"> <li class="MsoNormal" style="color:#242424;background:#FAFAFA;"><span>Strong analytical and problem-solving skills.</span><span style="font-size:10pt;"></span><p></p></li> <li class="MsoNormal" style="color:#242424;background:#FAFAFA;"><span>High attention to detail and accuracy.</span><span style="font-size:10pt;"></span><p></p></li> <li class="MsoNormal" style="color:#242424;background:#FAFAFA;"><span>Excellent organizational skills.</span><span style="font-size:10pt;"></span><p></p></li> <li class="MsoNormal" style="color:#242424;background:#FAFAFA;"><span>Ability to manage multiple reports simultaneously.</span><span style="font-size:10pt;"></span><p></p></li> <li class="MsoNormal" style="color:#242424;background:#FAFAFA;"><span>Strong communication and stakeholder management skills.</span><span style="font-size:10pt;"></span><p></p></li> <li class="MsoNormal" style="color:#242424;background:#FAFAFA;"><span>Proactive mindset with continuous improvement orientation</span><span style="font-size:10pt;"></span><p></p></li> </ul><p> </p><p class="MsoNormal"><span style="color:#000000;"> </span></p>
Collected experience requirement
1-4 years