select * from jccworks.dbo.tbl_positionregion

select * from jccworks.dbo.tbl_PositionCategory order by positioncategoryname

        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='B4DF0328'
    

Location and Job Title:

Floater Teacher
Shorefront YM-YWHA of Brighton Manhattan Beach
3300 Coney Island Ave
Brooklyn, NY 11235

Principal Responsibilities:

Supervise students in the event that their teacher is unable to lead the classroom

Ensure student safety and engagement

Implement the regular teacher lesson plans

Collaborate with other staff members

Minimum Qualifications:

BA in Education/study plan eligible

Salary:

$35,000 - $45,000

Agency Information:

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.