Data Analyst

Posted Yesterday
Be an Early Applicant
Nairobi, KEN
In-Office
Mid level
Edtech • Professional Services • Social Impact
The Role
Build and maintain Metabase dashboards and recurring reports using SQL; respond to data requests; perform descriptive analysis; check data quality; document reporting logic; and support programme, client, and funder reporting. The role requires clear communication, accurate analysis, stakeholder support, and secure handling of participant and client data.
Summary Generated by Built In

AMI is looking for an ambitious and talented Data Analyst to help AMI’s programme, commercial and operational teams get accurate, timely data: preparing and checking data, building and maintaining dashboards and reports, responding to day-to-day data requests, and supporting deeper analysis.

Demand for reporting is growing, and much of it is still handled through manual extracts and spreadsheets. You will work with clean, modelled data in AMI’s warehouse. You will be expected to understand what the data means, check your numbers before sharing them, and flag anything that looks wrong. This is a hands-on role with room to grow your technical and analytical skills within a supportive team.

Key Responsibilities

Reporting and dashboards

  • Build, update and maintain dashboards and recurring reports in Metabase, using SQL on the data warehouse.

  • Produce regular programme, cohort and operational reports to agreed schedules.

  • Help move manual, spreadsheet-based reporting onto automated dashboards.

Data requests and analysis

  • Respond to data and reporting requests from programme and business teams, clarifying what is needed before starting.

  • Write SQL queries to pull, combine and summarise data from the data warehouse.

  • Carry out descriptive analysis of participant, cohort, survey and engagement data, and summarise findings clearly.

  • Support the Senior Analytics Engineer on deeper analysis, client reports and funder reporting.

Data quality

  • Check data for completeness, accuracy and consistency before it is used in reports.

  • Flag anomalies and data issues to the Senior Analytics Engineer and Senior Data Engineer, with clear examples.

  • Follow agreed metric definitions so numbers are consistent across reports.

  • Handle participant and client data securely and in line with AMI policy, donor requirements and applicable data protection law (e.g. Kenya’s Data Protection Act).

Documentation and support

  • Document queries, dashboards and report logic so others can understand and reuse them.

  • Help colleagues use dashboards through short guides and walkthroughs.

  • Keep stakeholders updated on the progress of their requests and deliver to agreed timelines.



Requirements

Education, Skills and Experience.

  • Bachelor’s degree in Statistics, Economics, Mathematics, Data Science, Computer Science, Business Analytics or a related field.

  • 2 to 4 years of experience in data analysis, business intelligence or reporting.

  • Experience building dashboards or regular reports used by non-technical teams.

  • Experience handling several requests at once and prioritising with guidance.

  • Good SQL skills, including joins, aggregations, filtering and window functions, with a willingness to grow into more advanced queries.

  • Experience with at least one BI tool (Metabase, Power BI, Tableau or Looker).

  • Understanding of descriptive statistics and how to present data accurately.

  • High attention to detail and a habit of checking numbers before sharing them.

  • Curiosity about the data: what it means, where it comes from and why it changes.

  • Clear written and verbal communication, including explaining findings in plain language.

  • Proactive and reliable: asks questions early, raises blockers and meets deadlines.

  • Eager to learn and open to feedback.

Nice to haves

  • Working knowledge of Excel or Google Sheets for quick, ad-hoc checks (a plus, not a core requirement).

  • Relevant certifications (e.g. Google Data Analytics, Microsoft Power BI Data Analyst, or SQL certifications).

  • Basic knowledge of Python or R.

  • Experience with survey, learning platform, CRM or programme data.

  • Exposure to cloud data warehouses such as Snowflake, or to dbt.

  • Experience with monitoring and evaluation (M&E) data.

  • Experience in a learning, development-sector or impact-driven organisation.


BenefitsWhy 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 Westlands, Nairobi

    • Monthly team social events and yearly offsite

    • Regular learning and coaching opportunities

  • A hybrid working model



Skills Required

  • Bachelor's degree in Statistics, Economics, Mathematics, Data Science, Computer Science, Business Analytics, or a related field
  • 2 to 4 years of experience in data analysis, business intelligence, or reporting
  • Experience building dashboards or regular reports for non-technical teams
  • Experience handling multiple requests and prioritizing with guidance
  • Good SQL skills, including joins, aggregations, filtering, and window functions
  • Experience with at least one BI tool such as Metabase, Power BI, Tableau, or Looker
  • Understanding of descriptive statistics and accurate data presentation
  • Strong attention to detail and data validation habits
  • Clear written and verbal communication, including explaining findings in plain language
  • Proactive, reliable, and able to meet deadlines
  • Willingness to learn and accept feedback
  • Working knowledge of Excel or Google Sheets
  • Relevant data analytics, Power BI, or SQL certification
  • Basic knowledge of Python or R
  • Experience with survey, learning platform, CRM, or programme data
  • Exposure to cloud data warehouses such as Snowflake or dbt
  • Experience with monitoring and evaluation data
  • Experience in a learning, development-sector, or impact-driven organization
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company

What We Do

The African Management Institute (AMI) is a leader in business learning, providing practical tools and training to support the growth of ambitious African businesses, entrepreneurs, and their workforce.

Similar Jobs

KEPRO Logo KEPRO

Data Analyst

Greentech • Social Impact
In-Office
Nairobi, KEN
18 Employees

Invent Consulting Limited Logo Invent Consulting Limited

Data Analyst

Software • Analytics • Business Intelligence • Consulting
In-Office
Nairobi, KEN
21 Employees
In-Office
Nairobi, KEN
1090 Employees
228K-228K Annually

Ericsson Logo Ericsson

Architect

Cloud • Information Technology • Internet of Things • Machine Learning • Software • Cybersecurity • Infrastructure as a Service (IaaS)
In-Office
6 Locations
88000 Employees

Similar Companies Hiring

Playground (tryplayground.com) Thumbnail
Kids + Family • Payments • Social Impact • Software
New York City, New York
80 Employees
Cravath, Swaine & Moore LLP Thumbnail
Legal Tech • Other • Professional Services
New York, NY
1200 Employees
VCA Animal Hospitals Thumbnail
Pet • Professional Services
Los Angeles, CA
35000 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account