Job Description
Job Type - Full Time
Location - Bangalore
Roles and Responsibilities
● Coordinate with all the relevant stakeholders from various departments for data
collection at regular intervals
● Produce department wise reports using MS-excel as per regular intervals defined
● Prepare reports using MS-excel as per ad hoc needs of the organization
● Preparing Dashboards using formulas in Excel/VBA & presenting reports
● Prepare macro driven report sheets to fast track report generation
● Present reports to the relevant stake holders
● Provide insights and suggestions based on the reports
● Extensive use of VBA to automate report creation using MS-excel
● Being proactive for continuous improvement in report generation process
● Keep up to date knowledge of all the IT systems used within thr organization
● Ensure the data is up to date in all the systems and fill missing data as and when
identified by coordinating with relevant stake holders
● Perform any other tasks as assigned by the reporting manager
● Multitasking as and when needed
Desired Candidate Profile
● Minimum 1 year of experience with expertise in VBA and Excel automation
● Good communication, problem solving and presentation skills
● MS PowerPoint and MS Word skills
● Ability to quickly grasp knowledge of existing data flows and develop new flows
following agreed organizational standards
● Go getter attitude when it comes to meeting deadlines
● Learning attitude is a must for this role
● The candidate should have knowledge of VBA (Visual Basic Applications).
● The candidate should have knowledge of Advance Excel, Pivot table, V lookup, H lookup,
Google spreadsheet, mail drafting.
● Well Versed in Advanced Microsoft Excel Level Functions & Controls.
● Usage of Algorithm in excel and using formulas on different spreadsheet.
● Formula Specialist (using different formula in single Spreadsheet).
● Mathematical knowledge is an advantage.
● Well versed in all functions & controls of excel (Rank, Index match, Concatenate etc.).
● Must have strong analytical skills in data compilation and insights
💡 Quick Summary
Seeking a career-building opportunity? The MIS Expert position is now open for candidates interested in the MIS Executive sector. This role in Bengaluru offers a professional environment and growth potential.
Requirement Snapshot: Candidates should possess basic communication skills, a proactive attitude, and the ability to work in a team. Experience in MIS Executive is a plus.
