Date posted: November 13, 2026
Open Position: MIS Executive
Location: Mumbai
Employment Type: Full-Time | Permanent
Experience: 3+ Years
Work Mode: Work from Office
Compensation: Based on interview performance
About Bilight Solutions
Bilight Solutions is a rapid-growing Business Intelligence and Data Analytics company specializing in transforming raw data into actionable business insights through data-driven solutions. We deliver innovative BI, analytics, and data solutions that empower organizations to make informed business decisions.
We are looking for a detail-oriented MIS Executive to join our team. The ideal candidate should have strong expertise in Advanced Excel, MIS reporting, data analysis, dashboard preparation, and performance tracking, along with an understanding of banking products and financial processes. The candidate will be responsible for managing performance reports, goal sheets, incentive calculations, and ensuring accurate and timely delivery of business reports.
Key Responsibilities
- Prepare and maintain daily, weekly, and monthly MIS reports for business performance monitoring.
- Collect, consolidate, validate, and analyze data received from multiple business channels and departments.
- Develop and maintain Excel-based dashboards to track targets, achievements, productivity, and business performance.
- Partner with business teams to design, maintain, and roll out goal sheets and incentive programs across different channels.
- Manage Goal Sheet and Performance Bonus Plan (GS/PBP) processes, including calculations, validation, and timely processing.
- Monitor frontline performance, identify exceptions, and provide insights to improve productivity.
- Analyze business performance metrics and recommend improvements to enhance productivity and cost-to-income performance.
- Support the end-to-end Rewards and Recognition (RnR) process, ensuring accuracy, timely execution, and proper documentation.
- Perform data cleaning, formatting, reconciliation, and validation to maintain data accuracy.
- Identify discrepancies, incorrect entries, and incomplete data, and coordinate with respective stakeholders for necessary corrections.
- Prepare analytical reports and dashboards for senior management and cross-functional teams.
- Ensure adherence to reporting timelines, internal policies, and governance requirements.
- Support internal and external audit requirements by maintaining accurate reports and supporting documentation.
- Identify opportunities to standardize and automate recurring MIS, goal sheet, and incentive reporting processes.
Required Skills
- Strong proficiency in Advanced MS Excel.
- Hands-on experience with VLOOKUP, HLOOKUP, XLOOKUP, INDEX-MATCH, IF, SUMIFS, COUNTIFS, and Pivot Tables.
- Experience in preparing MIS reports, Excel dashboards, and management reports.
- Strong understanding of data cleaning, data validation, reconciliation, and formatting.
- Experience in target-versus-achievement reporting and performance tracking.
- Knowledge of incentive calculations, performance bonus plans, and productivity analysis.
- Ability to analyze large datasets and identify data discrepancies.
- Strong analytical, logical, and problem-solving skills.
- Good communication and stakeholder coordination skills.
- Knowledge of Power BI and SQL will be an added advantage.
Experience & Eligibility
- Minimum 3+ years of relevant experience in MIS reporting, performance analytics, banking operations, or business analytics.
- Prior experience in the banking or financial services industry is required.
- Experience handling goal sheets, target tracking, incentive calculations, and performance bonus reports is preferred.
- Hands-on experience in Advanced Excel and dashboard preparation.
- Sound knowledge of banking products and financial processes.
- Experience coordinating with multiple departments and managing time-sensitive reporting requirements.
- Ability to work independently, maintain accuracy, and meet strict deadlines.
Preferred Skills
- Basic knowledge of Power BI and dashboard development.
- Exposure to SQL and data analysis tools.
- Experience in process automation and reporting standardization.
- Understanding of banking performance metrics and cost-to-income analysis.
- Exposure to audit documentation, data governance, and reporting controls.
Benefits
- Provident Fund (PF)
- Paid Sick Leave
- Professional Growth and Learning Opportunities
- Exposure to Business Intelligence and Analytics Projects
- Collaborative and Employee-Friendly Work Environment
Interested candidates can share their updated resumes at: Email:
[email protected]
Work Location: Mumbai (Work from Office)
Work Location: In person
Benefits
- Paid sick time
- Provident Fund
Work Location: In person
📌 MIS Executive - (Banking Domain ) (Mumbai)
🏢 Bilight Solutions
📍 Mumbai