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='11E993DA'
    

Location and Job Title:

Philanthropy Administration Coordinator
Trager Family JCC
3600 Dutchmans Ln
Louisville, KY 40205

Principal Responsibilities:

Duties:

• Responsible for ongoing Philanthropy department data entry and reporting needs in our CRM (donor records and contact information, fundraising campaigns, etc.).
• Process and record gifts, pledges, restricted, and tribute gifts in a timely manner.
• Prepare donor acknowledgments for Jewish Federation fundraising campaigns, JCC campaigns, and produce personalized tribute cards for applicable gifts.
• Reconcile with Finance team to ensure accuracy and intent of donor gifts.
• Maintain records of all legacy gift commitments and donor information, provide administrative support for this program as needed.
• Generate quarterly donor statements in partnership with the Finance team.
• Create pledge cards for staff and volunteer solicitors.
• Prepare and mail personalized donor cards for life cycle events.
• Electronically file all incoming pledges and payments.
• Conduct research on current and prospective donors.
• Serve as point of contact for donor inquiries and provide excellent customer service.
• Manage all subscription inquiries and requests for the monthly Community paper.
• Provide general administrative support to the Philanthropy department for special events, large mailings, and other needs.

Minimum Qualifications:

Requirements:

• Bachelor's degree and at least 3 years of professional work experience, preferably with experience in nonprofit fundraising and donor relations
• Strong proficiency in all Microsoft Office applications
• Prior experience with fundraising database management (SalesForce a plus)
• Highly organized, detail-oriented, and able to manage competing priorities
• Excellent interpersonal skills and professional, courteous demeanor
• Ability to manage confidential information with discretion
• Sensitivity to Jewish culture and traditions
• Ability to work occasional nights and weekends for special events

Salary:

$35,000 - $45,000

Agency Information:

Position Overview: Under the supervision of the Director of Philanthropy Administration, the Philanthropy Administration Coordinator is responsible for supporting fundraising efforts and donor relations, providing administrative support for the Philanthropy Department, and managing updates to our Customer Relationship Management (CRM) system with utmost attention to detail.