Management Information System Executive
- Industry Other
- Category IT&Telecommunication
- Location Kathmandu, Nepal
- Expiry date Jan 19, 2038 (4555 days left)
Job Description
Job Title: MIS Executive
Job Summary:
We are seeking a highly proficient and detail-oriented MIS Executive with advanced Excel skills to join our team. The ideal candidate will be responsible for collecting, analyzing, and interpreting data to generate accurate and insightful MIS reports that support informed decision-making. This role requires a strong understanding of business processes, excellent analytical abilities, and mastery of Microsoft Excel.
Key Requirements and Qualifications:
- Bachelor's degree in Business Administration (BBA) or Bachelor of Business Studies (BBS) is mandatory.
- 2-3 years of proven experience in MIS reporting
- Working knowledge and experience with ERP software (specify the ERP system if possible).
- Demonstrable expertise in Microsoft Excel, including advanced formulas (e.g., VLOOKUP, INDEX/MATCH, SUMIFS, COUNTIFS), pivot tables, charting.
- Data validation and cleaning techniques.
- Conditional formatting and data visualization.
- Excellent attention to detail and accuracy.
- Ability to work independently and as part of a team.
Key Responsibilities:
- Gather data from various sources, including databases, spreadsheets, and other internal systems.
- Ensure data accuracy, consistency, and integrity through validation and cleaning processes.
- Maintain organized data repositories and ensure data security.
- Design, develop, and generate regular and ad-hoc MIS reports using advanced Excel functionalities (e.g., pivot tables, VLOOKUP, macros, charts, conditional formatting).
- Analyze data to identify trends, patterns, and anomalies.
- Interpret data and provide meaningful insights to management.
- Create dashboards and visualizations to effectively communicate findings.
- Utilize ERP software to extract data, generate reports, and support business processes.
- Understand the data structure and functionality of the ERP system.
- Collaborate with IT or ERP support teams to resolve system issues or data discrepancies.
- Identify opportunities for process improvement based on data analysis.
- Collaborate with other departments to implement changes and optimize workflows.
- Document reporting processes and methodologies.
- Train junior staff or other team members on data management and reporting tools.
- Work closely with various departments to understand their data requirements.
- Communicate effectively with both technical and non-technical stakeholders.
If you have any queries please contact in [email protected]
