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='0C6DDAAA'
    

Location and Job Title:

Chief Financial and Administrative Officer
Minnesota JCC
1375 St Paul Ave
St Paul, MN 55116

Principal Responsibilities:

LEAD THE FINANCIAL AND ADMINISTRATIVE FUNCTIONS OF A THRIVING JCC

The Minnesota JCC is looking for an executive who will oversee and drive excellence, innovation, and growth across the JCC's Finance, Human Resources, Technology, Security, Facilities, and Administrative Support teams. This is a role for a leader who thrives in complexity, leads with clarity, and is energized by making systems work better for people.

Being part of our executive leadership team means that you will:

• Shape the future of the MN JCC. We lead collaboratively, and you will be a key thought partner in decisions that drive mission fulfillment and long-term impact.
• Influence our organizational culture. As an executive leader, you will model and reinforce values that promote accountability, equity, transparency, and belonging.
• Tackle enterprise-level opportunities and challenges. Your work will span beyond your departments to influence how we grow, adapt, and sustain the JCC's success.
• Serve as an internal and external ambassador. You will represent the JCC with staff, Board, partners, funders, and the broader community.

You are the ideal candidate if:

• You are an experienced CFO or senior finance leader, confident in managing budgets, forecasting, audit, risk, and financial strategy.
• You are a strong operational generalist who knows how to build cross-functional teams and drive high performance across multiple disciplines.
• You are independent, accountable, and take ownership of outcomes.
• You are confident and decisive and take initiative to move work forward with urgency and clarity.
• You have an entrepreneurial mindset and embrace change as an opportunity to improve.
• You are a systems thinker -- you see the big picture, connect the dots, and design processes that work.
• You are a clear and compelling communicator, able to influence, coach, and collaborate with stakeholders at all levels.
• You know how to lead people through change -- with empathy, steadiness, and clarity.
• You bring a data-informed mindset to decision-making and performance evaluation.
• You bring (or are open to learning) a deep appreciation for Jewish culture and values, which form the foundation of our community.

Minimum Qualifications:

Qualifications Required

• Bachelor's degree in Accounting, Finance, or Business Administration
• Minimum 7-10 years of progressively responsible experience in financial leadership, including CFO or senior-level finance roles
• Strong knowledge of GAAP, budgeting, forecasting, financial analysis, and risk management
• Experience leading audits, managing cash flow, and ensuring regulatory compliance
• Proficiency in financial systems and the ability to implement or upgrade systems and processes
• Demonstrated experience supervising diverse operational departments
• Excellent communication skills -- able to explain complex financial topics to both finance and non-finance stakeholders
• Strong organizational and strategic thinking skills with a bias for action
• Comfortable operating in a mission-driven, community-focused, and values-based environment

Preferred

• CPA, MBA, or relevant advanced degree
• Experience working in organizations, especially those with complex programmatic and revenue structures (e.g., fee-for-service, fundraising, grants)
• Familiarity with fund accounting, capital budgeting, and long-term financial planning
• Understanding of or willingness to learn Jewish culture and values, and how they inform organizational decision-making

Salary:

$135,000 - $150,000

Agency Information:

For nearly a century, the JCC has been a cornerstone of community life in Minneapolis and St. Paul, enriching lives through a broad range of programs and services--from Early Childhood Education and Summer Camps to Health & Wellness, Recreation, Inclusion, Youth and Teens, Supportive Services, Adult Enrichment, Inclusion Programming and Jewish Arts & Culture. With two locations and a dedicated camp property, the JCC serves nearly 10,000 people annually. Backed by a $15 million + operating budget and nearly $50 million in assets, the JCC remains a vital, thriving institution committed to community, connection, and impact.

Our Mission

Inspired by Jewish values and culture, we ignite the human spirit through programs and services that promote well-being, foster inclusivity and strengthen the entire community.

Our Values

The J is for Everyone

We create spaces and opportunities where people feel safe, seen, and connected. When everyone belongs, our entire community grows stronger.

We Adapt for the Greater Good

We are rooted in purpose and flexible in approach. We are responsive to today and ready for tomorrow, even when the path ahead isn't completely clear.

We Show Up Strong

We meet the moment. We take pride in what we deliver and how we deliver it. We aim high, prepare, and follow through, because people are counting on us.