Data Analyst

Overview

The Data Analyst supports IRC Poland's MEAL / Programmes function by connecting the organisation's data systems and turning them into clear, usable reports. The role is focused on setting up and maintaining data integrations in OpenFn, building a reliable connection between CommCare and Excel, and developing Excel-based reports.

Key Responsibilities

• Maintain integrations between KoboToolbox, CommCare and other programme databases through OpenFn, APIs and ETL processes.
• Monitor automated data flows and troubleshoot synchronisation, duplication and data-transfer issues.
• Document database structures, integrations, data flows and system changes.
• Recommend and implement automation solutions.
• Establish and maintain a reliable connection between CommCare and Excel through APIs and ETL processes.
• Monitor the CommCare-to-Excel data flow and troubleshoot synchronisation or data-transfer issues.
• Ensure the connection continues to function accurately as CommCare forms, structures and reporting requirements evolve.
• Develop and maintain dashboards and reporting tools in Excel, combining data from CommCare and KoboToolbox.
• Prepare regular reports on client reach, services delivered, results and progress against targets.
• Prepare datasets and tables to support reporting requirements.
• Organise reports so that partners and internal teams can use them effectively.
• Translate complex data into clear findings and recommendations for non-technical stakeholders.

Required Experience

• Practical experience with CommCare, or with a comparable digital data-collection or case-management platform.
• Familiarity with KoboToolbox, or the ability to learn it quickly.
• Experience with OpenFn, or a comparable data-integration / workflow-automation tool (e.g. Zapier, Make, Talend), is an advantage but not required.
• Strong attention to detail when consolidating and checking data from multiple sources.
• Ability to organise and present data clearly for different audiences, including non-technical colleagues and partners.

Qualifications

• University degree in data analysis, computer science, statistics, or a related field (or equivalent practical experience).
• Advanced proficiency in Excel, including building reports and dashboards that pull in and organise data from external sources (e.g. Power Query, pivot tables, formulas).

Other Details