AMI helps entrepreneurs and managers across Africa grow businesses and create jobs through practical learning and data-driven solutions. We are hiring a senior-leaning Impact Insights Analyst to sit in the Impact Intelligence team. You will turn analysis-ready data into clear insights, segmentations, dashboards, and recommendations that guide program and client decisions. You’ll partner closely with our Data Warehouse team, which owns ingestion and data modelling; you own the analysis plan, data quality for decision-making, and the insight layer.

• Data readiness and quality for analysis – Define validation checks, write QA queries, document assumptions, and raise/track fixes with the warehouse team. Maintain lightweight data dictionaries for programme, diagnostic and survey datasets.

• Analytics and segmentation – Lead descriptive, diagnostic and basic inferential analyses. Build rule-based and clustering segmentations (e.g., k-means) suited to MSMEs. Run cohort/retention analysis and simple regressions to test hypotheses.

• Dashboards and storytelling – Build decision-focused dashboards in Metabase. Produce short memos and partner-ready slides that move from “what” to “so what” to “now what.”

• Stakeholder enablement – Run office hours and quick trainings for non-technical colleagues. Track adoption of your outputs and iterate based on feedback.

• Impact and MEL support – Own analysis plans, question banks and insight narratives for impact reporting and learning agendas; contribute insight assets to proposals and client presentations.

• Data governance in practice – Apply AMI privacy and consent standards. Promote reproducible analysis with versioned notebooks and documented SQL.

• Boundary of role – This role does not own ETL pipelines, raw schema design or infrastructure; you collaborate with the warehouse team on those.

Requirements

Qualifications & Experience

• 5 to 7 years applied analytics experience with programme, survey or enterprise datasets, ideally across African contexts.

• Advanced SQL in production settings including joins, window functions, CTEs and quality checks.

• Proficiency in Python or R for analysis and validation workflows.

• Strong BI skills in Metabase (preferred), Power BI or Tableau with a portfolio of decision-driving dashboards.

• Proven track record translating analysis into clear recommendations for non-technical audiences.

• Excellent written and verbal communication in English; comfortable working independently in a distributed, fast-paced team.

Skills & Attributes

• Advanced SQL skills (must-have). Demonstrable advanced SQL (window functions/CTEs) and BI dashboarding experience.
  

• Strong data visualization skills (Metabase, Tableau, Power BI, or similar).
  

• Analytical rigor and statistical thinking — hypothesis testing, basic regression, cohort/retention logic.
  

• Segmentation design — sound feature selection, validation and business interpretability.
  

• Experience with MSME or learning datasets, MEL frameworks, financial inclusion or market research.
  

• Survey tools familiarity — Kobo, SurveyMonkey, Qualtrics.
  

• Exposure to dbt and Git for reproducible analytics; familiarity with BigQuery/Postgres/Snowflake.
  

• Visualization craft — crisp layouts, good chart choices, and a bias to actionable insights.
  

• Documentation and reproducibility — clean SQL, version control habits, clear assumptions.
  

• Stakeholder empathy — ability to coach, simplify and influence decisions.
  

• High ownership, integrity, and follow-through.
  

Benefits

Why join us

• A high-impact, diverse and ambitious team with common values:
  

• Be the best: We work really hard, are proud of what we do, and love delighting our clients with quality.
  

• Own it: We step up to the task, never pass the buck and hold ourselves accountable for delivering results.
  

• Push the limits: We ask why, embrace failure and try new things. We never settle.
  

• Do what’s right: We act with integrity, confront dishonesty, treat people fairly and strive to contribute to the greater good
  

• Always care: We don’t have ego – it’s always ‘team before me’. We are kind, we celebrate each other’s success, and we care enough to give honest feedback.
  

• A dynamic office & team life:
  

• Brand new offices in Kigali, Rwanda
  

• Monthly team social events and yearly offsite
  

• Regular learning and coaching opportunities
  

• A hybrid working model.