Select
case
when
salaryrange like '%Under%'
or salaryrange like '%over%'
then
replace(replace(salaryrange,'Under ','Under $'),'Over ','Over $')
when
len(isnull(salaryrange,''))>0
then
'$'+replace(salaryrange,'- ','- $')
end as salaryrange,
(
select top 1
PositionCategoryID
from
jccworks.dbo.tbl_PositionDesired
where
positionid=p.positionid
order by
case
when PositionCategoryID='3E73' then 1 else 0
end desc
) as PositionCategoryID,
convert(varchar,dateentered,101) as dateentered,
p.*,
replace(j.jccname,'Not-Yet-Affiliated','') as jccname,
ja.address,
ja.address2,
ja.city,
ja.state,
ja.zip,
m.firstname,
m.lastname,
m.email,
m.jccid
from
jccworks.dbo.tbl_positions p
left join
jcca.dbo.tbl_jcc j on
p.jccid=j.jccid
left join
jcca.dbo.tbl_jccaddress ja on
j.jccid=ja.jccid
left join
jcca.dbo.vw_jccmasterfile3 m on
p.masterid=m.masterid
where
p.positionid='1A7D86B0'
Ukrainian Relief Case Manager
Shorefront YM-YWHA of Brighton Manhattan Beach
3300 Coney Island Ave
Brooklyn, NY 11235
The Ukrainian Relief Case Manager will be responsible for outreach, intake, assessment and referral services for clients who are in the US due to the war in Ukraine and seeking support and guidance regarding life in the US. Case Manager will provide support as newly arrived/arriving Ukrainians seek assistance in learning what may be available and how to access services (i.e., legal services, school access for their children, English as a Second Language, health care support, etc.) The Case Manager must be highly organized, empathetic, compassionate and eager to help vulnerable and often traumatized families. Case Manager will often be the first point of contact for many Ukrainian clients and establishing trust and assessing needs and available resources will be essential.
Responsibilities:
Requirements and Qualifications
To apply: email rozenberga@shorefronty.org
$45,000 - $55,000
Located in the heart of the largest Russian speaking community in North America, the Shorefront YM-YWHA has been committed to serving the diverse population of Brighton-Manhattan Beach for over half a century. A vibrant Jewish community center and social service agency, the Shorefront Y integrates immigrants into American society, inspires families and individuals to reconnect to their Jewish roots and provides a full array of cultural, educational, wellness, immigrant and human social services for people of all ages year-round.