Asistente de Proyecto (M&E and Reporting)

The Project Assistant (M&E and Reporting) supports the implementation of the Unified Monitoring Strategy of the Mission by developing monitoring and data visualization tools, supporting data cleaning and quality processes, and assisting in the preparation of narrative and quantitative reports. The role involves coordination with program teams and contributes to accountability and strategic decision-making.

Responsibilities

• Support the implementation of the Mission's Unified Monitoring Strategy in the project, aligning it with IOM and donor monitoring and reporting requirements.
• Assist in designing, developing, and managing data collection tools and digital forms, as well as data collection for project indicators reporting.
• Perform cleaning, normalization, and basic processing of databases to ensure project information is complete, reliable, and organized, following IOM and donor criteria.
• Design, develop, and manage Power BI dashboards and reports, organizing data flows reflecting the project's strategic results.
• Support consolidation of inputs and preparation of narrative project reports, observing donor and IOM requirements.
• Monitor the administrative schedule of technical reports, sending reminders about submission deadlines on relevant platforms.
• Support logistics and preparation of materials for training on monitoring methodologies, Kobo use, and results-based management.
• Organize and maintain updated digital archives of verification media and databases, ensuring the knowledge repository is orderly and secure.
• Extract basic statistics and historical data from monitoring systems for informed decision-making, dissemination of achievements and results, and facilitating new proposal development.
• Assist and ensure project activities execution, guaranteeing compliance with schedules and objectives.
• Manage data collection, processing, and analysis, generating structured and timely information on action lines, management indicators, and project results.
• Develop and consolidate progress reports, official communications, and technical documents, ensuring high standards of quality, clarity, and timeliness.
• Plan logistics for meetings, workshops, and training sessions, ensuring proper execution and achievement of objectives.
• Manage project information systems, files, and databases, ensuring integrity, updating, accessibility, and traceability.
• Perform other responsibilities assigned by the supervisor.

Requirements

• Bachiller with five years of relevant experience; or a Bachelor's degree in Political or Social Sciences, International Relations, Development Studies, Economics, Engineering, Law or related fields from an accredited academic institution with three years of relevant professional experience.
• Experience in developing, coding, and deploying digital data collection tools using KoboToolbox.
• Experience in consolidating, cleaning, transforming, and validating consistency and integrity of relational and non-relational databases using scripts in Stata, R, Python or Power Query.
• Experience in building, updating, and maintaining interactive dashboards in Power BI (star/snowflake data modeling, advanced DAX expressions, and data flow optimization).
• Experience providing technical support for data structuring for monitoring, tracking, and evaluation (M&E) of projects.
• Operational capacity to execute ETL processes and automate reporting independently.
• Ability to communicate analytical findings, complex metrics, and technical procedures to non-specialized audiences and provide end-user assistance.
• Efficient technical response capacity to simultaneous support and information processing requests under tight schedules.
• Knowledge of confidentiality, anonymization, and information security principles to comply with IOM's personal data protection policy.
• Attention to detail, analytical rigor in detecting data anomalies, and methodical documentation of processes and code instructions.
• Fluency in Spanish (oral and written) is required.
• Advanced level of English (oral and written) is desirable.

Skills

• KoboToolbox
• Digital Data Collection
• Data Consolidation
• Data Cleaning
• Data Transformation
• Data Validation
• Stata scripting
• R Programming
• Python Scripting
• Power Query
• Power BI
• Data Modeling
• DAX Expressions
• Data Flow Optimization
• Technical support for M&E
• ETL
• Automated Reporting Tools
• Data Visualization
• Data Security
• Data anonymization
• Report Writing

Languages

Spanish, English