Chief Investments Officer (CIO) job at ZCCM Investments Holdings PLC
Website :
29 Days Ago
Linkedid Twitter Share on facebook
Chief Investments Officer (CIO)
2025-04-10T07:28:46+00:00
ZCCM Investments Holdings PLC
https://www.greatzambiajobs.com/jsjobsdata/data/employer/comp_3458/logo/ZCCM%20Investments%20Holding%20Plc.jpg
FULL_TIME
 
Lusaka
Lusaka
10101
Zambia
Business Management and Administration
Management
ZMW
 
MONTH
2025-04-21T17:00:00+00:00
 
Zambia
8

Industry: Banking/Finance And Investment
Job Type: Contract
Positions Available: 1
Salary: Market Related

ZCCM Investments Holdings Plc (“ZCCM-IH” or the “Company”) wishes to invite applications from suitably qualified and experienced persons to fill the vacancy of Chief Investments Officer.

Job Description

Job Purpose

To lead and drive the core business of ZCCM-IH by developing and executing the company’s investment strategy to achieve sustainable growth, maximize shareholder value, and ensure long-term profitability. The role provides strategic leadership in identifying, evaluating, structuring, monitoring, and managing investment opportunities to ensure optimal returns. The CIO is also responsible for making data-driven recommendations to management regarding refinements to existing investments and assessing potential opportunities. As the project manager for all investments and projects, the CIO oversees risk management, ensuring that all ventures align with corporate objectives and industry best practices. Additionally, the role champions the company’s diversification agenda, steering ZCCM-IH’s expansion beyond the mining sector as outlined in the strategic plan.

Primary Roles and Accountabilities:

  • Drives the Organisation’s strategy on investments;
  • Creates new strategic and tactical investment portfolio and identifies the best execution methods for those investments.
  • Recommends investments, monitors the performance of investments, ensuring ZCCM-IH’s objectives are met and the strategic and financial goals achieved
  • Effectively communicate the investment policy and portfolio decisions
  • Identify the key investment projects for the Financial Year and develops Business Plans, thereof
  • Oversees the Company’s Financial investment analysis in investee companies and other sectors and conducts independent research to determine their viability
  • Maintains the financial analysis tool and tracks the trends on all investments.
  • Develops and submits financial analysis reports on each investment/ project for decision making
  • Leads in the monitoring of the performance for the investee companies; subsidiaries and other investments
  • Develops framework for decisions about the portfolio management strategies    used for investment purposes,
  • Leads processes for all portfolio management decisions and implementation, including asset selection, portfolio rebalancing
  • Responsible for overseeing portfolio allocation levels under various market conditions
  • Leads the construction and management processes for all portfolio models, including ongoing tactical adjustments as necessary
  • Promotes and establishes good working relationships with stakeholders and develop alliances that add value to the Business
  • Maintains good relationship in the financial sector to remain fully informed on various sources of finance
  • Actively monitors the social economic trends in the market to regularly align the funding program as per market norms and requirements
  • Leads and coordinates a team of highly qualified professionals in portfolio of base metals and legacy; industrial minerals; precious metals and minerals and energy and mineral beneficiation management
  • Responsible for the investments papers that go to the Investments Committee of the Board (ICB)
  • Leads and coordinates the Investment Team Day to day activities, including allocation of time and research resources and the optimization of a team-specific budget
  • Establish and monitor staff performance and development goals, assign accountabilities, set objectives, establish priorities, conduct annual performance appraisals and staff discipline
  • Evaluate project proposals/ investment ideas
  •  Conducts detailed feasibility studies for investment evaluation of the project and developing, as well as presenting investment proposals for internal approval of the Investment Committee
  • Ensures that projects are efficiently and effectively managed according to the agreed timescale and budget
  • Monitors investment performance through project progress and maintains alignment with project and budget
  • Liaises with the risk function on risk management issues that directly impact the strategic direction of the company investments.
  • Manages the funds placements with financial institutions
  • Reviews treasury reports such as maturity, liquidity mismatch, interest risk gap analysis risk exposure, and concentration risk reports to enable management assess exposure to various risks in the operations sectors
  • Monitor subsidiary businesses to ensure that they efficiently and effectively provide needed products and services while staying within budgetary limits, investment performance targets and operational goals
  • Effectively mobilises human, financial, technical and material resources to enhance implementation of all investment projects in ZCCM -IH
Job Requirements

Relevant Qualifications

 

Considerable competences at senior management level are required to understand and apply advanced policies, practices, procedures, concepts and principles in order to effectively perform in this role.

  • General Certification of Education (GCE) or equivalent with Credit or Better in Five (5) subjects, Mathematics and English included
  • Degree in Economics/ Accounting or equivalent.
  • ACCA/ CIMA /CFA or equivalent or business-related fields.
  • Master’s Degree in a relevant field
  • Relevant Professional Certification
  • Membership of relevant Professional Body
  • Professional Work Experience
  • Not less than 10 Years work experience in a busy and complex work environment of which 5 years must be at Management level.
  • High level experience in stakeholder management.
  • Proven written and oral skills and ability to distil and communicate complex matters at the highest levels.
  • Group holding company experience will be an added advantage.
Drives the Organisation’s strategy on investments; Creates new strategic and tactical investment portfolio and identifies the best execution methods for those investments. Recommends investments, monitors the performance of investments, ensuring ZCCM-IH’s objectives are met and the strategic and financial goals achieved Effectively communicate the investment policy and portfolio decisions Identify the key investment projects for the Financial Year and develops Business Plans, thereof Oversees the Company’s Financial investment analysis in investee companies and other sectors and conducts independent research to determine their viability Maintains the financial analysis tool and tracks the trends on all investments. Develops and submits financial analysis reports on each investment/ project for decision making Leads in the monitoring of the performance for the investee companies; subsidiaries and other investments Develops framework for decisions about the portfolio management strategies used for investment purposes, Leads processes for all portfolio management decisions and implementation, including asset selection, portfolio rebalancing Responsible for overseeing portfolio allocation levels under various market conditions Leads the construction and management processes for all portfolio models, including ongoing tactical adjustments as necessary Promotes and establishes good working relationships with stakeholders and develop alliances that add value to the Business Maintains good relationship in the financial sector to remain fully informed on various sources of finance Actively monitors the social economic trends in the market to regularly align the funding program as per market norms and requirements Leads and coordinates a team of highly qualified professionals in portfolio of base metals and legacy; industrial minerals; precious metals and minerals and energy and mineral beneficiation management Responsible for the investments papers that go to the Investments Committee of the Board (ICB) Leads and coordinates the Investment Team Day to day activities, including allocation of time and research resources and the optimization of a team-specific budget Establish and monitor staff performance and development goals, assign accountabilities, set objectives, establish priorities, conduct annual performance appraisals and staff discipline Evaluate project proposals/ investment ideas Conducts detailed feasibility studies for investment evaluation of the project and developing, as well as presenting investment proposals for internal approval of the Investment Committee Ensures that projects are efficiently and effectively managed according to the agreed timescale and budget Monitors investment performance through project progress and maintains alignment with project and budget Liaises with the risk function on risk management issues that directly impact the strategic direction of the company investments. Manages the funds placements with financial institutions Reviews treasury reports such as maturity, liquidity mismatch, interest risk gap analysis risk exposure, and concentration risk reports to enable management assess exposure to various risks in the operations sectors Monitor subsidiary businesses to ensure that they efficiently and effectively provide needed products and services while staying within budgetary limits, investment performance targets and operational goals Effectively mobilises human, financial, technical and material resources to enhance implementation of all investment projects in ZCCM -IH
Relevant Professional Certification Membership of relevant Professional Body Professional Work Experience Not less than 10 Years work experience in a busy and complex work environment of which 5 years must be at Management level. High level experience in stakeholder management. Proven written and oral skills and ability to distil and communicate complex matters at the highest levels. Group holding company experience will be an added advantage.
General Certification of Education (GCE) or equivalent with Credit or Better in Five (5) subjects, Mathematics and English included Degree in Economics/ Accounting or equivalent. ACCA/ CIMA /CFA or equivalent or business-related fields. Master’s Degree in a relevant field Relevant Professional Certification Membership of relevant Professional Body Professional Work Experience Not less than 10 Years work experience in a busy and complex work environment of which 5 years must be at Management level. High level experience in stakeholder management. Proven written and oral skills and ability to distil and communicate complex matters at the highest levels. Group holding company experience will be an added advantage.
bachelor degree
120
JOB-67f7732e1347a

Vacancy title:
Chief Investments Officer (CIO)

[Type: FULL_TIME, Industry: Business Management and Administration, Category: Management]

Jobs at:
ZCCM Investments Holdings PLC

Deadline of this Job:
Monday, April 21 2025

Duty Station:
Lusaka | Lusaka | Zambia

Summary
Date Posted: Thursday, April 10 2025, Base Salary: Not Disclosed

Similar Jobs in Zambia
Learn more about ZCCM Investments Holdings PLC
ZCCM Investments Holdings PLC jobs in Zambia

JOB DETAILS:

Industry: Banking/Finance And Investment
Job Type: Contract
Positions Available: 1
Salary: Market Related

ZCCM Investments Holdings Plc (“ZCCM-IH” or the “Company”) wishes to invite applications from suitably qualified and experienced persons to fill the vacancy of Chief Investments Officer.

Job Description

Job Purpose

To lead and drive the core business of ZCCM-IH by developing and executing the company’s investment strategy to achieve sustainable growth, maximize shareholder value, and ensure long-term profitability. The role provides strategic leadership in identifying, evaluating, structuring, monitoring, and managing investment opportunities to ensure optimal returns. The CIO is also responsible for making data-driven recommendations to management regarding refinements to existing investments and assessing potential opportunities. As the project manager for all investments and projects, the CIO oversees risk management, ensuring that all ventures align with corporate objectives and industry best practices. Additionally, the role champions the company’s diversification agenda, steering ZCCM-IH’s expansion beyond the mining sector as outlined in the strategic plan.

Primary Roles and Accountabilities:

  • Drives the Organisation’s strategy on investments;
  • Creates new strategic and tactical investment portfolio and identifies the best execution methods for those investments.
  • Recommends investments, monitors the performance of investments, ensuring ZCCM-IH’s objectives are met and the strategic and financial goals achieved
  • Effectively communicate the investment policy and portfolio decisions
  • Identify the key investment projects for the Financial Year and develops Business Plans, thereof
  • Oversees the Company’s Financial investment analysis in investee companies and other sectors and conducts independent research to determine their viability
  • Maintains the financial analysis tool and tracks the trends on all investments.
  • Develops and submits financial analysis reports on each investment/ project for decision making
  • Leads in the monitoring of the performance for the investee companies; subsidiaries and other investments
  • Develops framework for decisions about the portfolio management strategies    used for investment purposes,
  • Leads processes for all portfolio management decisions and implementation, including asset selection, portfolio rebalancing
  • Responsible for overseeing portfolio allocation levels under various market conditions
  • Leads the construction and management processes for all portfolio models, including ongoing tactical adjustments as necessary
  • Promotes and establishes good working relationships with stakeholders and develop alliances that add value to the Business
  • Maintains good relationship in the financial sector to remain fully informed on various sources of finance
  • Actively monitors the social economic trends in the market to regularly align the funding program as per market norms and requirements
  • Leads and coordinates a team of highly qualified professionals in portfolio of base metals and legacy; industrial minerals; precious metals and minerals and energy and mineral beneficiation management
  • Responsible for the investments papers that go to the Investments Committee of the Board (ICB)
  • Leads and coordinates the Investment Team Day to day activities, including allocation of time and research resources and the optimization of a team-specific budget
  • Establish and monitor staff performance and development goals, assign accountabilities, set objectives, establish priorities, conduct annual performance appraisals and staff discipline
  • Evaluate project proposals/ investment ideas
  •  Conducts detailed feasibility studies for investment evaluation of the project and developing, as well as presenting investment proposals for internal approval of the Investment Committee
  • Ensures that projects are efficiently and effectively managed according to the agreed timescale and budget
  • Monitors investment performance through project progress and maintains alignment with project and budget
  • Liaises with the risk function on risk management issues that directly impact the strategic direction of the company investments.
  • Manages the funds placements with financial institutions
  • Reviews treasury reports such as maturity, liquidity mismatch, interest risk gap analysis risk exposure, and concentration risk reports to enable management assess exposure to various risks in the operations sectors
  • Monitor subsidiary businesses to ensure that they efficiently and effectively provide needed products and services while staying within budgetary limits, investment performance targets and operational goals
  • Effectively mobilises human, financial, technical and material resources to enhance implementation of all investment projects in ZCCM -IH
Job Requirements

Relevant Qualifications

 

Considerable competences at senior management level are required to understand and apply advanced policies, practices, procedures, concepts and principles in order to effectively perform in this role.

  • General Certification of Education (GCE) or equivalent with Credit or Better in Five (5) subjects, Mathematics and English included
  • Degree in Economics/ Accounting or equivalent.
  • ACCA/ CIMA /CFA or equivalent or business-related fields.
  • Master’s Degree in a relevant field
  • Relevant Professional Certification
  • Membership of relevant Professional Body
  • Professional Work Experience
  • Not less than 10 Years work experience in a busy and complex work environment of which 5 years must be at Management level.
  • High level experience in stakeholder management.
  • Proven written and oral skills and ability to distil and communicate complex matters at the highest levels.
  • Group holding company experience will be an added advantage.

 

Work Hours: 8

Experience in Months: 120

Level of Education: bachelor degree

Job application procedure

  • Applications clearly marked ‘CHIEF INVESTMENTS OFFICER’ together with copies of certificates and a detailed curriculum vitae should reach the undersigned not later than 21st April 2025. Applications should be addressed to the Chief Executive Officer.
  • To apply for this job please visit zccmjobs.mcidirecthire.com.

 

All Jobs | QUICK ALERT SUBSCRIPTION

Job Info
Job Category: Management jobs in Zambia
Job Type: Full-time
Deadline of this Job: Monday, April 21 2025
Duty Station: Lusaka | Lusaka | Zambia
Posted: 10-04-2025
No of Jobs: 1
Start Publishing: 10-04-2025
Stop Publishing (Put date of 2030): 10-04-2066
Apply Now

Caution: Never Pay Money in a Recruitment Process.

Some smart scams can trick you into paying for Psychometric Tests.
60.348MBMemory Usage413msRequest Duration
Joomla! Version4.4.10
PHP Version8.1.32
Identityguest
Response200
Templatejl_education_pro
Database
Server
mysql
Version
10.5.29-MariaDB
Collation
latin1_swedish_ci
Conn Collation
utf8mb4_general_ci
$_GET
[]
$_POST
[]
$_SESSION
array:1 [ "joomla" => "***redacted***" ]
$_COOKIE
array:1 [ "1deb24708f7a51ca02b447b7f6862276" => "3742a6517a3cf6b203373f2ba9717956" ]
$_SERVER
array:64 [ "USER" => "greatzambiajobs" "HOME" => "/home/greatzambiajobs" "SCRIPT_NAME" => "/in...
session
array:3 [ "counter" => 2 "timer" => array:3 [ "start" => 1746815674 "last" => 1746815674...
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.greatzambiajobs.com/how-to-app...
JSItemid
"190"
  • afterLoad (4.12MB) (26.53ms)
  • afterInitialise (11.13MB) (75.26ms)
  • afterRoute (5.06MB) (23.61ms)
  • beforeRenderComponent com_jsjobs (10.12KB) (159μs)
  • afterRenderComponent com_jsjobs (3.18MB) (29.21ms)
  • Before Access::preloadComponents (all components) (255.64KB) (4.63ms)
  • After Access::preloadComponents (all components) (132.72KB) (851μs)
  • Before Access::getAssetRules (id:1 name:root.1) (3.95KB) (11μs)
  • After Access::getAssetRules (id:1 name:root.1) (26.2KB) (224μs)
  • afterDispatch (2.35MB) (56.66ms)
  • afterRender (31.56MB) (195ms)
  • 1 x afterRender (31.56MB) (47.16%)
    194.64ms
    1 x afterInitialise (11.13MB) (18.23%)
    75.26ms
    1 x afterDispatch (2.35MB) (13.73%)
    56.66ms
    1 x afterRenderComponent com_jsjobs (3.18MB) (7.08%)
    29.21ms
    1 x afterLoad (4.12MB) (6.43%)
    26.53ms
    1 x afterRoute (5.06MB) (5.72%)
    23.61ms
    1 x Before Access::preloadComponents (all components) (255.64KB) (1.12%)
    4.63ms
    1 x After Access::preloadComponents (all components) (132.72KB) (0.21%)
    851μs
    1 x After Access::getAssetRules (id:1 name:root.1) (26.2KB) (0.05%)
    224μs
    1 x beforeRenderComponent com_jsjobs (10.12KB) (0.04%)
    159μs
    1 x Before Access::getAssetRules (id:1 name:root.1) (3.95KB) (0%)
    11μs
89 statements were executed, 23 of which were duplicates, 66 unique16ms350.25KB
  • SELECT @@SESSION.sql_mode;63μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `icop0_session` WHERE `session_id` = ?95μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `icop0_session` WHERE `session_id` = :session_id LIMIT 194μs1.63KBParams/libraries/src/Session/MetadataManager.php:187Copy
  • UPDATE `icop0_session` SET `guest` = :guest , `time` = :time , `userid` = :user_id , `username` = :username , `client_id` = :client_id WHERE `session_id` = :session_id91μs992BParams/libraries/src/Session/MetadataManager.php:316Copy
  • SELECT `id`,`rules` FROM `icop0_viewlevels`74μs1.55KB/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` = :guest96μs1.64KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `value` FROM `icop0_admintools_storage` WHERE `key` = 'cparams'82μs856B/administrator/components/com_admintools/src/Helper/Storage.php:120Copy
  • SELECT `option`,`view`,`query` FROM `icop0_admintools_wafexceptions`73μs960B/plugins/system/admintools/src/Utility/Cache.php:196Copy
  • SELECT `params` FROM `icop0_extensions` WHERE `type` = 'plugin' AND `folder` = 'system' AND `element` = 'admintools'158μs2.09KB/plugins/system/admintools/src/Utility/RescueUrl.php:324Copy
  • SELECT * FROM icop0_rsform_config194μs1.5KB/administrator/components/com_rsform/helpers/config.php:52Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'level'100μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'active_cron'102μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'cron_next'56μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'queue_type'54μs856B/plugins/system/acymtriggers/acymtriggers.php:639Copy
  • SELECT *,(subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-Chief-Investments-Officer-CIO-job-at-ZCCM-Investments-Holdings-PLC-75312%2F')=1) inSub FROM icop0_jlexblock WHERE ((mt_fullsite=1 AND mt_index=1) OR ((`sef_link`='%2Fjobs%2Fjob-detail%2Fjob-Chief-Investments-Officer-CIO-job-at-ZCCM-Investments-Holdings-PLC-75312%2F' OR (subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-Chief-Investments-Officer-CIO-job-at-ZCCM-Investments-Holdings-PLC-75312%2F')=1)) AND mt_fullsite=0)) AND published=1 ORDER BY mt_area DESC,id ASC196μs4.23KB/plugins/system/jlexblock/jlexblock.php:150Copy
  • SELECT *,(subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-Chief-Investments-Officer-CIO-job-at-ZCCM-Investments-Holdings-PLC-75312%2F')=1) inSub FROM icop0_jlexblock WHERE ((mt_fullsite=1 AND mt_index=1) OR ((`sef_link`='%2Fjobs%2Fjob-detail%2Fjob-Chief-Investments-Officer-CIO-job-at-ZCCM-Investments-Holdings-PLC-75312%2F' OR (subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-Chief-Investments-Officer-CIO-job-at-ZCCM-Investments-Holdings-PLC-75312%2F')=1) OR `list_var` LIKE '%com_jsjobs%') AND mt_fullsite=0)) AND published=1 ORDER BY mt_area DESC,id ASC265μs4.25KB/plugins/system/jlexblock/jlexblock.php:150Copy
  • 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.id222μs3.7KB/libraries/gantry5/src/classes/Gantry/Joomla/StyleHelper.php:69Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'default'351μs3.94KB/components/com_jsjobs/models/configurations.php:64Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'260μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'social'202μs1.13KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'default'270μs3.94KB/components/com_jsjobs/models/configurations.php:64Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'206μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'default_login_from'68μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'visitor_can_edit_job'61μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'160μ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 = 75312473μs92.03KB/components/com_jsjobs/models/job.php:1579Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'151μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • UPDATE `icop0_js_job_jobs` SET hits = hits + 1 WHERE id = 75312288μs48B/components/com_jsjobs/models/job.php:1588Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'230μs992B/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE published = 1 AND fieldfor = 2 ORDER BY ordering214μs4.52KB/components/com_jsjobs/models/customfields.php:59Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'221μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'218μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE published = 1 AND fieldfor = 1 ORDER BY ordering233μs15.48KB/components/com_jsjobs/models/customfields.php:59Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'221μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'listjob'225μs1.38KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'companydefaultlogopath'66μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'data_directory'55μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'listjob'208μs1.38KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'197μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'companydefaultlogopath'50μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'data_directory'46μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'jobcategory' AND fieldfor = 2128μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'jobtype' AND fieldfor = 2120μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE field = 'ufield917' AND isuserfield = 1 AND userfieldtype != 'termsandconditions'480μ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'516μs4.28KB/administrator/components/com_jsjobs/include/classes/customfields.php:645Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'noofjobs' AND fieldfor = 2171μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'startpublishing' AND fieldfor = 2118μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'stoppublishing' AND fieldfor = 2119μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'215μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'default'307μs3.94KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'231μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE isvisitorpublished = 1 AND fieldfor = 14 ORDER BY ordering142μ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)617μs8.25KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT `id` FROM `icop0_rstbox` WHERE `published` = 1 AND `testmode` = 090μs920B/administrator/components/com_rstbox/EngageBox/Boxes.php:45Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 22123μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 24104μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 2877μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 38134μs73.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 40167μ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` = 0199μ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.lft414μ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.lft226μ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.lft405μs2.3KB/libraries/gantry5/src/classes/Gantry/Framework/Menu.php:791Copy
  • SELECT * FROM icop0_jmap_metainfo WHERE `linkurl` = 'https://www.greatzambiajobs.com/jobs/job-detail/job-Chief-Investments-Officer-CIO-job-at-ZCCM-Investments-Holdings-PLC-75312' AND `published` = 1128μs1.2KB/plugins/system/jmap/jmap.php:818Copy
  • SELECT * FROM icop0_jmap_canonicals WHERE `linkurl` = 'https://www.greatzambiajobs.com/jobs/job-detail/job-Chief-Investments-Officer-CIO-job-at-ZCCM-Investments-Holdings-PLC-75312'120μs8.94KB/plugins/system/jmap/jmap.php:920Copy
  • SELECT * FROM icop0_acym_configuration234μs4.88KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_list WHERE type = 'standard'91μs2.3KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_field80μs2.33KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_form WHERE active = 1 AND type != 'shortcode'82μ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` = 1104μs1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT * FROM `icop0_extensions` WHERE `element` = 'com_gsd' AND `type` = 'component'201μs3.78KB/plugins/system/nrframework/NRFramework/Extension.php:160Copy
  • SHOW FULL COLUMNS FROM `icop0_gsd_config`278μs1.92KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `icop0_gsd_config` WHERE `name` = 'config'69μ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 desc216μs2.08KB/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SHOW FULL COLUMNS FROM `icop0_users`271μs2.2KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `icop0_users` WHERE `id` = :userid144μ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` = :muserid126μs1.68KBParams/libraries/src/Table/User.php:132Copy
  • SELECT * FROM icop0_jmap_headings WHERE `linkurl` = 'https://www.greatzambiajobs.com/jobs/job-detail/job-Chief-Investments-Officer-CIO-job-at-ZCCM-Investments-Holdings-PLC-75312'119μ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` = 151μs1008B/plugins/system/jmap/jmap.php:508Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` LIKE "%regacy" OR `name` LIKE "%\_sub"193μs856B/plugins/system/acymtriggers/acymtriggers.php:430Copy
  • SHOW TABLES688μs8.82KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:678Copy
  • SELECT * FROM icop0_acym_plugin134μs2.14KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT * FROM icop0_acym_plugin82μ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`93μs1.36KB/administrator/components/com_acym/libraries/joomla/database.php:36Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'company_seo'126μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'214μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT name AS col FROM `icop0_js_job_companies` WHERE id = 345872μs856B/components/com_jsjobs/models/company.php:1832Copy
  • SELECT `session_id` FROM `icop0_session` WHERE `session_id` = ?171μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `icop0_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?121μs912BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy