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='54A3479B'
    

Location and Job Title:

Community Growth & Operations Manager
JCC of Stamford
1035 Newfield Ave
Stamford, CT 06905

Principal Responsibilities:

The Community Growth & Operations Manager is the operational engine and membership ambassador for our multi-site community. This role is responsible for driving membership sales and retention while delivering exceptional customer service and member experience. Acting as the ultimate integrator, you will keep the professional team (especially the Lead Rabbi) on task, ensure flawless site logistics, and lead our campaign to grow the TBC community from 70 to a vibrant hub of 250+ families.

Reporting Structure & Time Allocation

• Reports to JCC Leadership matrix, functioning as the primary operational partner to the Lead Rabbi.
• Time Split: Approximately 90% dedicated to TBC site operations, membership growth, and administrative coordination, and 10% dedicated to serving as the liaison to JCC HQ.

Key Responsibilities

• Membership Growth: Track inquiries from perspective, new and existing members. Cross-sell programs and services to members, identifying individual needs and connecting them to appropriate departments and offerings.
  
  
• Operational Integration: Serve as the primary liaison to JCC HQ, facilitating seamless coordination with centralized Marketing, Development, and Finance departments to ensure TBC is fully supported without duplicating back-office efforts.
• Team Coordination: Coordinate the master calendar and keep the professional team aligned across the TBC and JCC campuses. Manage multiple tasks efficiently in a fast-paced environment.
  
  
• Data & Administration: Process all new member applications accurately and maintain up-to-date member information in CRM database.
  
  
• Customer Experience: Create a positive, welcoming environment that reflects the warm community culture of the JCC. Ensure members maximize their experience by understanding membership benefits and engaging in meaningful conversations.
  
  

Minimum Qualifications:

• 2+ years of retail service or sales experience; previous consultative sales experience in a membership-driven organization a plus.
  
  
• Strong knowledge of Microsoft Office, email, internet, and CRM database systems.
  
  
• Highly organized, self-directed, and capable of managing multiple timelines across a multi-year process.
  
  
• Positive, warm, friendly, and personable attitude with ability to connect with diverse populations.
  
  

Salary:

$55,000 - $65,000

Agency Information:

The Stamford Jewish Community Center is a cultural, educational and recreational center, offering exceptional programs, classes and special events designed to enrich the mind, body and spirit. While we are driven by the Jewish values of welcoming guests, kindness, respect, and communal responsibility, we warmly welcome people of all ages, faiths, ethnicities and backgrounds.