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='6E61B085'
    

Location and Job Title:

CONTRACTS AND GRANTS ACCOUNTANT
Shorefront YM-YWHA of Brighton Manhattan Beach
3300 Coney Island Ave
Brooklyn, NY 11235

Principal Responsibilities:

PRIMARY FUNCTION

Reporting to the Director of Finance (DoF), the Government & Foundation Contract Accountant will be responsible for the management and reporting of a $4.3M portfolio of government awards and $1M in foundation and UJA grants.

In collaboration with the DoF, the Government & Foundation Contract Accountant will be managing and improving the contract development/documentation/ invoicing process and improve timely workflows deliverable submission to funders. Key highlights of the role include pre- and post-award management of grant funding, timely invoicing supported by the general ledger, analysis, and timely communication of over/underspending, supporting program staff in properly monitoring contract spending and leading government funder audits.

KEY AREAS OF RESPONSIBILITY

Grants Management

• Responsible for end-to-end grants management process to include all pre-and post-award activities
• Manage the contracting process among various stakeholders to bring grants online, follow funder guidelines, budget preparation in collaboration with program staff and coordinating online/paper submissions
• Maintain contract documents and related materials in an orderly and organized manner in a file directory
• Address funder inquires and follow through on open items in a timely and comprehensive fashion
• Prepare monthly/quarterly financial and reimbursement reports to various funders ensuring accuracy and consistency with the general ledger
• Work with funders to troubleshoot and solve issues with reimbursement claim and disallowances
• Coordinate meetings with Program managers to discuss status of budget vs actual and action planning
• Provide detailed monthly/quarterly analysis of budget vs actuals to properly manage and communicate over/underspending of grant funds
• Work with DoF and program staff to coordinate budget modification submissions to ensure revenue maximization across grant funding
• Record and maintain all Accounts Receivable related to grants billing and ensure revenue recognition is in accordance with Generally Accepted Accounting Principles (GAAP)
• Follow up with funders to ascertain status of reimbursement
• Provide anticipated reimbursement data to DoF to assist in cash flow planning
• Perform grant closeout functions required by funders to include reconciliations, financial status reports, final invoices, purchase order liquidations and balancing budgets
• Maintain funder equipment inventory list as required
• Stay abreast of changes in funder's invoicing and reporting requirements; attend funders trainings and informationals as needed
• Establish relationships with funders (mainly fiscal counterparts)
• Coordinate activities between Payroll Manager & Accounting department to make necessary adjustments in personnel allocations for contract billing/vouchering
• Assist with time and effort reporting, ensuring completeness, accuracy, and compliance with all applicable regulations
• Work with DoF to meet all funder and departmental deadlines
• Support the annual agencywide audit to include the Federal Single Audit
• Prepare supporting schedules related to functional area and assist in providing documentation
• Participate fully in government funding audits

Perform other related duties as assigned

Audit

• Support the annual agencywide audit to include the Federal Single Audit
• Prepare supporting schedules related to functional area and assist in providing documentation
• Participate fully in government funding audits

Minimum Qualifications:

DESIRED EXPERIENCE & QUALIFICATIONS

• Bachelor's Degree in Accounting, Finance or Business Administration preferred
• Minimum of - 2 years hand on experience working with government grants required.
• Experience working with various government agencies on the Federal, State and NYC level (USDHS, NYSOFA, SED, DYCD, DOHMH, DFTA)
• Experience with MIP & government agency submission portals (HHS Accelerator; PASSPort, GrantsGateway) preferred.
• Strong verbal, written, communication and documenting skills
• Ability to work cooperatively with all levels of employees, management, and external parties
• Ability to prioritize, multi-task, and work in a fast-paced environment
• Excellent attention to detail, problem solving, & analytical skills
• Must be a self-starter, quick learner, assertive, and can work independently yet collaboratively

Job Type: Full-time

Full Benefit Package Provided

Onsite Position

Salary:

$65,000 - $75,000

Agency Information:

The Shorefront YM-YWHA of Brighton-Manhattan Beach, Inc. (SFY) builds community, strengthens families & empowers individuals to achieve their potential & enhance the quality their lives. Our programs & services reflect the richness of the Shorefront YM-YWHA's Community Center & Settlement House traditions. We reach out to & serve people of all backgrounds & abilities throughout their life spans.

We provide a wide range of exemplary educational, recreational, preventive & rehabilitative health, vocational, cultural, citizenship, Jewish identity-building & human service programs to meet the evolving strengths, needs & interests of the rich mosaic of people in southern Brooklyn.

The Shorefront YM-YWHA maximizes the impact of its resources & expertise by forming partnerships & alliances with other organizations, government agencies & philanthropic institutions that share our commitments & values.