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

Location and Job Title:

Bus Driver - Part Time
Michael-Ann Russell JCC
18900 NE 25th Ave
North Miami Beach, FL 33180

Principal Responsibilities:

The Michael-Ann Russell Jewish Community Center (MARJCC) is a vibrant, inclusive community hub committed to enriching the lives of children and families through high-quality programs, education, and cultural experiences. We are seeking a reliable and caring Bus Driver to safely transport children to and from the JCC for afterschool programs.

Minimum Qualifications:

Responsibilities:

• Safely operate a JCC-owned bus along assigned routes to transport children to and from the JCC
• Ensure the safety of all passengers, following all traffic laws and JCC policies
• Conduct pre- and post-trip vehicle inspections and report any maintenance needs
• Maintain a clean and orderly bus environment
• Communicate professionally and positively with children, parents, and JCC staff
• Remain calm and responsive in emergency or unexpected situations
• Ensure accurate attendance and passenger logs as needed

Qualifications:

• Valid Florida CDL (Commercial Driver's License) with Passenger (P) and School Bus (S) endorsements
• Clean driving record and background check
• Previous experience transporting children preferred
• Reliable, punctual, and safety-conscious
• Strong interpersonal and communication skills
• Must be able to pass required drug screenings

Please send your resume to: moisesb@marjcc.org

Salary:

Under $25,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.