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='5FE27797'
    

Location and Job Title:

Lead Teacher, Infant Room
Bonnie & Donald Dwares JCC of the Jewish Alliance of Greater Rhode Island
401 Elmgrove Ave
Providence, RI 02906

Principal Responsibilities:

The Jewish Alliance of Greater Rhode Island is seeking extraordinary Early Childhood Educators to join our team as:

• Lead Teacher, Infant Room
• Assistant Teacher, Infant Room

Our David C. Isenberg Family Early Childhood Center is a NAEYC and BrightStars accredited infant toddler program and preschool committed to providing a high quality, child-centered developmental program. Our unique program includes age appropriate educational and Judaic experiences in a secure and loving atmosphere that fosters cognitive, physical, emotional and social growth. We strive to provide quality care and education for children ages 3 months to 5 years.

Full Time staff members enjoy impressive and plentiful benefits which include:

• Medical, Dental and Vision Insurance
• Life insurance and long-term disability insurance
• Defined contribution pension plan
• 401k, 403b
• Flexible spending accounts
• Free deluxe fitness membership
• Generous amount of paid time off
• Free freshly made vegetarian and kosher daily lunch

Minimum Qualifications:

Energetic, nurturing and motivated individuals are strongly encouraged to apply. If you are interested in joining our team please use the link below to apply:

• A current resume
• A page listing three references including: names, titles, phone numbers (and or) email addresses
• A cover letter expressing why you would make a great addition to our teaching team!

Salary:

$25,000 - $35,000

Agency Information:

The Jewish Alliance of Greater Rhode Island is proud to be an equal opportunity employer. We celebrate diversity and are committed to providing an environment of mutual respect where equal employment opportunities are available to all regardless of race, color, religion, pregnancy, national origin, age, ability, sexual orientation, gender, gender identity, military/veteran status or any other characteristic protected by law. We sincerely believe that diversity and inclusion among our staff is critical to our success as an organization.