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

Location and Job Title:

Community Engagement Manager
Louis S. Wolk Jewish Community Center of Greater Rochester
1200 Edgewood Ave
Rochester, NY 14618

Principal Responsibilities:

This position is a member of the CSL year-roundteam reporting directly to the Assistant Director of Development, and working directly with the CSL Advisory Council Development Committee and CSL Alumni Engagement. This role is responsible for supporting in the development and execution of the CSL development strategy to build a culture of philanthropy, develop relationships with key stakeholders, and build a robust alumni engagement program to raise funds for Camp Seneca Lake's capital, program, and scholarship needs.

In the summer, this individual will support CSL's community engagement efforts at camp including donor events, Visitors Day, Community Shabbat, Alumni Weekend, Family Camp, and the broader CSL community experience.

This is a full-time, year-round hybrid position, which would involve travel for community engagement work, and contribution to the summer program on the camp property. The candidate should expect to spend at least 50% of their time onsite at camp in the summer (and would have the option to be fully in residence at camp).

Minimum Qualifications:

Essential Duties and Responsibilities:

Development

• Partner with the Assistant Director of Development and Development Committee to sustain a cohesive development strategy including donor cultivation, prospecting, campaign goals, and ongoing stewardship
• Co-own the production of fundraising marketing materials including monthly newsletter, info sheets, and digital media
• Work with Assistant Director of Development to maintain CRM system for CSL donors, and support broader JCC development team with database support and onboarding as needed
• Attend weekly JCC development gift review and manage CSL gift processing in conjunction with Assistant Director of Development.
• Participate in regular strategy sessions with camp management team to identify and address ongoing areas of focus
• Partner with Assistant Director of Development and Development Committee chairs to execute fundraising campaigns
• Support the preparation of grant proposals and necessary reporting for confirmed grants
• Support fundraising among young alumni

Community engagement

• Plan and organize alumni engagement events serving as main point of contact for attendees and supporting program planning and execution
• Serve as the liaison for CSL Alumni Engagement, collaborating with the group to plan alumni gatherings in various cities
• Ensure alumni database in CampMinder is comprehensive and accurate
• Serve as the direct supervisor for summer Media Team, ensuring that media produced at camp can be leveraged for development and communications
• Supervise a Media/Social Media intern
• Oversee all community engagement efforts at camp in the summer including Visitor's Day, Community Shabbat, donor tours, etc. and support Alumni Weekend in conjunction with the Assistant Director of Development

Qualifications

Education and Experience:

• Bachelor's degree
• At least 2 years experience, preferably including in a development or sales-oriented role
• Experience with Jewish nonprofit camping preferred but not required

Key Competencies for Success:

• Proven administrative skills with the ability to efficiently and accurately handle a variety of responsibilities and a large volume of work, including experience managing a CRM system or donor database.
• Exceptional verbal and written communication skills - conveying warmth, enthusiasm, and an ability to build trust
• Ability to cultivate and steward positive relationships with stakeholders from diverse backgrounds
• Extremely well organized and able to prioritize work, problem solve and meet scheduled deadlines under pressure
• Willingness to work a flexible schedule with ability to be based at camp or travel to camp regularly during the summer (expect to spend at least 50% of time at camp in the summer) and work evenings and weekends as needed for events
• Interest in and/or a commitment to learning Jewish history, culture, and traditions in the context of the JCC and tikkun olam (repairing the world)

Computer Skills:

• Strong computer skills
• Competency in MS Office (Outlook, Excel, Word, Powerpoint) is a must
• Proficiency with donor software
• Ability to learn and utilize new software programs
• Experience with CampMinder is helpful but not required

Salary:

$45,000 - $55,000

Agency Information:

Benefits

• Health, Dental and Vision
• Retirement Plan, Life and Disability Insurance
• Employee Assistance Program
• Free membership to our Fitness and Aquatics Center