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

Location and Job Title:

Junior Accountant
Hebrew Educational Society
9502 Seaview Ave
Brooklyn, NY 11236

Principal Responsibilities:

• Bachelor's degree in Accounting or Finance is preferred
• Experience using QuickBooks/Microsoft Excel/Word/ and PowerPoint (plus other Accounting software products)
• Extensive knowledge of payroll functions including preparation, balancing, internal control, and applicable state and federal payroll taxes.
• Proficient with payroll software; experience with ADP or other related platforms is preferred
• Demonstrated the ability to conduct and complete work independantly
• Excels working in a collaborative environment to achieve target objects and outcomes
• Attention to detail
• Strong verbal and written communication skills
• Excellent organizational and time management skills; ability to work under pressure
• Strong problem solving, mathematical skills, and critical thinking skills
• Willing to take initiative and be flexible when needed

This job description is not intended to be all-inclusive. Duties and responsibilities may be added, removed, or modified at the discretion of the agency and the Supervisor based on operational needs.

Minimum Qualifications:

• Cash receipts and credit card processing
• Reconciles contract accounts and manages accounts receivable collections
• Create monthly invoicing with all backup documentation for all contracted grants
• Prepare payroll data and daily bank deposit before giving to the CFO to review
• Ensures accurate and timely processing of payroll updates including new hires, terminations and changes to allocations based on contractual obligations.
• Assists with the preparation of business activity reports and financial forecasts
• Assists with accounting records and ledgers by reconciling monthly basis
• Assist in payments and payroll deductions
• Record keeping in Quickbooks
• Provides outside auditors with assistance; gathers necessary account information and documents to perform annual audit
• Prepares and reconciles monthly budgets as applicable per contracted grant obligations with payroll, accounts payables, accounts receivables and receipts.
• Responsible for actively communicating and complying with all budget related standard, protocols and policies as outlined by DYCD, and other funders
• Prepare Consolidated Fiscal Report (CFR) annually for OPWDD and OASAS
• Performs other related duties as necessary or assigned by the CFO.

Salary:

$55,000 - $65,000

Agency Information:

The Hebrew Educational Society, a thriving multi-service, comprehensive community center located in southeast Brooklyn, provides a diverse array of programs and services within a multicultural, multi-ethnic environment that is inclusive of people of all ages and ability levels. Programs include Early Childhood, After School, Camp, Athletic and Aquatic Activities, People with disabilities, older adults, and social services.