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

Location and Job Title:

Afterschool Counselors
Michael-Ann Russell JCC
18900 NE 25th Ave
North Miami Beach, FL 33180

Principal Responsibilities:

The Michael-Ann Russell JCC is seeking highly motivated individuals for after-school counselor positions.

Sumit your resume to: Moisesb@marjcc.org

Primary Responsibilities

• Works directly with an assigned group of children as the group's leader.
• Following a daily schedule
• Actively participate in activities
• Assisting with homework for K-5^th grade
• Maintain positive working relationship with co-counselor.
• Assist administrators with activities, including maintaining control, safety and healthy of the participants.
• Handle child to child problems.
• Arrive at afternoon no later than 1:00 p.m.
• Maintain a professional attitude and loyalty to the program at all times.
• Incorporate Jewish values and ethics and provide safety in all activities.
• Abide by all policies, standards and objectives of the MARJCC and the After-School Program, including but not limited to our policies of no smoking, no alcohol and no drugs.

Hours:

• Program run for 4 hours a day starting as early as 1pm.
• Program runs M-F on regular days of school and also when school is out by offering mini camps from 9am to 6pm

Minimum Qualifications:

Staff should posses:

• Excellent communication and verbal skills
• Skills and energy to work in a fast paced team environment
• Ability to serve as a role model
• Experience and competencies in working in a multicultural environment

Job Qualifications

• Minimum age requirement of 16 years
• Current HS student or beyond
• Minimum 1 year working with school age children

Salary:

$25,000 - $35,000

Agency Information:

The Michael-Ann Russell Jewish Community Center/Sanford L. Ziff Campus is dedicated to the enrichment of Jewish life and fosters the spiritual, emotional, and physical development of its individual members through all of life's stages and circumstances.