Data Analyst

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 focuses on maintaining data integrations, building reliable data connections, and developing Excel-based reports for internal and partner use.

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 as they arise.
• Document database structures, integrations, data flows and system changes to keep the integration clear and maintainable over time.
• Recommend and implement automation solutions that reduce manual data transfer and the risk of error.
• Establish and maintain a reliable connection between CommCare and Excel through APIs and ETL processes, ensuring CommCare data can be accessed and refreshed directly within Excel.
• Monitor the CommCare-to-Excel data flow on an ongoing basis and troubleshoot synchronisation or data-transfer issues as they arise.
• 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 so that reports remain live and up to date.
• Prepare regular reports on client reach, services delivered, results and progress against targets.
• Prepare datasets and tables to support monthly, quarterly, final and ad hoc reporting requirements.
• Organise reports so that partners and internal teams can use them effectively, presenting information such as indicator progress and registrations by region and by partner.
• Translate complex data into clear findings and recommendations for non-technical stakeholders.

Requirements

• 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).
• 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.
• Professional working proficiency in English and Polish; Ukrainian will be an advantage.

Skills

• Data Analysis
• Excel Reporting
• Dashboard Development
• Power Query
• Pivot Tables
• Formulas
• CommCare
• Digital Data Collection
• Case management systems
• KoboToolbox
• Data Integration
• Workflow Automation
• Data Consolidation
• Data Validation
• Data Presentation
• Report Writing

Languages

English, Polish, Ukrainian