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

Location and Job Title:

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

Principal Responsibilities:

The JCC seeks a dynamic and strategic CEO to serve as an innovative and visionary leader. We seek someone who can bring communities together by being visible and approachable. The ideal candidate is a professional with a proven track record in fundraising, a strong community partner, relationship builder and collaborator; and who possesses excellent staff and operational management skills. The CEO will lead the JCC into a new era of strategic growth in an environment that celebrates diversity and welcomes all, in part, by working to implement the recently adopted Strategic Plan.

Minimum Qualifications:

https://www.dsgco.com/search/22924-ij-jeann-wagner-jewish-community-center-chief-executive-officer/

Salary:

$180,000 - $195,000

Agency Information:

We are a vibrant community center full of people of all ages, faiths and family configurations, coming together in peace to strengthen their minds, bodies and spirits.

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.