SME MIS

Tata Play Fiber; Mumbai; On-site; INR 600,000 - 900,000; Full time

Job summary

Tata Play Fiber in Bangalore, India is seeking an MIS Analyst to join the Sales team. The role focuses on designing, developing, implementing and supporting critical BI reports, Excel reports, and other tools while collaborating with cross-functional teams to deliver accurate insights.

You will automate reports, maintain dashboards, and provide analytical support to management. Strong data modelling, validation and problem-solving skills with MS Excel, VBA macros and MS Access are essential for

Qualifications

• Proficient with MS Office (Excel, Access) and able to design reports and tools with VBA macros.
• Strong data analysis and reporting skills for BI and Excel reports.
• Good interpersonal and written communication, able to work with cross-functional teams.
• Knowledge of relational data modelling concepts (logical/physical).
• Understanding of data integration issues, validation, and data cleaning.

Responsibilities

• Design, develop, implement and support BI reports and Excel reports.
• Automate reports to reduce manual effort and improve consistency.
• Develop MIS documentation for smooth operation and maintenance.
• Provide recommendations to enhance MIS and reporting efficiency.
• Publish weekly and monthly Sales dashboards to management.
• Support cross-functional meetings to resolve recurring customer issues.
• Provide technical solutions to customer problems and analyse business information for process improvements.

Skills

MS Office Applications

Excel

VBA Macros

Data Analysis

Communication Skills

Cross-functional Collaboration

Tools

MS Access

SQL

Job description

Job Summary

As an integral member of Sales team, the MIS Analyst will be responsible for the design, development, implementation and support of critical Business Intelligence (BI) reports, Excel Reports, and other tools working with cross-functional teams.

Responsibilities

• Maintain contractual staffs productivity tracker
• Maintain count of hiring, salary details and joining details of contractual staff
• Automate reports to reduce man-hours spent on existing reports
• Develop MIS documentation to allow for smooth operations and easy system maintenance
• Provide recommendations to update current MIS to improve reporting efficiency and consistency
• Perform data analysis for generating reports on periodic basis
• Develop MIS system for customer management and internal communication
• Provide strong reporting and analytical information support to management team
• Generate both periodic and ad hoc reports as needed
• Understand customer problems and provide appropriate technical solutions
• Analyse business information to identify process improvements for increasing business efficiency and effectiveness
• Participate in cross-functional meetings to resolve recurring customer issues
• Provide customer support and assistance in issue troubleshooting and resolution
• Prepare and publish weekly and monthly Sales dashboards to management
• Update business on new changes in reports as and when introduced
• Regularly follow-up with business on report completeness accuracy

Requirements

• Ability to function effectively in an extremely dynamic industry
• Good interpersonal and communication skills, both verbal and written
• Proficient with MS Office Applications like Excel, Access etc. and being able to design reports and tools with VBA macros
• Knowledge of logical and physical data modelling concepts (relational and dimensional)
• Understanding of data integration issues (validation and cleaning), familiarity with complex data and structures
• Excellent interpersonal (verbal and written) communication skills are required to support working in project environments that includes internal, external and customer teams
• Requires strong analytical, conceptual and problem-solving abilities
• Ability to manage multiple priorities, and assess and adjust quickly to changing priorities

Location: Bangalore, Karnataka, India

Job Type: Full-time