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='5AFDC4A4'
    

Location and Job Title:

Marketing Graphic Designer
IJ & Jeanne Wagner Jewish Community Center
2 North Medical Drive
Salt Lake City, UT 84113

Principal Responsibilities:

Objective: To create engaging, high-quality visual materials that reflect the JCC brand and help tell the story of our programs, people, and community across print and digital platforms.

Responsibilities:

• Design and produce JCC marketing materials including program flyers and posters, social media and email graphics, digital signage, program guides, event collateral, website graphics, and other creative assets
• Implement and adhere to established JCC brand and visual guidelines, ensuring consistency across print and digital channels
• Work collaboratively with the Marketing Director and departments across the JCC to translate marketing needs into effective, engaging design
• Manage multiple projects and deadlines while maintaining accuracy, quality, and attention to detail
• Prepare production-ready files and coordinate with print vendors as needed
• Resize and adapt creative materials across multiple platforms and formats
• Provide occasional photography and video content capture to support JCC marketing efforts
• Stay current on design trends, tools, and best practices
• Attend meetings and JCC events as requested and appropriate to the position
• Contribute to additional creative projects and marketing initiatives as needed to support the JCC and its programs

The JCC has been part of the Salt Lake community for more than 100 years, serving people of all ages, backgrounds, faiths, and family configurations. As a member of our team, you'll help tell the story of this incredible community--and become part of it yourself.

Minimum Qualifications:

Qualifications:

• 2-4 years of professional graphic design experience preferred
• Portfolio demonstrating strong print and digital design skills required
• Proficiency in Adobe Creative Suite, particularly InDesign, Illustrator, and Photoshop
• Strong understanding of print production and preparing production-ready files
• Proficiency in Microsoft Office, including Outlook, Word, Excel, and PowerPoint
• Strong organizational and time-management skills with the ability to manage multiple projects simultaneously
• Ability to work independently while contributing as part of a collaborative team
• Creative, flexible, detail-oriented, and comfortable receiving and incorporating feedback
• Strong interpersonal and communication skills
• A sense of humor and a willingness to jump in as part of a busy, community-focused team

A degree in graphic design is preferred; however, demonstrated design ability, professional experience, and a strong portfolio are most important.

Salary:

$45000

Agency Information:

• Parents of young children value our nationally accredited preschool and licensed hourly childcare, while families with older children love our summer camps, afterschool programs, sports clinics, and more.
• Our adult members enjoy a full suite of wellness and fitness offerings, from personal training and Pilates to year-round aquatics and pickleball.
• As a diverse community coming together in peace, we host a wide range of curated events including workshops, lectures, and cultural offerings.
• And most of all, for families of all configurations and friends new and old, we are a gathering place. Whether it's finding a group to enjoy art classes together or relaxing at the pool each summer as a family, you'll find your place here.

Mission Statement

Enriching the life of the Jewish community and the community at large by offering educational, cultural and recreational opportunities in a place where people of all backgrounds, cultures and beliefs gather in peace and understanding.