Whatsapp, Telegram Groups
Jobs by Categories
Senior Specialist – Blended Finance at Alliance for a Green Revolution in Africa (AGRA)
New
Alliance for a Green Revolution in Africa
Website :
2 Days Ago
Linkedid Twitter Share on facebook
Senior Specialist – Blended Finance
2025-04-14T11:44:14+00:00
Alliance for a Green Revolution in Africa (AGRA)
https://greatkenyanjobs.com/jsjobsdata/data/employer/comp_5019/logo/North%20Star%20Alliance.png
FULL_TIME
 
Nairobi
Nairobi
00100
Kenya
Finance
Accounting & Finance
KES
 
MONTH
2025-04-25T17:00:00+00:00
 
Kenya
8

Senior Specialist – Blended Finance

The Position

 Senior Specialist – Blended Finance Job Reference: SS/IMTF/04/2025

 Senior Specialist – Blended Finance supports governments and public institutions, including development banks, to play their role of leadership in creating an enabling environment that motivates potential funders (like DFIs/IFIs and financial services providers) to enter the food systems/agricultural sector, which is perceived as risky with low returns. This role influences governments and public institutions to make the agricultural finance sector more attractive for financial sector players through effective design and deployment of public sector instruments like input subsidy, guarantee schemes, and other de-risking tools and policies.

The ideal candidate will forge partnerships between Governments, public institutions, and financial sector players in the development, funding, and deployment of blended finance instruments that address the risks and gaps in financing the agricultural sector. S/He will support the development of models and instruments that enable the financial ecosystem to effectively fund the agricultural sector. The role holder will actively co-develop innovative risk mitigating instruments (including insurance) that unlock financing for Agribusinesses and farmers and promote, where necessary, the use of digital channels for financial services delivery to reduce risk and costs of financing the agricultural sector.

Key Duties and Responsibilities:

  • Assess, analyze, and understand the Agricultural Finance situation in each of AGRA’s 15 focus countries in relation to the country plans, focus value chains, availability of youth-focused funding, and AGRA’s investment portfolio.
  • Identify risks and market gaps in financing the input and output markets for the identified value chains in collaboration with the AGRA country staff.
  • Identify relevant public sector partners (Ministries, Central bank, de-risking schemes, DFIs/IFIs, donors) that are instrumental in designing and deploying de-risking instruments and relevant policies and regulations that enhance financing of food systems with a focus on the agricultural sector.
  • Support AGRA’s country teams to engage public sector actors and enhance their role in reducing the cost and risk of financing the agricultural sector by introducing innovations and best practices through consultancies, convenings, and catalytic
  • Initiate dialogue with public sector partners on their role in financing the agricultural sector and the support that AGRA could bring to expand and improve financing of food systems. This could be through consultancies, grants, and convenings.
  • Engage with public sector actors to support them in identifying opportunities and potential partners that improve access to financial services for food system actors.
  • A trusted technical advisor to the Governments and, based on skills and evidence, advocates for the deployment of public funds to catalyze agricultural finance in the
  • Build strong networks in agricultural finance and stay abreast of market developments to proactively disseminate knowledge and experience to AGRA’s partners, networks, and other stakeholders in Africa.
  • Develop and optimize tailored solutions that grow the agricultural finance sector (using public and donor funding) as a project proposal or program, including facility structuring, negotiations, documentation, and delivery.
  • Achieve Resource Mobilization for AGRA and the focus countries to expand the blended finance portfolio and profile of AGRA.
  • Optimizes relevant data and information and analytics to support the Head – Inclusive Finance to drive effective negotiations with governments and donor agencies involved with dense, functional networks of blended finance partners throughout AGRA’s program
  • Document and disseminate learnings derived from the blended finance

Key Qualifications and Experience Required:

  • Bachelor’s degree from a reputable academic institution in a relevant field, such as public finance, agricultural economics, or business economics
  • A master’s degree in (agricultural) business, macroeconomics, or another relevant field is desired.
  • Experience in financial development, preferably in a public (funded) institution or an agricultural finance program in Africa
  • Good knowledge of the structure and functioning of public sector institutions that can reduce the cost and risk of agricultural finance.
  • Demonstrated expertise in designing and implementing blended finance structures that mobilize private capital to support inclusive and sustainable agricultural development.
  • Experience in the financial and agricultural sector and working with relevant public institutions that influence the functioning of the financial ecosystem.
  • Ability to align blended finance mechanisms with development outcomes and climate resilience in the agriculture sector.
  • Proficiency in structuring concessional finance instruments (e.g., guarantees, subordinated debt, technical assistance) tailored to agricultural value chains and rural development context.
  • Ability to work effectively and build the knowledge base of both national and regional teams in the specialized field of blended finance for food systems.
  • Knowledge of market systems development (MSD) approaches and their interaction with blended finance intervention.
  • In-depth understanding of the financing needs and challenges across agricultural value chains, especially in smallholder-dominated markets.
  • Knowledge of the public regulatory regimes operating at the national level to identify areas for improvement in the financial instruments and products available to the agricultural sector.
  • Proven experience working with bilateral and multilateral donors, development finance institutions (DFIs), and philanthropic organizations to mobilize capital and align funding with agricultural development objectives.
  • Demonstrated ability to build partnerships that enhance the scalability and sustainability of blended finance interventions in agriculture.
  • Excellent writing skills (ToRs, grant proposals, and knowledge documents) and communication skills (conducting webinars, chairing meetings, panel and moderation roles).
Assess, analyze, and understand the Agricultural Finance situation in each of AGRA’s 15 focus countries in relation to the country plans, focus value chains, availability of youth-focused funding, and AGRA’s investment portfolio. Identify risks and market gaps in financing the input and output markets for the identified value chains in collaboration with the AGRA country staff. Identify relevant public sector partners (Ministries, Central bank, de-risking schemes, DFIs/IFIs, donors) that are instrumental in designing and deploying de-risking instruments and relevant policies and regulations that enhance financing of food systems with a focus on the agricultural sector. Support AGRA’s country teams to engage public sector actors and enhance their role in reducing the cost and risk of financing the agricultural sector by introducing innovations and best practices through consultancies, convenings, and catalytic Initiate dialogue with public sector partners on their role in financing the agricultural sector and the support that AGRA could bring to expand and improve financing of food systems. This could be through consultancies, grants, and convenings. Engage with public sector actors to support them in identifying opportunities and potential partners that improve access to financial services for food system actors. A trusted technical advisor to the Governments and, based on skills and evidence, advocates for the deployment of public funds to catalyze agricultural finance in the Build strong networks in agricultural finance and stay abreast of market developments to proactively disseminate knowledge and experience to AGRA’s partners, networks, and other stakeholders in Africa. Develop and optimize tailored solutions that grow the agricultural finance sector (using public and donor funding) as a project proposal or program, including facility structuring, negotiations, documentation, and delivery. Achieve Resource Mobilization for AGRA and the focus countries to expand the blended finance portfolio and profile of AGRA. Optimizes relevant data and information and analytics to support the Head – Inclusive Finance to drive effective negotiations with governments and donor agencies involved with dense, functional networks of blended finance partners throughout AGRA’s program Document and disseminate learnings derived from the blended finance
 
Bachelor’s degree from a reputable academic institution in a relevant field, such as public finance, agricultural economics, or business economics A master’s degree in (agricultural) business, macroeconomics, or another relevant field is desired. Experience in financial development, preferably in a public (funded) institution or an agricultural finance program in Africa Good knowledge of the structure and functioning of public sector institutions that can reduce the cost and risk of agricultural finance. Demonstrated expertise in designing and implementing blended finance structures that mobilize private capital to support inclusive and sustainable agricultural development. Experience in the financial and agricultural sector and working with relevant public institutions that influence the functioning of the financial ecosystem. Ability to align blended finance mechanisms with development outcomes and climate resilience in the agriculture sector. Proficiency in structuring concessional finance instruments (e.g., guarantees, subordinated debt, technical assistance) tailored to agricultural value chains and rural development context. Ability to work effectively and build the knowledge base of both national and regional teams in the specialized field of blended finance for food systems. Knowledge of market systems development (MSD) approaches and their interaction with blended finance intervention. In-depth understanding of the financing needs and challenges across agricultural value chains, especially in smallholder-dominated markets. Knowledge of the public regulatory regimes operating at the national level to identify areas for improvement in the financial instruments and products available to the agricultural sector. Proven experience working with bilateral and multilateral donors, development finance institutions (DFIs), and philanthropic organizations to mobilize capital and align funding with agricultural development objectives. Demonstrated ability to build partnerships that enhance the scalability and sustainability of blended finance interventions in agriculture. Excellent writing skills (ToRs, grant proposals, and knowledge documents) and communication skills (conducting webinars, chairing meetings, panel and moderation roles).
bachelor degree
No Requirements
JOB-67fcf50e0ce9c

Vacancy title:
Senior Specialist – Blended Finance

[Type: FULL_TIME, Industry: Finance, Category: Accounting & Finance]

Jobs at:
Alliance for a Green Revolution in Africa (AGRA)

Deadline of this Job:
Friday, April 25 2025

Duty Station:
Nairobi | Nairobi | Kenya

Summary
Date Posted: Monday, April 14 2025, Base Salary: Not Disclosed

Similar Jobs in Kenya
Learn more about Alliance for a Green Revolution in Africa (AGRA)
Alliance for a Green Revolution in Africa (AGRA) jobs in Kenya

JOB DETAILS:

Senior Specialist – Blended Finance

The Position

 Senior Specialist – Blended Finance Job Reference: SS/IMTF/04/2025

 Senior Specialist – Blended Finance supports governments and public institutions, including development banks, to play their role of leadership in creating an enabling environment that motivates potential funders (like DFIs/IFIs and financial services providers) to enter the food systems/agricultural sector, which is perceived as risky with low returns. This role influences governments and public institutions to make the agricultural finance sector more attractive for financial sector players through effective design and deployment of public sector instruments like input subsidy, guarantee schemes, and other de-risking tools and policies.

The ideal candidate will forge partnerships between Governments, public institutions, and financial sector players in the development, funding, and deployment of blended finance instruments that address the risks and gaps in financing the agricultural sector. S/He will support the development of models and instruments that enable the financial ecosystem to effectively fund the agricultural sector. The role holder will actively co-develop innovative risk mitigating instruments (including insurance) that unlock financing for Agribusinesses and farmers and promote, where necessary, the use of digital channels for financial services delivery to reduce risk and costs of financing the agricultural sector.

Key Duties and Responsibilities:

  • Assess, analyze, and understand the Agricultural Finance situation in each of AGRA’s 15 focus countries in relation to the country plans, focus value chains, availability of youth-focused funding, and AGRA’s investment portfolio.
  • Identify risks and market gaps in financing the input and output markets for the identified value chains in collaboration with the AGRA country staff.
  • Identify relevant public sector partners (Ministries, Central bank, de-risking schemes, DFIs/IFIs, donors) that are instrumental in designing and deploying de-risking instruments and relevant policies and regulations that enhance financing of food systems with a focus on the agricultural sector.
  • Support AGRA’s country teams to engage public sector actors and enhance their role in reducing the cost and risk of financing the agricultural sector by introducing innovations and best practices through consultancies, convenings, and catalytic
  • Initiate dialogue with public sector partners on their role in financing the agricultural sector and the support that AGRA could bring to expand and improve financing of food systems. This could be through consultancies, grants, and convenings.
  • Engage with public sector actors to support them in identifying opportunities and potential partners that improve access to financial services for food system actors.
  • A trusted technical advisor to the Governments and, based on skills and evidence, advocates for the deployment of public funds to catalyze agricultural finance in the
  • Build strong networks in agricultural finance and stay abreast of market developments to proactively disseminate knowledge and experience to AGRA’s partners, networks, and other stakeholders in Africa.
  • Develop and optimize tailored solutions that grow the agricultural finance sector (using public and donor funding) as a project proposal or program, including facility structuring, negotiations, documentation, and delivery.
  • Achieve Resource Mobilization for AGRA and the focus countries to expand the blended finance portfolio and profile of AGRA.
  • Optimizes relevant data and information and analytics to support the Head – Inclusive Finance to drive effective negotiations with governments and donor agencies involved with dense, functional networks of blended finance partners throughout AGRA’s program
  • Document and disseminate learnings derived from the blended finance

Key Qualifications and Experience Required:

  • Bachelor’s degree from a reputable academic institution in a relevant field, such as public finance, agricultural economics, or business economics
  • A master’s degree in (agricultural) business, macroeconomics, or another relevant field is desired.
  • Experience in financial development, preferably in a public (funded) institution or an agricultural finance program in Africa
  • Good knowledge of the structure and functioning of public sector institutions that can reduce the cost and risk of agricultural finance.
  • Demonstrated expertise in designing and implementing blended finance structures that mobilize private capital to support inclusive and sustainable agricultural development.
  • Experience in the financial and agricultural sector and working with relevant public institutions that influence the functioning of the financial ecosystem.
  • Ability to align blended finance mechanisms with development outcomes and climate resilience in the agriculture sector.
  • Proficiency in structuring concessional finance instruments (e.g., guarantees, subordinated debt, technical assistance) tailored to agricultural value chains and rural development context.
  • Ability to work effectively and build the knowledge base of both national and regional teams in the specialized field of blended finance for food systems.
  • Knowledge of market systems development (MSD) approaches and their interaction with blended finance intervention.
  • In-depth understanding of the financing needs and challenges across agricultural value chains, especially in smallholder-dominated markets.
  • Knowledge of the public regulatory regimes operating at the national level to identify areas for improvement in the financial instruments and products available to the agricultural sector.
  • Proven experience working with bilateral and multilateral donors, development finance institutions (DFIs), and philanthropic organizations to mobilize capital and align funding with agricultural development objectives.
  • Demonstrated ability to build partnerships that enhance the scalability and sustainability of blended finance interventions in agriculture.
  • Excellent writing skills (ToRs, grant proposals, and knowledge documents) and communication skills (conducting webinars, chairing meetings, panel and moderation roles).

 

Work Hours: 8

Experience: No Requirements

Level of Education: bachelor degree

Job application procedure
Interested in applying for this job? Click here to submit your application now.

All Jobs | QUICK ALERT SUBSCRIPTION

Job Info
Job Category: Accounting/ Finance jobs in Kenya
Job Type: Full-time
Deadline of this Job: Apr 25, 2025
Duty Station:  Nairobi | Nairobi | Kenya
Posted: 14-04-2025
No of Jobs: 1
Start Publishing: 14-04-2025
Stop Publishing (Put date of 2030): 14-04-2065
Apply Now

Caution: Never Pay Money in a Recruitment Process.

Some smart scams can trick you into paying for Psychometric Tests.
J! InfoRequestSessionProfileQueries87Log
60.088MBMemory Usage341msRequest Duration
Joomla! Version4.4.10
PHP Version8.1.32
Identityguest
Response200
Templatejl_education_pro
Database
Server
mysql
Version
10.5.28-MariaDB
Collation
latin1_swedish_ci
Conn Collation
utf8mb4_general_ci
$_GET
[]
$_POST
[]
$_SESSION
array:1 [ "joomla" => "***redacted***" ]
$_COOKIE
[]
$_SERVER
array:63 [ "USER" => "greatkenyanjobs" "HOME" => "/home/greatkenyanjobs" "SCRIPT_NAME" => "/in...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1744843186 "last" => 1744843186...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
jsjobcur_usr
0
jsjobconfig_dft
array:171 [ "actk" => "0" "applybuttonredirecturl" => "http://www.greatkenyanjobs.com/how-to-app...
JSItemid
"190"
  • afterLoad (4.12MB) (16.02ms)
  • afterInitialise (11.09MB) (54.56ms)
  • afterRoute (5.02MB) (22.74ms)
  • beforeRenderComponent com_jsjobs (9.48KB) (170μs)
  • afterRenderComponent com_jsjobs (3.14MB) (28.42ms)
  • Before Access::preloadComponents (all components) (320.89KB) (5.34ms)
  • After Access::preloadComponents (all components) (132.67KB) (879μs)
  • Before Access::getAssetRules (id:1 name:root.1) (3.95KB) (12μs)
  • After Access::getAssetRules (id:1 name:root.1) (26.2KB) (229μs)
  • beforeRenderRawModule mod_gantry5_particle (Career Guide) (2.37MB) (21.03ms)
  • afterRenderRawModule mod_gantry5_particle (Career Guide) (18.48MB) (61.43ms)
  • beforeRenderModule mod_gantry5_particle (Career Guide) (720B) (5μs)
  • afterRenderModule mod_gantry5_particle (Career Guide) (9.93KB) (259μs)
  • afterDispatch (92.41KB) (92μs)
  • afterRender (13.91MB) (130ms)
  • 1 x afterRender (13.91MB) (38.04%)
    129.85ms
    1 x afterRenderRawModule mod_gantry5_particle (Career Guide) (18.48MB) (18%)
    61.43ms
    1 x afterInitialise (11.09MB) (15.98%)
    54.56ms
    1 x afterRenderComponent com_jsjobs (3.14MB) (8.33%)
    28.42ms
    1 x afterRoute (5.02MB) (6.66%)
    22.74ms
    1 x beforeRenderRawModule mod_gantry5_particle (Career Guide) (2.37MB) (6.16%)
    21.03ms
    1 x afterLoad (4.12MB) (4.69%)
    16.02ms
    1 x Before Access::preloadComponents (all components) (320.89KB) (1.57%)
    5.34ms
    1 x After Access::preloadComponents (all components) (132.67KB) (0.26%)
    879μs
    1 x afterRenderModule mod_gantry5_particle (Career Guide) (9.93KB) (0.08%)
    259μs
    1 x After Access::getAssetRules (id:1 name:root.1) (26.2KB) (0.07%)
    229μs
    1 x beforeRenderComponent com_jsjobs (9.48KB) (0.05%)
    170μs
    1 x afterDispatch (92.41KB) (0.03%)
    92μs
    1 x Before Access::getAssetRules (id:1 name:root.1) (3.95KB) (0%)
    12μs
    1 x beforeRenderModule mod_gantry5_particle (Career Guide) (720B) (0%)
    5μs
87 statements were executed, 23 of which were duplicates, 64 unique17.05ms284KB
UniquesDuplicates 1Duplicates 2Duplicates 3Duplicates 4Duplicates 5Duplicates 6
  • SELECT @@SESSION.sql_mode;90μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `icop0_session` WHERE `session_id` = ?122μs1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `icop0_session` WHERE `session_id` = :session_id LIMIT 199μs1.61KBParams/libraries/src/Session/MetadataManager.php:187Copy
  • INSERT INTO `icop0_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (:session_id, :guest, :time, :user_id, :username, :client_id)238μs944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `id`,`rules` FROM `icop0_viewlevels`123μs1.59KB/libraries/src/Access/Access.php:955Copy
  • SELECT `b`.`id` FROM `icop0_usergroups` AS `a` LEFT JOIN `icop0_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt` WHERE `a`.`id` = :guest87μs1.64KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `value` FROM `icop0_admintools_storage` WHERE `key` = 'cparams'122μs856B/administrator/components/com_admintools/src/Helper/Storage.php:120Copy
  • SELECT `option`,`view`,`query` FROM `icop0_admintools_wafexceptions`100μs960B/plugins/system/admintools/src/Utility/Cache.php:196Copy
  • SELECT `params` FROM `icop0_extensions` WHERE `type` = 'plugin' AND `folder` = 'system' AND `element` = 'admintools'183μs2.09KB/plugins/system/admintools/src/Utility/RescueUrl.php:324Copy
  • SELECT * FROM icop0_rsform_config152μs1.5KB/administrator/components/com_rsform/helpers/config.php:52Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'level'96μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'active_cron'54μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'cron_next'83μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'queue_type'40μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT *,(subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-Senior-Specialist-%25e2%2580%2593-Blended-Finance-at-Alliance-for-a-Green-Revolution-in-Africa-AGRA-100671%2F')=1) inSub FROM icop0_jlexblock WHERE ((mt_fullsite=1 AND mt_index=1) OR ((`sef_link`='%2Fjobs%2Fjob-detail%2Fjob-Senior-Specialist-%25e2%2580%2593-Blended-Finance-at-Alliance-for-a-Green-Revolution-in-Africa-AGRA-100671%2F' OR (subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-Senior-Specialist-%25e2%2580%2593-Blended-Finance-at-Alliance-for-a-Green-Revolution-in-Africa-AGRA-100671%2F')=1) OR `list_var` LIKE '%com_jsjobs%') AND mt_fullsite=0)) AND published=1 ORDER BY mt_area DESC,id ASC275μs4.25KB/plugins/system/jlexblock/jlexblock.php:147Copy
  • SELECT s.id, s.template, s.home, s.title AS long_title, s.params FROM icop0_template_styles AS s WHERE s.client_id = 0 AND s.template = 'jl_education_pro' ORDER BY s.id200μs1.2KB/libraries/gantry5/src/classes/Gantry/Joomla/StyleHelper.php:69Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'default'248μs6.44KB/components/com_jsjobs/models/configurations.php:64Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'236μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'social'251μs1.13KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'default'415μs3.94KB/components/com_jsjobs/models/configurations.php:64Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'225μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'default_login_from'78μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'visitor_can_edit_job'64μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'259μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT job.params,job.id,job.title,job.city,job.metakeywords,job.metadescription,job.description,job.created,job.isgoldjob,job.isfeaturedjob,job.gender , job.jobcategory,job.duration,job.hidesalaryrange,job.zipcode,job.iseducationminimax,job.degreetitle,job.isexperienceminimax , job.startpublishing,job.requiredtravel,job.noofjobs,job.hits,job.stoppublishing,job.video,job.prefferdskills,job.qualifications,job.agreement,job.experiencetext,job.longitude,job.latitude , cat.cat_title, subcat.title as subcategory, company.name as companyname, jobtype.title AS jobtypetitle , jobstatus.title AS jobstatustitle, shift.title as shifttitle, company.url as companywebsite, company.contactname AS companycontactname, company.contactemail AS companycontactemail,company.since AS companysince,company.logofilename AS companylogo , department.name AS departmentname, company.id companyid,job.educationminimax,job.experienceminimax , salaryfrom.rangestart AS salaryfrom, salaryto.rangestart AS salaryto, salarytype.title AS salarytype , education.title AS educationtitle ,mineducation.title AS mineducationtitle, maxeducation.title AS maxeducationtitle , experience.title AS experiencetitle ,minexperience.title AS minexperiencetitle, maxexperience.title AS maxexperiencetitle , currency.symbol,CONCAT(job.alias,'-',job.id) AS jobaliasid, agefrom.title AS agefromtitle, ageto.title AS agetotitle ,company.isgoldcompany,company.isfeaturedcompany ,CONCAT(company.alias,'-',company.id) AS companyaliasid, workpermit.name as workpermitcountry ,company.endgolddate,company.endfeatureddate, job.jobapplylink,job.joblink, careerlevel.title AS careerleveltitle ,(SELECT COUNT(id) FROM `icop0_js_job_jobapply` WHERE jobid = job.id) AS totalapply FROM `icop0_js_job_jobs` AS job JOIN `icop0_js_job_categories` AS cat ON job.jobcategory = cat.id JOIN `icop0_js_job_companies` AS company ON job.companyid = company.id JOIN `icop0_js_job_jobtypes` AS jobtype ON job.jobtype = jobtype.id LEFT JOIN `icop0_js_job_ages` AS agefrom ON agefrom.id = job.agefrom LEFT JOIN `icop0_js_job_ages` AS ageto ON ageto.id = job.ageto LEFT JOIN `icop0_js_job_subcategories` AS subcat ON job.subcategoryid = subcat.id LEFT JOIN `icop0_js_job_jobstatus` AS jobstatus ON job.jobstatus = jobstatus.id LEFT JOIN `icop0_js_job_departments` AS department ON job.departmentid = department.id LEFT JOIN `icop0_js_job_salaryrange` AS salaryfrom ON job.salaryrangefrom = salaryfrom.id LEFT JOIN `icop0_js_job_salaryrange` AS salaryto ON job.salaryrangeto = salaryto.id LEFT JOIN `icop0_js_job_salaryrangetypes` AS salarytype ON job.salaryrangetype = salarytype.id LEFT JOIN `icop0_js_job_heighesteducation` AS education ON job.educationid = education.id LEFT JOIN `icop0_js_job_heighesteducation` AS mineducation ON job.mineducationrange = mineducation.id LEFT JOIN `icop0_js_job_heighesteducation` AS maxeducation ON job.maxeducationrange = maxeducation.id LEFT JOIN `icop0_js_job_experiences` AS experience ON job.experienceid = experience.id LEFT JOIN `icop0_js_job_experiences` AS minexperience ON job.minexperiencerange = minexperience.id LEFT JOIN `icop0_js_job_experiences` AS maxexperience ON job.maxexperiencerange = maxexperience.id LEFT JOIN `icop0_js_job_shifts` AS shift ON job.shift = shift.id LEFT JOIN `icop0_js_job_currencies` AS currency ON currency.id = job.currencyid LEFT JOIN `icop0_js_job_countries` AS workpermit ON workpermit.id = job.workpermit LEFT JOIN `icop0_js_job_careerlevels` AS careerlevel ON job.careerlevel = careerlevel.id WHERE job.id = 100671704μs84.03KB/components/com_jsjobs/models/job.php:1579Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'186μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • UPDATE `icop0_js_job_jobs` SET hits = hits + 1 WHERE id = 100671370μs48B/components/com_jsjobs/models/job.php:1588Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'270μs992B/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE published = 1 AND fieldfor = 2 ORDER BY ordering276μs4.52KB/components/com_jsjobs/models/customfields.php:59Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'255μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'220μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE published = 1 AND fieldfor = 1 ORDER BY ordering247μs4.48KB/components/com_jsjobs/models/customfields.php:59Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'223μs12.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'listjob'231μs1.38KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'companydefaultlogopath'78μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'data_directory'56μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'listjob'233μs1.38KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'229μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'companydefaultlogopath'58μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'data_directory'56μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'jobcategory' AND fieldfor = 2166μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'jobtype' AND fieldfor = 2123μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE field = 'ufield917' AND isuserfield = 1 AND userfieldtype != 'termsandconditions'603μs4.28KB/administrator/components/com_jsjobs/include/classes/customfields.php:645Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE field = 'ufield918' AND isuserfield = 1 AND userfieldtype != 'termsandconditions'564μs4.28KB/administrator/components/com_jsjobs/include/classes/customfields.php:645Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'noofjobs' AND fieldfor = 2133μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'startpublishing' AND fieldfor = 2153μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'stoppublishing' AND fieldfor = 2127μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'306μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'default'285μs3.94KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'261μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE isvisitorpublished = 1 AND fieldfor = 14 ORDER BY ordering190μs4.27KB/components/com_jsjobs/models/customfields.php:59Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `icop0_assets` WHERE `name` IN (:preparedArray1,:preparedArray2,:preparedArray3,:preparedArray4,:preparedArray5,:preparedArray6,:preparedArray7,:preparedArray8,:preparedArray9,:preparedArray10,:preparedArray11,:preparedArray12,:preparedArray13,:preparedArray14,:preparedArray15,:preparedArray16,:preparedArray17,:preparedArray18,:preparedArray19,:preparedArray20,:preparedArray21,:preparedArray22,:preparedArray23,:preparedArray24,:preparedArray25,:preparedArray26,:preparedArray27,:preparedArray28,:preparedArray29,:preparedArray30,:preparedArray31,:preparedArray32,:preparedArray33,:preparedArray34,:preparedArray35,:preparedArray36,:preparedArray37,:preparedArray38,:preparedArray39,:preparedArray40,:preparedArray41,:preparedArray42,:preparedArray43,:preparedArray44,:preparedArray45,:preparedArray46,:preparedArray47,:preparedArray48,:preparedArray49,:preparedArray50)570μs8.25KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT `id` FROM `icop0_rstbox` WHERE `published` = 1 AND `testmode` = 093μs904B/administrator/components/com_rstbox/EngageBox/Boxes.php:45Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 22101μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 24125μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 3687μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 37114μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT `a`.`menutype`,`a`.`title` FROM `icop0_menu_types` AS `a` WHERE `a`.`client_id` = 099μs1.19KB/libraries/gantry5/src/classes/Gantry/Framework/Menu.php:138Copy
  • SELECT m.id, m.alias, m.path AS route, m.level, m.parent_id FROM icop0_menu AS m WHERE m.menutype = 'mainmenu' AND m.parent_id > 0 AND m.client_id = 0 AND m.published >= 0 ORDER BY m.lft338μs1.8KB/libraries/gantry5/src/classes/Gantry/Framework/Menu.php:791Copy
  • SELECT m.id, m.alias, m.path AS route, m.level, m.parent_id FROM icop0_menu AS m WHERE m.menutype = 'distribution-channels' AND m.parent_id > 0 AND m.client_id = 0 AND m.published >= 0 ORDER BY m.lft191μs1.17KB/libraries/gantry5/src/classes/Gantry/Framework/Menu.php:791Copy
  • SELECT m.id, m.alias, m.path AS route, m.level, m.parent_id FROM icop0_menu AS m WHERE m.menutype = 'categories-list' AND m.parent_id > 0 AND m.client_id = 0 AND m.published >= 0 ORDER BY m.lft306μs2.3KB/libraries/gantry5/src/classes/Gantry/Framework/Menu.php:791Copy
  • SELECT * FROM icop0_jmap_metainfo WHERE `linkurl` = 'https://www.greatkenyanjobs.com/jobs/job-detail/job-Senior-Specialist-–-Blended-Finance-at-Alliance-for-a-Green-Revolution-in-Africa-AGRA-100671' AND `published` = 1115μs1.2KB/plugins/system/jmap/jmap.php:818Copy
  • SELECT * FROM icop0_jmap_canonicals WHERE `linkurl` = 'https://www.greatkenyanjobs.com/jobs/job-detail/job-Senior-Specialist-–-Blended-Finance-at-Alliance-for-a-Green-Revolution-in-Africa-AGRA-100671'68μs960B/plugins/system/jmap/jmap.php:920Copy
  • SELECT * FROM icop0_acym_configuration289μs24.88KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_list WHERE type = 'standard'143μs10.3KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_field95μs2.33KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_form WHERE active = 1 AND type != 'shortcode'85μs1.2KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT SUM(CASE WHEN `a`.`next_execution` <= :now THEN 1 ELSE 0 END) AS due_count,SUM(CASE WHEN `a`.`locked` IS NULL THEN 0 ELSE 1 END) AS locked_count FROM `icop0_scheduler_tasks` AS `a` WHERE `a`.`state` = 1102μs1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT * FROM `icop0_extensions` WHERE `element` = 'com_gsd' AND `type` = 'component'171μs3.78KB/plugins/system/nrframework/NRFramework/Extension.php:160Copy
  • SHOW FULL COLUMNS FROM `icop0_gsd_config`241μs1.92KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `icop0_gsd_config` WHERE `name` = 'config'67μs912B/libraries/src/Table/Table.php:755Copy
  • SELECT a.* FROM icop0_gsd a WHERE a.state = 1 AND a.plugin = 'menus' AND a.appview IN ('menus','*') ORDER BY a.id desc144μs2.08KB/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SHOW FULL COLUMNS FROM `icop0_users`293μs2.2KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `icop0_users` WHERE `id` = :userid118μs4.41KBParams/libraries/src/Table/User.php:104Copy
  • SELECT `g`.`id`,`g`.`title` FROM `icop0_usergroups` AS `g` INNER JOIN `icop0_user_usergroup_map` AS `m` ON `m`.`group_id` = `g`.`id` WHERE `m`.`user_id` = :muserid124μs1.68KBParams/libraries/src/Table/User.php:132Copy
  • SELECT * FROM icop0_jmap_headings WHERE `linkurl` = 'https://www.greatkenyanjobs.com/jobs/job-detail/job-Senior-Specialist-–-Blended-Finance-at-Alliance-for-a-Green-Revolution-in-Africa-AGRA-100671'79μs1.05KB/plugins/system/jmap/jmap.php:1135Copy
  • SELECT `original_text`, `target_text`, `original_text_regex`, `target_text_regex` FROM `icop0_jmap_text_replacements` WHERE `published` = 165μs1008B/plugins/system/jmap/jmap.php:508Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` LIKE "%regacy" OR `name` LIKE "%\_sub"424μs856B/plugins/system/acymtriggers/acymtriggers.php:430Copy
  • SHOW TABLES738μs8.82KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:678Copy
  • SELECT * FROM icop0_acym_plugin115μs2.14KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_plugin134μs2.14KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT `groups`.*, `groups`.title AS text, `groups`.id AS `value` FROM icop0_usergroups AS `groups`72μs1.36KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'company_seo'131μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'185μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT name AS col FROM `icop0_js_job_companies` WHERE id = 450662μs856B/components/com_jsjobs/models/company.php:1832Copy
  • SELECT `session_id` FROM `icop0_session` WHERE `session_id` = ?121μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `icop0_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?399μs912BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy