- The MIS executive will support the Monitoring and Evaluation function, projects and operations team by providing timely and accurate data for the decision-making process.
- As an MIS Executive with expertise in advanced Excel, macros and Data Analysis, you will be responsible for aggregating and managing data from different value chains, projects and donor wise.
- The role involves working with database management system, performing detailed data quality checks, addressing field level data issues in collaboration with MBT coordinators/ CS/ Assistant Manager, pre-processing and preparing data analysis ready, ensuring the accuracy, consistency, integrity and security of the data.
- Strong analytical, and technical skills are required.
- Take on ad hoc tasks and special assignments delegated by the reporting manager
Roles and responsibilities:
Data Aggregation & Management:
- Aggregate, compile, organise and maintain an up-to-date data into the centralized data repositories, ensuring the timely availability, quality, accuracy, and relevant data across various departments, projects and value chains within the organization.
- Ensure data meets donor guidelines and standards, maintaining consistency and clarity.
- Understand and make yourself aware of all survey questionnaire and Coordinate with projects and operations team to understand data requirements as per the project objectives and deliverables.
- Maintain databases, spreadsheets, and other data repositories.
Quality Control and Data Validation:
- Perform detailed data quality checks (refer to the Data quality, pre-processing, data preparation Standard operating procedure) regularly to ensure consistency, accuracy and reliability of the data.
- Identify and rectify the errors and discrepancies in the data through rigorous validation processes.
- Regular updates, backups, and data quality checks.
Technical Support:
- Automate repetitive data tasks through advanced Excel functionalities, macros and other relevant data processing tech.
- Assist in maintaining databases and performing data audits to Data Analyst and M&E Function.
Tech Support to the team:
- Provide technical support to field team on data collection tools (UGAO APP), and methodologies.
- Provide regular training and orientation to team members on data entry.
Coordination and Communication:
- Work closely with operations and field teams to address and resolve data related issues.
- Connect every week/daily with field team/MBT Coordinators/CS to address the data errors and to obtain up-to-date data on priority.
- Communicate clearly and effectively with field, operations and M&E team regularly to discuss challenges faced and solutions provided.
Skills:
- Strong analytical skills, Problem-solving attitude and the ability to think critically.
- Ability to manage multiple tasks and prioritize effectively.
- Attention to detail and accuracy in data handling.
- Excellent communication and interpersonal skills.
- Ability to work independently and as part of a team.
- Experience with database management and data analysis tools.
- Behavioral Skills Set.
- Should be able to communicate clearly across all the teams throughout the projects.
- Should be a good team player and a quick learner with an aptitude to pick up things fast.
- Must be dynamic with a strong sense of responsibility, accountability and positive attitude.
Qualifications and Experience:
- Bachelor's degree in information technology, Computer Science, or a related field with 2 years of experience. OR
- Proven experience as an Data analyst or similar role.
- Expert proficiency in Advanced Excel, including pivot tables, VLOOKUP, HLOOKUP, and macros. with experience in data management and data cleansing techniques.
Language(s):
- Proficiency in English, and Hindi with excellent written and verbal communication skills.
- Knowledge of at least one regional language is desirable, especially for field visits and local stakeholder engagement.