Job Description:
• The Data Analyst will support the Monitoring and Evaluation function, projects and operations
team by providing timely and accurate data for the decision-making process.
• As an Data Analyst 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, data analysis, 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 and 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 tools/tech.
• Assist in maintaining databases and performing data audits.
• Develop and trouble shoot advance excel formulas and pivot tables for analytics.
Coordination and Communication:
• Work closely with MIS, operations and field teams to address and resolve data related issues.
• Communicate clearly and effectively with field, operations and M&E team regularly to discuss
challenges faced and solutions provided.
Data Analysis:
• Prepare data analysis of baseline, midline, endline, and pre-post assessment.
• Create an easy-to-understand summary/Dashboard for various teams/projects.

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.