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='1BC45B4C'
    

Location and Job Title:

Arts Journalism and Marketing Intern
Mandell JCC of Greater Hartford
335 Bloomfield Ave
West Hartford, CT 06117

Principal Responsibilities:

If you're curious, organized, and passionate about arts and community stories, and would like to build a new journalistic & marketing initiative from the ground up, we'd love to meet you!

This is an exciting, hands-on role for a creative, local college student majoring in Marketing, Journalism, Arts Administration, English, or Communications/Film/Media Studies. The position is 10-20 hours/week, and the ideal candidate will commit to at least one year. They will:

1. Collaborate with the Arts & Culture Director to produce a vibrant new monthly Arts & Culture e-newsletter highlighting the JCC's and Greater Hartford cultural events, opportunities, and profiles on local Jewish artists or art addressing issues relevant to the Jewish community.
2. Expand the Mandell JCC marketing department's social media presence, specifically with our developing Arts & Culture division.

Please email a resume, a cover letter outlining your interest and availability, and two writing samples to EStempler@mandelljcc.org

Compensation for this internship (paid or for academic credit) will be determined in consultation with the selected candidate and, if applicable, their academic institution. Includes Individual JCC Membership.

Apply by October 15, 2025

Minimum Qualifications:

• Current local college student pursuing a major in Marketing, Journalism, Arts Administration, Film, English, Graphic Design, Web Design, or a related field. Recent graduates are also welcome to apply!
• Strong writing and editing skills; ability to tell compelling stories about arts and culture
• Demonstrated experience with social media management and content creation
• Proficiency with Canva or similar graphic design tools; basic familiarity with Mailchimp or other email platforms is a plus
• Comfortable working across multiple projects and meeting deadlines
• Knowledge of the Greater Hartford arts scene and/or the Jewish community is a plus

Salary:

Under $25,000

Agency Information:

The Mandell JCC is a vibrant hub for Jewish community life, culture, and learning in the Greater Hartford area. We celebrate arts and culture, support local artists, and connect people through programs that reflect our shared values and community priorities.

Mandell JCC is an equal opportunity employer. We value and seek a diverse workforce and encourage candidates of all backgrounds, perspectives, and experiences to apply.