About this role
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.
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 Westlands, Nairobi
- Monthly team social events and yearly offsite
- Regular learning and coaching opportunities
- A hybrid working model
