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
Are you currently working in the Pensions administration industry and you want to advance your career? Do you want to work for one of the UK's leading Pensions administration and consultancy firms; in their busy, vibrant Solihull offices? Do you want to work for a firm that rewards their staff; regularly offering new challenges and variety... More