SELECT id,job_title,location,category,job_type,salary_from,salary_to,salary_text,job_of_the_week,full_job_description,job_logo FROM jobs WHERE 1=1 AND visible=1 AND ( ( expiry_date>=DATE(NOW()) ) or ( expiry_date IS NULL ) or ( expiry_date ='0000-00-00' ) ) AND ( ((language_code = '2') or (CONCAT('~', language_code, '~') LIKE '%~2~%')) or (CONCAT('~', language_code_fullhierarchy, '~') LIKE '%~2~%') ) AND (((location = '1427') or (CONCAT('~', location, '~') LIKE '%~1427~%')) or (CONCAT('~', location_fullhierarchy) LIKE '%~1427~%') ) AND visible = 1 ORDER BY job_of_the_week desc, id DESC
Do you want to work for one of the UK's leading Pensions administration and consultancy firms; in their busy, vibrant office?In this role you will be required to check the work of junior members within the team, and to delegate work to these team members to ensure deadlines are met, as well as coaching and training new staff... More