Compliance Officer job at Absa
Website :
889 Days Ago
Linkedid Twitter Share on facebook

Vacancy title: Compliance Officer

[ Type: FULL TIME , Industry: Banking , Category: Management Officer ]

Jobs at: Absa


Deadline of this Job:
15 July 2022  

Duty Station:
Within Zambia , Lusaka , South - Central Africa

Summary
Date Posted: Thursday, July 14, 2022 , Base Salary: Not Disclosed

Similar Jobs in Zambia
Learn more about Absa
Absa jobs in Zambia

JOB DETAILS:
Job Summary
To work within a pressurized and high performing environment, to ensure that the Absa business is fully compliant with all regulations and that conduct, and reputational risks are proactively monitored and mitigated.
Oversee implementation of a compliance risk management plan that is fit-for-purpose. The plan requires an effective assessment of the regulatory, conduct and reputational risks in the business and the management thereof through effective implementation of governance, policies and standards, training, monitoring and ongoing assurance. This requires the compliance officer to be a trusted partner to the business whilst maintaining independence as a second line of defense.
The role also requires the incumbent to be proactive in anticipating and addressing risks, driving adherence to the Values of the Group, and being a role model for Compliance across the industry.
Manage regulatory relations and engagements in respect of the Absa Life Zambia business and work together with the business, Head of Regulatory Relations, and the Head of AFS Compliance on matters pertaining to the Absa Life Zambia business. Support with board engagements, board reporting, advisory compliance services, strategic projects, and reporting into the business MANCO’s. EXCO’s ERC’s and boards.

Mandatory Responsibilities and Competencies
• Assume the Compliance Officer role and be directly accountable to the board, the regulators and ensure that the Absa Life Zambia business is fully compliant with all laws/regulations, applicable policies, and that conduct, and reputational risks are proactively monitored and mitigated.
• Oversee implementation of a compliance risk management plan that is fit-for-purpose. Assessment of the regulatory, conduct and reputational risks in the business and the management thereof through effective implementation of governance, policies and standards, training, monitoring and ongoing assurance.
• Support the Managing Director and Head of AFS Compliance in the management of the compliance, conduct and regulatory risk.
• Manage regulatory relations and engagements with the regulators in respect of the business and work together with the Head of Regulatory Relations and the Head of AFS Compliance on matters pertaining to the Absa Life Zambia business.
• AFS Business Management
• Support the AFS Head of Compliance through development of and execution of the Compliance strategy
• Provide input to enhance the Compliance methodology
• Provide input into the RBB regulatory, conduct and reputation risk environment
• Share knowledge across the RBB business
• Compliance Advisory
• Drive the right behaviour, specifically adherence to the organizational Values, in the business through effective standard setting, advice, training, assurance, escalation, reporting and engagement.
• Clearly communicate the role and objectives of Compliance to the business.
• Maintain constructive regular engagement with relevant stakeholders, including business, other functions (including second and third lines of defence) and regulators.
• Provide accurate and timely compliance and regulatory advice to the business as a second line of defence.
• Provide relevant Compliance risk information reporting to management.
• Report and escalate policy and regulatory breaches and conduct or regulatory issues to appropriate stakeholders, which may include business management and regulators.
• Maintain a compliance training plan for the business and ensure effective execution of training, including face-to-face and e-learning.
Deployment of policies.
• Manage new regulatory requirements by evaluating regulations (local and international) identified as relevant to the business and provide an impact analysis relevant to the business. Address impacts, including policy amendments, business notifications and provision of training.
• Keep Business appraised of notifications distributed by the regulator impacting the business.
• Stakeholder Management
• Be the point of entry for interactions with each regulator regarding the business.
• Position and communicate compliance policies, requirements, and initiatives with the relevant stakeholders
• Actively drive a stakeholder management plan for all compliance and regulatory matters affecting the business
• Liaise with senior executive stakeholders and stakeholder groups
• Risk Management
• Be the accountable key conduct risk owner for the business
• Perform on-going monitoring of the business through stakeholder engagement, compilation, and assessment of management information, and tracking and analysis of issues.
• Maintain detailed conduct risk assessments for the business, identifying all regulations and assessing the regulatory risk.
• Maintain and assess regulatory risk MI for the business.
• Perform effective monthly assurance testing on key regulatory risks of the business.
• Review and provide input on the Compliance Risk Review coverage for the business. Review the coverage plan, the scope of each review, and conclusions and final report of each review.
• Assess the overall testing coverage on regulatory risk for the business and address deficiencies
• Governance
• Serve on appropriate risk and governance forums in the business and Compliance
• Report to relevant governance forums with overall conclusions on conduct, regulatory and reputational risks.

Education
• Bachelor’s Degree: Business, Commerce and Management Studies (Required)

Job Experience: No Requirements

Work Hours: 8


Level of Education:
Bachelor Degree

Job application procedure
Click here to apply

All Jobs

QUICK ALERT SUBSCRIPTION

Job Info
Job Category: Corporate / Organisation Officer jobs in Zambia
Job Type: Full-time
Deadline of this Job: 15 July 2022
Duty Station: Lusaka
Posted: 14-07-2022
No of Jobs: 1
Start Publishing: 14-07-2022
Stop Publishing (Put date of 2030): 14-07-2066
Apply Now

Caution: Never Pay Money in a Recruitment Process.

Some smart scams can trick you into paying for Psychometric Tests.
66.393MBMemory Usage371msRequest Duration
Joomla! Version4.4.9
PHP Version8.1.31
Identityguest
Response200
Templatejl_education_pro
Database
Server
mysql
Version
10.5.27-MariaDB
Collation
latin1_swedish_ci
Conn Collation
utf8mb4_general_ci
$_GET
[]
$_POST
[]
$_SESSION
array:1 [ "joomla" => "***redacted***" ]
$_COOKIE
[]
$_SERVER
array:63 [ "USER" => "greatzambiajobs" "HOME" => "/home/greatzambiajobs" "SCRIPT_NAME" => "/in...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1734684439 "last" => 1734684439...
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) (21.69ms)
  • afterInitialise (11.9MB) (67.85ms)
  • afterRoute (10.33MB) (52.25ms)
  • beforeRenderComponent com_jsjobs (10.08KB) (154μs)
  • afterRenderComponent com_jsjobs (2.84MB) (25.89ms)
  • Before Access::preloadComponents (all components) (239.6KB) (4.41ms)
  • After Access::preloadComponents (all components) (132.72KB) (676μs)
  • Before Access::getAssetRules (id:1 name:root.1) (3.95KB) (13μs)
  • After Access::getAssetRules (id:1 name:root.1) (26.2KB) (232μs)
  • beforeRenderRawModule mod_gantry5_particle (Career Guide) (3.66MB) (35.25ms)
  • afterRenderRawModule mod_gantry5_particle (Career Guide) (18.25MB) (58.58ms)
  • beforeRenderModule mod_gantry5_particle (Career Guide) (720B) (5μs)
  • afterRenderModule mod_gantry5_particle (Career Guide) (9.93KB) (256μs)
  • afterDispatch (75.57KB) (90μs)
  • afterRender (11MB) (102ms)
  • 1 x afterRender (11MB) (27.64%)
    102.46ms
    1 x afterInitialise (11.9MB) (18.3%)
    67.85ms
    1 x afterRenderRawModule mod_gantry5_particle (Career Guide) (18.25MB) (15.8%)
    58.58ms
    1 x afterRoute (10.33MB) (14.09%)
    52.25ms
    1 x beforeRenderRawModule mod_gantry5_particle (Career Guide) (3.66MB) (9.51%)
    35.25ms
    1 x afterRenderComponent com_jsjobs (2.84MB) (6.99%)
    25.89ms
    1 x afterLoad (4.12MB) (5.85%)
    21.69ms
    1 x Before Access::preloadComponents (all components) (239.6KB) (1.19%)
    4.41ms
    1 x After Access::preloadComponents (all components) (132.72KB) (0.18%)
    676μs
    1 x afterRenderModule mod_gantry5_particle (Career Guide) (9.93KB) (0.07%)
    256μs
    1 x After Access::getAssetRules (id:1 name:root.1) (26.2KB) (0.06%)
    232μs
    1 x beforeRenderComponent com_jsjobs (10.08KB) (0.04%)
    154μs
    1 x afterDispatch (75.57KB) (0.02%)
    90μs
    1 x Before Access::getAssetRules (id:1 name:root.1) (3.95KB) (0%)
    13μs
    1 x beforeRenderModule mod_gantry5_particle (Career Guide) (720B) (0%)
    5μs
125 statements were executed, 23 of which were duplicates, 102 unique18.56ms287.65KB
  • SELECT @@SESSION.sql_mode;36μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `icop0_session` WHERE `session_id` = ?101μs1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `icop0_session` WHERE `session_id` = :session_id LIMIT 157μ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)229μs944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `id`,`rules` FROM `icop0_viewlevels`54μ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` = :guest106μs1.64KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `value` FROM `icop0_admintools_storage` WHERE `key` = 'cparams'97μs856B/administrator/components/com_admintools/src/Helper/Storage.php:120Copy
  • SELECT `option`,`view`,`query` FROM `icop0_admintools_wafexceptions`46μs960B/plugins/system/admintools/src/Utility/Cache.php:196Copy
  • SELECT `params` FROM `icop0_extensions` WHERE `type` = 'plugin' AND `folder` = 'system' AND `element` = 'admintools'145μs2.09KB/plugins/system/admintools/src/Utility/RescueUrl.php:324Copy
  • SELECT * FROM icop0_rsform_config97μs1.5KB/administrator/components/com_rsform/helpers/config.php:52Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'level'55μs856B/plugins/system/acymtriggers/acymtriggers.php:516Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'active_cron'45μs856B/plugins/system/acymtriggers/acymtriggers.php:516Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'cron_next'46μs856B/plugins/system/acymtriggers/acymtriggers.php:516Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` = 'queue_type'42μs856B/plugins/system/acymtriggers/acymtriggers.php:516Copy
  • SELECT *,(subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-Compliance-Officer-job-at-Absa-36790%2F')=1) inSub FROM icop0_jlexblock WHERE ((mt_fullsite=1 AND mt_index=1) OR ((`sef_link`='%2Fjobs%2Fjob-detail%2Fjob-Compliance-Officer-job-at-Absa-36790%2F' OR (subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-Compliance-Officer-job-at-Absa-36790%2F')=1)) AND mt_fullsite=0)) AND published=1 ORDER BY mt_area DESC,id ASC191μs4.23KB/plugins/system/jlexblock/jlexblock.php:150Copy
  • SHOW TABLES718μs8.82KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:678Copy
  • SELECT * FROM icop0_acym_configuration228μs7.38KB/administrator/components/com_acym/libraries/joomla/database.php:32Copy
  • SELECT * FROM icop0_acym_plugin65μs2.13KB/administrator/components/com_acym/libraries/joomla/database.php:32Copy
  • SELECT * FROM icop0_acym_plugin WHERE folder_name = 'acychecker' LIMIT 1132μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:47Copy
  • SELECT * FROM icop0_acym_plugin WHERE folder_name = 'acymailer' LIMIT 170μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:47Copy
  • SELECT * FROM icop0_acym_plugin WHERE folder_name = 'amazon' LIMIT 160μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:47Copy
  • SELECT * FROM icop0_acym_plugin WHERE folder_name = 'article' LIMIT 169μs2.09KB/administrator/components/com_acym/libraries/joomla/database.php:47Copy
  • SELECT * FROM icop0_acym_plugin WHERE folder_name = 'birthday' LIMIT 171μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:47Copy
  • SELECT * FROM icop0_acym_plugin WHERE folder_name = 'brevo' LIMIT 189μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:47Copy
  • SELECT * FROM icop0_acym_plugin WHERE folder_name = 'createuser' LIMIT 170μs2.09KB/administrator/components/com_acym/libraries/joomla/database.php:47Copy
  • SELECT `groups`.*, `groups`.title AS text, `groups`.id AS `value` FROM icop0_usergroups AS `groups`56μs1.36KB/administrator/components/com_acym/libraries/joomla/database.php:32Copy
  • SELECT * FROM icop0_acym_plugin WHERE folder_name = 'elasticemail' LIMIT 174μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:47Copy
  • SELECT * FROM icop0_acym_plugin WHERE folder_name = 'forward' LIMIT 163μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:47Copy
  • SELECT * FROM icop0_acym_plugin WHERE folder_name = 'mailgun' LIMIT 187μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:47Copy
  • SELECT * FROM icop0_acym_plugin WHERE folder_name = 'module' LIMIT 157μs2.09KB/administrator/components/com_acym/libraries/joomla/database.php:47Copy
  • SELECT * FROM icop0_acym_plugin WHERE folder_name = 'online' LIMIT 160μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:47Copy
  • SELECT * FROM icop0_acym_plugin WHERE folder_name = 'override' LIMIT 167μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:47Copy
  • SELECT * FROM icop0_acym_plugin WHERE folder_name = 'phpmail' LIMIT 157μs13.08KB/administrator/components/com_acym/libraries/joomla/database.php:47Copy
  • SELECT * FROM icop0_acym_plugin WHERE folder_name = 'postmark' LIMIT 157μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:47Copy
  • SELECT * FROM icop0_acym_plugin WHERE folder_name = 'qmail' LIMIT 167μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:47Copy
  • SELECT * FROM icop0_acym_plugin WHERE folder_name = 'segment' LIMIT 1103μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:47Copy
  • SELECT * FROM icop0_acym_plugin WHERE folder_name = 'sendgrid' LIMIT 158μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:47Copy
  • SELECT * FROM icop0_acym_plugin WHERE folder_name = 'sendinblue' LIMIT 1121μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:47Copy
  • SELECT * FROM icop0_acym_plugin WHERE folder_name = 'luecredentials' LIMIT 182μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:47Copy
  • SELECT * FROM icop0_acym_plugin WHERE folder_name = 'lueintegration' LIMIT 166μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:47Copy
  • SELECT * FROM icop0_acym_plugin WHERE folder_name = 'luetransactional' LIMIT 165μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:47Copy
  • SELECT * FROM icop0_acym_plugin WHERE folder_name = 'luelist' LIMIT 165μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:47Copy
  • SELECT * FROM icop0_acym_plugin WHERE folder_name = 'lueusers' LIMIT 162μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:47Copy
  • SELECT * FROM icop0_acym_plugin WHERE folder_name = 'luesender' LIMIT 159μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:47Copy
  • SELECT * FROM icop0_acym_plugin WHERE folder_name = 'luecampaign' LIMIT 162μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:47Copy
  • SELECT * FROM icop0_acym_plugin WHERE folder_name = 'luewebhooks' LIMIT 159μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:47Copy
  • SELECT * FROM icop0_acym_plugin WHERE folder_name = 'sendmail' LIMIT 162μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:47Copy
  • SELECT * FROM icop0_acym_plugin WHERE folder_name = 'smtp' LIMIT 167μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:47Copy
  • SELECT * FROM icop0_acym_plugin WHERE folder_name = 'statistics' LIMIT 166μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:47Copy
  • SELECT * FROM icop0_acym_plugin WHERE folder_name = 'subscriber' LIMIT 175μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:47Copy
  • SELECT * FROM icop0_acym_plugin WHERE folder_name = 'subscription' LIMIT 174μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:47Copy
  • SELECT * FROM icop0_acym_plugin WHERE folder_name = 'time' LIMIT 179μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:47Copy
  • SELECT * FROM icop0_acym_plugin WHERE folder_name = 'user' LIMIT 172μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:47Copy
  • SELECT * FROM icop0_acym_plugin WHERE folder_name = 'managetext' LIMIT 177μs2.08KB/administrator/components/com_acym/libraries/joomla/database.php:47Copy
  • SELECT *,(subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-Compliance-Officer-job-at-Absa-36790%2F')=1) inSub FROM icop0_jlexblock WHERE ((mt_fullsite=1 AND mt_index=1) OR ((`sef_link`='%2Fjobs%2Fjob-detail%2Fjob-Compliance-Officer-job-at-Absa-36790%2F' OR (subpath=1 AND LOCATE(sef_link, '%2Fjobs%2Fjob-detail%2Fjob-Compliance-Officer-job-at-Absa-36790%2F')=1) OR `list_var` LIKE '%com_jsjobs%') AND mt_fullsite=0)) AND published=1 ORDER BY mt_area DESC,id ASC210μ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.id147μs1.2KB/libraries/gantry5/src/classes/Gantry/Joomla/StyleHelper.php:69Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'default'356μs3.94KB/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'245μs1.13KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'default'249μs3.94KB/components/com_jsjobs/models/configurations.php:64Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'246μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'default_login_from'57μ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'211μ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 = 36790518μs28.03KB/components/com_jsjobs/models/job.php:1579Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'241μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • UPDATE `icop0_js_job_jobs` SET hits = hits + 1 WHERE id = 36790328μs48B/components/com_jsjobs/models/job.php:1588Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'282μs992B/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE published = 1 AND fieldfor = 2 ORDER BY ordering294μs4.52KB/components/com_jsjobs/models/customfields.php:59Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'201μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'241μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE published = 1 AND fieldfor = 1 ORDER BY ordering200μs4.48KB/components/com_jsjobs/models/customfields.php:59Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'250μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'listjob'252μs1.38KB/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'55μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'listjob'258μs1.38KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'192μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'companydefaultlogopath'56μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'data_directory'53μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'jobcategory' AND fieldfor = 2136μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'jobtype' AND fieldfor = 2132μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE field = 'ufield917' AND isuserfield = 1 AND userfieldtype != 'termsandconditions'490μ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 = 2180μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'startpublishing' AND fieldfor = 2125μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT fieldtitle FROM `icop0_js_job_fieldsordering` WHERE field = 'stoppublishing' AND fieldfor = 2181μs856B/components/com_jsjobs/models/customfields.php:198Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'211μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'default'208μs3.94KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'161μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT * FROM `icop0_js_job_fieldsordering` WHERE isvisitorpublished = 1 AND fieldfor = 14 ORDER BY ordering117μ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)425μs8.25KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT `id` FROM `icop0_rstbox` WHERE `published` = 1 AND `testmode` = 088μs936B/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` = 24211μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 28103μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 38118μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 39130μs1.97KB/administrator/components/com_rstbox/EngageBox/Box.php:242Copy
  • SELECT * FROM `icop0_rstbox` WHERE `id` = 40140μ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` = 0102μ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.lft255μ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.lft161μ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.lft302μ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-Compliance-Officer-job-at-Absa-36790' AND `published` = 1120μs1.2KB/plugins/system/jmap/jmap.php:762Copy
  • SELECT * FROM icop0_jmap_canonicals WHERE `linkurl` = 'https://www.greatzambiajobs.com/jobs/job-detail/job-Compliance-Officer-job-at-Absa-36790'56μs960B/plugins/system/jmap/jmap.php:864Copy
  • SELECT * FROM icop0_acym_list WHERE type = 'standard'141μs2.3KB/administrator/components/com_acym/libraries/joomla/database.php:32Copy
  • SELECT * FROM icop0_acym_field73μs2.33KB/administrator/components/com_acym/libraries/joomla/database.php:32Copy
  • SELECT * FROM icop0_acym_form WHERE active = 1 AND type != 'shortcode'77μs1.2KB/administrator/components/com_acym/libraries/joomla/database.php:32Copy
  • 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` = 178μs1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT * FROM `icop0_extensions` WHERE `element` = 'com_gsd' AND `type` = 'component'154μs3.78KB/plugins/system/nrframework/NRFramework/Extension.php:160Copy
  • SHOW FULL COLUMNS FROM `icop0_gsd_config`221μs1.92KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `icop0_gsd_config` WHERE `name` = 'config'89μ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 desc140μs2.08KB/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SHOW FULL COLUMNS FROM `icop0_users`266μs2.2KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `icop0_users` WHERE `id` = :userid86μ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` = :muserid147μs1.68KBParams/libraries/src/Table/User.php:132Copy
  • SELECT * FROM icop0_jmap_headings WHERE `linkurl` = 'https://www.greatzambiajobs.com/jobs/job-detail/job-Compliance-Officer-job-at-Absa-36790'60μs1.05KB/plugins/system/jmap/jmap.php:1079Copy
  • SELECT `original_text`, `target_text`, `original_text_regex`, `target_text_regex` FROM `icop0_jmap_text_replacements` WHERE `published` = 149μs1008B/plugins/system/jmap/jmap.php:465Copy
  • SELECT `value` FROM icop0_acym_configuration WHERE `name` LIKE "%regacy" OR `name` LIKE "%\_sub"188μs856B/plugins/system/acymtriggers/acymtriggers.php:218Copy
  • SHOW TABLES667μs8.82KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:678Copy
  • SELECT configvalue FROM `icop0_js_job_config` WHERE configname = 'company_seo'127μs856B/components/com_jsjobs/models/configurations.php:103Copy
  • SELECT * FROM `icop0_js_job_config` WHERE configfor = 'jobsharing'194μs1.02KB/components/com_jsjobs/models/configurations.php:82Copy
  • SELECT name AS col FROM `icop0_js_job_companies` WHERE id = 368257μs856B/components/com_jsjobs/models/company.php:1832Copy
  • SELECT `session_id` FROM `icop0_session` WHERE `session_id` = ?123μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `icop0_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?413μs912BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy