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

Location and Job Title:

Administrative Assistant (Part-Time)
JCC Metrowest
760 Northfield Ave
West Orange, NJ 07052

Principal Responsibilities:

JCC MetroWest is seeking a mindful, detail-oriented individual with strong organizational and communications skills and proficiency in Microsoft Office Suite and database functionality to be a part-time Administrative Assistant to both our CEO and our Director of Development.This is an opportunity to be part of an organization that provides educational, recreational, fitness & wellness, cultural and communal programs and activities to people of all abilities and at all stages in life.

All staff are expected to comply with the JCC Internal Service Standards of Respect, Kindness, Teamwork and Communication.

Essential Functions of the Job:

• Communicate directly, and on behalf of the CEO, with executives, J Board Members, partners, and stakeholders
• Draft staff and board communications
• Coordinate and attend monthly board meetings; take minutes and ensure timely distribution and follow-up
  • Evening work hours required on board meeting dates
• Oversee, maintain, and become proficient in data entry, organization, and functionality of various databases, including Donor Perfect, Bloomerang, Stripe, Boardable, Eventbrite, Brivo, CSI and Spectrum
  • Record incoming contributions and gifts in Donor Perfect database, send acknowledgment letter, and confirm in system that letter has been sent
  • Monthly maintenance of Donor Wall list for contributions and provide updates to Marketing Department
• Process monthly pledge invoices and annual tax letters
• Collaborate with Finance Department in reconciling financial data on development revenue and expenses, including monthly accounting reconciliations in Bloomerang, Stripe, and Donor Perfect
• Administer and process Tributes as occasions to celebrate or mourn arise: sending emails to Board members via Boardable with link to purchase a Tribute; reporting Tributes in Donor Perfect with correct coding; printing and sending Tributes

• Print and send staff birthday and anniversary cards on a monthly basis and get well cards as need arises

Other Responsibilities:

• In addition to attendance at monthly evening Board meetings, position may include other occasional evening/off-hours availability for other functions
• Other duties as assigned
• Proficiency in Microsoft Office Suite, Zoom, Teams, and database functionality; ability to learn other software programs
• Detail-oriented with strong organizational and communication skills
• Ability to work independently and with professional discretion
• Ability to work with a broad range of people including donors, J Board Members, staff and others

Physical Requirements:

• Regular/daily use of computer terminal screen; typing

Compensation: $25 per hour

Schedule: 15 - 20 hours per week during regular business hours and approximately one evening per month; specific schedule to be agreed upon.

Qualified candidates should email a cover letter and resume to the attention of Jon Staunch, Director of Development, at jstaunch@jccmetrowest.org.

All applicants for employment shall be considered without regard to race, religion, color, creed, national origin, ancestry, age, gender, sex, pregnancy, sexual orientation, gender identity, gender expression, marital status, physical or mental disability, medical condition, genetic information, military or veteran status, or any other classification protected by law.

Minimum Qualifications:

Qualifications:

• Proficiency in Microsoft Office Suite, Zoom, Teams, and database functionality; ability to learn other software programs
• Detail-oriented with strong organizational and communication skills
• Ability to work independently and with professional discretion
• Ability to work with a broad range of people including donors, J Board Members, staff and others

Salary:

Under $25,000

Agency Information:

Welcome to Your JCC!

JCC MetroWest has been at the center of our community for 149 years, bringing people together while providing educational, social, cultural and fitness programs.

Our main facility, the Leon & Toby Cooperman JCC, located in West Orange, NJ, and our 20-acre day-camp, Camp Deeny Riback, located in Flanders, NJ serve the Jewish communities west of NYC, including Essex, Morris, and Union counties.