Assistant Data Analyst at African Guarantee Fund AGF in Nairobi, Kenya

    African Guarantee Fund AGF logo

    Assistant Data Analyst

    Posted

    5 days ago

    Apply by

    31 Aug

    Full Time
    On Site
    Mid
    Banking, Insurance & Financial Services
    Data, Analytics & AI

    Build your CV in minutes! Tailored for the Kenyan job market.

    Build My CV

    Job Description

    The Data Analyst supports the strengthening of AGF's Group-wide business by evaluating credit portfolio data, tracks guarantee utilization, and monitors risk metrics across partner financial institutions. They transform complex regional lending data into actionable dashboards and stakeholder reports to optimize small and medium enterprise financial inclusion.

    Key Responsibilities

    • Research and map development markets to identify opportunities and potential clients.
    • Support market and competitor analysis, trend tracking, and basic data interpretation.
    • Conduct Excel analytics pivot tables, charts, data cleaning and assist with dashboards for the BD and Sales activities.
    • Support client prospection and monitor platforms for Request for Proposal or Quotation RFP/Q.
    • Maintain and update CRM records, ensuring data accuracy and reporting support.
    • Assist with lead onboarding of clients by conducting pre-assessment and due diligence and scheduling meetings with clients existent/prospective for BD team.
    • Support client engagements through follow-up actions, and admin support.
    • Help prepare documentation for BD and deal support submissions.
    • Track BD KPIs, pipeline activity, and client engagement metrics.
    • Coordinate with BD, Procurement and Communications teams for information and tasks.
    • Conduct research on new market segments and diversification areas.
    • Assist with progress trackers and simple reports.
    • Coordinate information for marketing materials with the communications team.

    Required Qualifications

    • Bachelor's degree in Statistics, Economics, Data Science, Data Analytics, Finance or Business Administration.
    • Master's degree in a quantitative or business field is an added advantage.
    • Professional certifications in data analytics, project management, or financial modeling e.g., CFA, FRM, or Tableau/Power BI certified.
    • 3 to 5 years of total work experience in data analysis, business intelligence, or market research.
    • 2+ years working within the financial services, development finance, fintech, or credit guarantee sector.
    • 3–5 years of experience in business development support, market research, CRM management, or sales operations.
    • Experience or exposure to the humanitarian or development sector is a plus.
    • Demonstrated track record of building dashboards and reporting frameworks that track business growth or loan portfolio performance.
    • Experience collaborating with cross-functional teams like risk management, credit underwriting, and institutional partnerships.
    • Data Visualization: Mastery of tools like Power BI or Tableau to present complex pipeline data to executives.
    • Technical Proficiency: Advanced SQL and Excel skills; basic proficiency in Python or R for predictive modeling.
    • Financial Analysis: Strong grasp of credit risk metrics, SME financing gaps, and portfolio default rates.
    • Communication: Ability to translate technical data insights into clear business development strategies for non-technical stakeholders.
    • Proficiency with CRM platforms e.g., Salesforce, Microsoft Dynamics, HubSpot, or similar.
    • Strong Excel capabilities pivot tables, lookups, charts, and basic data analysis.
    • Familiarity with Power BI or other data visualisation tools is an advantage.
    • Strong research, information-gathering, and data interpretation skills.
    • Ability to prepare a Credit Paper.
    • High level of accuracy, reliability, and comfort working with data and deadlines.
    • Strong analytical, communication, and organisational skills.
    • Proactive, resourceful, and eager to learn.
    • Able to manage multiple tasks and meet deadlines.

    Job Details

    Job Function

    Data, Analytics & AI

    Minimum Experience

    3 years

    Education Level

    Bachelor’s Degree

    Area of Study

    Business

    Field of Study

    Data Science

    Languages

    English

    Additional Information

    How to Apply: Send your application via email to recruitment@africanguaranteefund.com with the subject line "AGF - Application for Assistant Data Analyst Position". Include your resume and cover letter summarizing your relevant work experience, and the name and contact information of 3 referees familiar with your professional qualifications and work experience.

    Show Your Dashboard Impact Before You Walk In

    This role lives at the intersection of data, business development, and credit risk. The hiring team wants to see that you can turn raw numbers into decisions that grow SME lending, not just pretty charts.

    1. Build a portfolio of dashboards: Bring screenshots or live links of dashboards you've built, especially ones that track business growth or loan performance. Explain the data sources, the metrics you chose, and how leadership used them.

    2. Master the tools they use: Be ready to demonstrate advanced Excel (pivot tables, lookups, charts) and SQL. If you know Power BI or Tableau, prepare a short walkthrough of a dashboard you created.

    3. Speak the language of credit: Brush up on credit risk metrics like default rates, portfolio at risk, and SME financing gaps. Be ready to discuss how data can reduce risk and improve financial inclusion.

    4. Show your CRM chops: If you've used Salesforce, HubSpot, or Dynamics, highlight how you kept data clean and used it to support sales or BD. Mention any reporting you generated from the CRM.

    5. Prepare for a case study: You may be given a dataset and asked to analyze it on the spot. Practice cleaning data, creating a pivot table, and drawing insights quickly.

    6. Connect data to business outcomes: Instead of just listing technical skills, talk about how your analysis led to a 15% increase in leads or cut reporting time by 20%. Quantify your impact.

    7. Understand the sector: Research AGF and the development finance space. Know how credit guarantees work and the challenges SMEs face in East Africa. Show you're genuinely interested in financial inclusion.

    8. Polish your communication: You'll need to explain data to non-technical stakeholders. Practice simplifying complex findings into clear, actionable recommendations. Bring an example of a time you did this successfully.

    CareerSasa Safety Alert: Never pay employers or agencies for interviews, training, or job placement. Does a job request payment? Report it immediately using the "Flag" button. While CareerSasa vets job postings thoroughly, always verify opportunities independently.
    Share this job:

    Boost Your Application Success

    1. 1

      Expert CV help that gets you noticed. Build Your CV

    2. 2

      A personalized cover letter for this role. Write Cover Letter

    3. 3

      Attract recruiters with a stronger profile. Boost LinkedIn

    Tags

    data analysis
    Power BI
    Tableau
    SQL
    CRM