Impact Insights Analyst – Kenya at African Management Institute (AMI)
Impact Insights Analyst
Team: Impact Intelligence
Location: Nairobi (Hybrid)
Role Overview
AMI supports entrepreneurs and managers across Africa to
grow businesses and create jobs through practical learning and data-driven
solutions. The Impact Insights Analyst will transform analysis-ready data into
clear insights, segmentation, dashboards, and recommendations that guide
program and client decisions.
The role sits within the Impact Intelligence team and works
closely with the Data Warehouse team, which owns data ingestion and modelling.
This role owns the analysis plan, data quality for decision-making, and the
insight layer.
Key Responsibilities
1. Data Readiness & Quality
- Define
validation checks and write QA queries
- Document
assumptions and maintain lightweight data dictionaries for program,
diagnostic, and survey datasets
- Raise,
track, and resolve data quality issues in collaboration with the Data
Warehouse team
2. Analytics & Segmentation
- Lead
descriptive, diagnostic, and basic inferential analyses
- Design
and implement rule-based and clustering segmentation (e.g., k-means)
suited to MSMEs
- Conduct
cohort and retention analysis
- Run
simple regressions and hypothesis tests to inform decision-making
3. Dashboards & Insight Storytelling
- Build
decision-focused dashboards in Metabase
- Produce
concise insight memos and partner-ready slide decks that clearly
articulate:
- What
happened
- Why
it matters
- What
should be done next
4. Stakeholder Enablement
- Run
office hours and short trainings for non-technical colleagues
- Track
adoption of dashboards and insights, and iterate based on feedback
5. Impact, MEL & Learning Support
- Own
analysis plans, question banks, and insight narratives for impact
reporting and learning agendas
- Contribute
insight assets to proposals and client presentations
6. Data Governance & Reproducibility
- Apply
AMI privacy, consent, and data governance standards
- Promote
reproducible analysis using version-controlled notebooks and documented
SQL
Role Boundaries
- The
role does not own ETL pipelines, raw schema design, or
infrastructure
- Works
collaboratively with the Data Warehouse team on these areas
Qualifications & Experience
- 5–7
years of applied analytics experience with program, survey, or enterprise
datasets, preferably in African contexts
- Advanced
SQL experience in production environments (CTEs, window functions, joins,
data quality checks)
- Proficiency
in Python or R for analysis and validation workflows
- Strong
BI experience using Metabase (preferred), Power BI, or Tableau
- Proven
ability to translate analysis into clear, actionable recommendations for
non-technical audiences
- Excellent
written and verbal communication in English
- Comfortable
working independently in a distributed, fast-paced environment
Skills & Attributes
- Advanced
SQL (must-have) with demonstrated BI dashboarding experience
- Strong
data visualization and dashboard design skills
- Analytical
rigor and statistical thinking (hypothesis testing, regression, cohort
analysis)
- Segmentation
design with strong feature selection, validation, and business
interpretability
- Experience
with MSME, learning, MEL, financial inclusion, or market research datasets
- Familiarity
with survey tools (Kobo, SurveyMonkey, Qualtrics)
- Exposure
to dbt and Git for reproducible analytics
- Familiarity
with BigQuery, Postgres, or Snowflake
- Clear
documentation, version control discipline, and transparent assumptions
- Strong
stakeholder empathy and ability to coach and influence decisions
- High
ownership, integrity, and follow-through
Our Values
- Be
the best – Deliver quality work that delights clients
- Own
it – Take accountability and deliver results
- Push
the limits – Question assumptions, experiment, and improve
continuously
- Do
what’s right – Act with integrity and fairness
- Always
care – Prioritise teamwork, kindness, and honest feedback
Work Environment & Benefits
- Brand
new offices in Westlands, Nairobi
- Hybrid
working model
- Monthly
team social events and annual offsite
- Regular
learning and coaching opportunities