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

Location and Job Title:

Human Resources Coordinator
Kings Bay YM-YWHA INC.
3495 Nostrand Ave
Brooklyn, NY 11229

Principal Responsibilities:

The Human Resources Coordinator supports the daily operations of the HR department and serves as a primary point of contact for onboarding, recruitment coordination and employee documentation. This role manages onboarding for all new hires, including the high volume of seasonal staff hired for Summer Camp, ensuring required documents and HRIS entries are completed accurately and on time. The HR Coordinator also maintains compliant employee records, assists employees with HR process questions and supports recruitment efforts through job postings, applicant tracking and interview coordination. This is a hands-on role with training provided and strong opportunities for growth within the HR field.

Minimum Qualifications:

Job Responsibilities:

• Guide all new hires, including part-time and seasonal employees, through the onboarding process by collecting required documents, verifying completeness, and ensuring all onboarding requirements are completed on time.
• Handle onboarding for a high volume of seasonal staff leading up to summer camp
• Ensure accurate filing of onboarding documents and timely entry of new hire data into the HRIS system (ADP Workforce Now)--training provided
• Program clearances & background checks--training provided
• Maintain confidentiality and ensure HR files & HRIS records are updated and audit-ready
• Assist with the full lifecycle of hiring, including job postings, candidate screening, and onboarding
• Respond to employee questions about HR processes (for example onboarding, employment documents, direct deposit setup and basic policy questions) in accordance with agency handbook policies.
• Understands employee handbook and able to answer questions and provide guidance to employees
• Track required employee documentation (for example work authorization, medicals and clearances) and follow up on expiring or missing items to maintain compliance.
• Assist in preparing HR reports or summaries for leadership (e.g., hiring status, onboarding progress, employee rosters)
• Manages invoicing for the department, assuring that bills are accurate and submitted in a timely manner for payment.
• Collaborate with HR Manager to develop and implement HR initiatives and programs
• Performs other duties as assigned by HR Manager or as required

Qualifications

• AS/BA/BS in business administration, human resources, or related field required
• 2+ years of HR related experience, preferably supporting processes such as onboarding, recruitment, or employee documentation.
• Familiarity with HR procedures, onboarding processes, and confidentiality standards (strongly preferred)
• Demonstrated ability to work cooperatively and effectively with co-workers.
• Demonstrated ability to maintain employee data at the highest level of confidentiality.
• Working knowledge of employment policies and employment law is preferred
• Experience with Microsoft Office Suite (Word, Excel, PowerPoint)
• Comfort learning HR software systems (ADP)--training provided
• Experience with office equipment (printers, scanners)

Skills

• High attention to detail and accuracy
• Excellent organizational and time management skills
• Ability to work independently and collaboratively
• Strong written and verbal communication
• Ability to manage multiple priorities and meet deadlines
• Discretion in handling sensitive employee information
• Willingness to learn and take initiative

Job Benefits

• Health and vision coverage & dental coverage
• Pension Benefit plan, after one year, with agency contribution
• Life insurance
• Eligibility to participate in the organization's 403(b) Retirement Savings Plan
• Generous Paid time off (PTO)
• Paid federal and additional holidays
• Employee program discounts

Schedule

• Full-Time, Monday through Friday, 9 AM - 5 PM

SALARY

• $50,000-$60,000 annually, commensurate with experience

Salary:

$55,000 - $65,000

Agency Information:

Inspired by Jewish values and ideas, the Kings Bay YM-YWHA strives to build and strengthen communities, create meaningful relationships and lasting friendships, and foster deeper connections among individuals, families, and partner institutions in Brooklyn.

From our flagship base in southern Brooklyn, where we operate a successful full-service Jewish community center, to our more recent inroads in Brownstone Brooklyn and North Brooklyn under the JCC Brooklyn umbrella, the Kings Bay Y has remained true to its 60-year-old mission.