JohnMartin

Analytical and business-intelligence support across multiple client projects, contributing to the design and delivery of enterprise-grade Power BI solutions for data-driven decision-making — working end-to-end with technical teams, product stakeholders, and project managers.

• Designed and built interactive dashboards and analytical reports across operational, financial, and performance monitoring for diverse client use cases.
• Contributed to star-schema data models and semantic-layer design, optimising dimensional structures for scalability, performance, and analytical clarity.
• Supported ETL pipelines integrating SaaS platforms, APIs, financial systems, and SharePoint into centralised SQL data environments.
• Developed DAX measures, calculated columns, and time-intelligence logic for KPI frameworks and complex business rules.
• Implemented Row-Level Security for secure, role-based, multi-user access across dashboards and reports.
• Tuned reports and models to improve refresh efficiency and end-user performance.
• Automated management and executive reporting, reducing manual effort and improving consistency.

Led country-level data analytics, information management, and BI across a EUR 20 million portfolio spanning 7 operational areas — designing centralised data architectures, Power BI dashboards, and automated reporting for senior management, programme teams, and external stakeholders.

• Designed interactive Power BI dashboards for complaint and feedback mechanism (CFM) analytics — feedback volumes, complaint categorisation, and response timelines — used as the primary analytical tools for senior management and donor reporting.
• Built end-to-end ETL flows integrating 6+ data sources (mobile collection, WhatsApp, email, helplines, community helpdesks, and online platforms) into a unified centralised database.
• Modelled a national Household Vulnerability Assessment (geographic, sectoral, temporal, and vulnerability-scoring dimensions) enabling multi-dimensional analysis across 12,000+ household records via star-schema fact and dimension tables.
• Implemented Row-Level Security with area-specific isolation (Darfur, South Kordofan, White Nile, Gedaref) and sensitive complaint-data protection through dynamic filters and user-role mapping.
• Built Indicator Performance Tracking Tables (IPTT) with automated verification for monthly reporting cycles — performance scoring, variance analysis, and target-vs-actual tracking across area offices.
• Provided technical support to the Sudan Protection Cluster, building a cluster dashboard aggregating data from 52 NGOs for inter-agency coordination and advocacy.
• Directly managed 14+ data and analytics team members across 4 geographic areas, with role-specific capacity building.

Country-level leadership of data analytics and information management during emergency response — a EUR 14 million portfolio in Ukraine and a EUR 7 million multi-sector portfolio in Yemen — building data collection, analysis, and reporting infrastructure from scratch.

• Digitalised the Health Information System (HIS) end-to-end, from health facilities to centralised databases, with automated pipelines for real-time health KPIs.
• Built an accountability data system from scratch — a Feedback and Complaint Response Mechanism (FCRM) architecture with referral pathways, integrated feedback channels, and dashboards for real-time case tracking.
• Automated consolidation of activity progress from decentralised field bases, replacing manual reporting.
• Designed ETL pipelines connecting field tools to centralised databases across regional hubs (Kharkiv, Dnipro, Chernivtsi).
• Delivered capacity building for data teams on digital collection, database management, analytical tools, and reporting standards.

Led mission-wide digital transformation across a EUR 11 million multi-sector portfolio, replacing paper-based processes with centralised data architectures.

• Built four sector-specific digital systems from scratch — Health (HIS), Nutrition (NIS), MHPSS, and Protection Household Assessment (PHA).
• Designed ETL pipelines on KoboToolbox and CommCare for field extraction, with cleansing, validation, normalisation, and automated weekly/monthly outputs.
• Modelled multi-dimensional data across health, nutrition, protection, and psychosocial sectors for near real-time monitoring of critical cases (SAM/MAM nutrition, protection referrals).
• Redesigned the complaint and feedback mechanism (CFM) data architecture with escalation pathways and sensitive-complaint handling.
• Led a team of 8+ across 2 locations; the HIS architecture was subsequently adopted by PUI missions in Afghanistan and Libya.

Progressive MEAL and information-management roles across Iraq’s humanitarian sector — building digital data-collection systems, health information systems, and monitoring databases in conflict-affected settings.

• MEAL & IM Consultant — Kvinna Till Kvinna (KTK), Iraq (Dec 2019 – Feb 2020): monitoring frameworks, data-collection systems, and analytical reporting tools across 6 operational locations.
• Country M&E Coordinator — Norwegian Refugee Council (NRC), Iraq (Mar 2019 – Jun 2019): country-level M&E, data-collection systems, indicator performance tracking, and analytical reporting.
• MEAL Manager — Première Urgence Internationale (PUI), Iraq (Mar 2018 – Aug 2018): digital data-collection tools, health information systems, and monitoring databases; pioneered the HIS digital architecture later adopted across PUI missions in Afghanistan and Libya.
• AMEA Officer — Première Urgence Internationale (PUI), Iraq (May 2017 – Feb 2018): accountability and monitoring data systems, feedback-mechanism databases, field data collection, and analytical reporting.
• Data Operator / Database Manager — Médecins Sans Frontières (MSF), Iraq (Jan 2014 – Jan 2017): health data systems, patient records, epidemiological data entry, database management, and statistical reporting in conflict-affected areas.