MIS Analyst

As an employee in this role, you will be responsible for performing MIS Reporting Activities in the Finance domain, focusing on calculating and preparing US Sales/Partner Commissions based on revenue received from multiple platforms. Your proficiency in creating Excel/SQL automation for complex revenue-based multi-level sales commissions will be crucial for success in this position. Key Responsibilities: - Calculate and prepare Bi-Monthly/Monthly/Quarterly reports - Create Sales Commission Templates for distribution to various stakeholders - Develop SQL/Excel automation to calculate complex sales commissions - Integrate SQL/Excel tables in PowerBI and publish reports to stakeholders - Handle and resolve internal/external commission queries - Build a tracker for daily reporting to the manager - Build and maintain click-level Standard Operating Procedures (SOPs) Qualifications Required: - Commerce Graduate - Proficient in Accounts Receivables activities - Minimum 3 years of experience in the Finance department - Flexible to work in different shifts, preferably staying within Thane - Experience working with Advanced MS Excel - Proficient with SQL Server Queries/Automation - Exposure to PowerBI & Salesforce Reporting In this role, attention to detail is essential as you will be working with critical Accounts Receivables data and reporting. You must have an inclination towards process improvement and be able to create user-friendly Standard Operating Procedures (SOPs) with version control. Your ability to document and seek approval for enhancements will be key to maintaining efficient operations. Overall, this position offers the opportunity to contribute to the finance department's success by ensuring accurate and timely reporting while continuously seeking ways to enhance processes and procedures.,