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

Location and Job Title:

Member Experience Associate
JCC of Stamford
1035 Newfield Ave
Stamford, CT 06905

Principal Responsibilities:

Member Experience Associates are the welcoming faces of the JCC of Stamford, responsible for delivering exceptional customer service and creating a positive, inclusive environment for all visitors. As integral member of the Member Services Team, this role ensures that every interaction reflects the JCC's commitment to community, respect, and excellence.

Minimum Qualifications:

Key responsibilities include:

• Greeting and assisting members, guests, and prospective members both in person and over the phone, providing information about programs, services, and membership options.
• Checking in members and guests using JCC procedures, ensuring smooth and efficient entry.
• Processing transactions accurately using JCC membership software, including class registrations, personal training sessions, private swimming lessons, and membership renewals.
• Managing reservations for group exercise classes and sports courts.
• Maintaining a clean and organized welcome desk area, replenishing informational materials as needed.
• Reporting maintenance and facility issues to appropriate staff to ensure a safe and pleasant environment.
• Performing additional clerical duties as required to support the Member Services Team.

Qualifications:

• Strong interpersonal skills with a positive, friendly, and professional demeanor.
• Excellent communication skills, both oral and written.
• Proficiency in Microsoft Office Suite (Word, Excel, Outlook) and the ability to learn new software applications.
• Ability to work independently, prioritize tasks, and handle multiple responsibilities simultaneously.
• Detail-oriented, dependable, and reliable.
• Flexible schedule with availability to work weekends and evenings as needed.
• High school diploma or equivalent; some college coursework preferred.
• Minimum of two years of customer service or related experience.

Compensation:
Competitive hourly wage.

To Apply:

Please submit your cover letter and resume to Shari Ziegelman at sziegelman@Stamfordjcc.org.

Salary:

$35,000 - $45,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.