Grants Controller & Analytics Lead

ECONOMIC OPPORTUNITY COUNCIL OF SUFFOLK; Village of Patchogue (NY); On-site; USD 90,000 - 140,000; Full time

Job summary

The Economic Opportunity Council of Suffolk in Patchogue, NY is seeking a Controller to oversee grant administration, compliance, and nonprofit accounting. This role requires advanced budgeting, financial analysis, reporting, and data visualization to support leadership and funding agencies.

You will lead month-end close, cash management, and audit support, develop dashboards, and ensure CFR submissions while maintaining strong internal controls and policy adherence.

Qualifications

• Advanced Microsoft Excel: Pivot Tables and Pivot Charts Power Query Power Pivot Data Modeling Dashboard Development
• Data Visualization & Reporting Tools Microsoft Power BI Tableau Excel Dashboarding
• Ability to develop interactive dashboards and executive-level data visualizations
• Knowledge of grant accounting, budgeting, billing, and financial reporting
• Understanding of federal, state, and county grant regulations and compliance requirements
• Proficiency in financial systems, preferably FundEZ
• Strong attention to detail and accuracy in reviewing financial data and maintaining documentation
• Excellent written and verbal communication skills
• Strong organizational skills and the ability to manage multiple priorities and meet deadlines
• Ability to analyze financial data, monitor budgets, and identify discrepancies
• Knowledge of audit preparation, documentation, and financial recordkeeping
• Ability to work independently and collaboratively with Finance and Operations teams
• Ability to adapt to changing priorities, cross-train, and provide departmental backup support
• Ability to supervise, guide, and support staff in completing accounting, grant administration, and financial reporting responsibilities

Responsibilities

• Complete quarterly, semi-annual, annual, and ad hoc financial and programmatic grant reports.
• Coordinate grant award setup and submit required documentation to oversight and funding agencies.
• Lead and participate in grant monitoring, program, compliance, and audit meetings.
• Manage grant modifications, extensions, closeout activities, and reporting requirements.
• Maintain complete grant files and support documentation in accordance with record retention policies.
• Ensure grant files contain sufficient audit-ready documentation and compliance records.
• Monitor grant expenditures to ensure compliance with funding restrictions and award agreements.
• Support internal and external grant audits and regulatory reviews.
• Generate monthly, quarterly, and annual financial reporting packages.
• Prepare Statements of Financial Position, Statements of Activities, and budget-to-actual reports.
• Reconcile balance sheet accounts, grant receivables, deferred revenue, and credit card liabilities.
• Analyze financial performance and identify budget variances with supporting explanations.
• Monitor grant spending and prepare budget reconciliation reports.
• Assist with annual operating budgets, program budgets, and financial forecasting.
• Prepare workpapers and schedules for annual audits, CFR submissions, and regulatory filings.
• Assist in the preparation of Form 990 and other compliance reporting requirements.
• Perform month-end and year-end close procedures.
• Prepare deferred revenue calculations and grant accruals.
• Ensure compliance with nonprofit GAAP and grant accounting standards.
• Maintain strong internal controls over financial transactions and reporting processes.
• Oversee accounts payable operations, ensuring timely and accurate invoice processing and vendor payments.
• Supervise preparation, review, approval, and issuance in accordance with company policies and internal controls.
• Manage daily cash flow, monitor bank balances, and ensure sufficient funds for payment obligations.
• Oversee bank reconciliations and cash disbursement activities to maintain accuracy and accountability.
• Ensure compliance with financial policies, procedures, and internal controls.
• Supervise and develop AP staff, ensuring accuracy, efficiency, and adherence to deadlines.
• Develop financial dashboards and executive-level reporting tools.
• Create visualizations to track grant expenditures, funding utilization, budget variances, compliance metrics, and program performance.
• Automate recurring financial and grant reporting processes.
• Present financial trends and performance metrics to leadership using data visualization tools.
• Develop, write, review, and update accounting, grant administration, financial reporting, and internal control policies and procedures to ensure compliance with applicable accounting standards, regulatory requirements, funding guidelines, and organizational policies.
• Establish and maintain documented procedures to promote consistency, accuracy, efficiency, and accountability across financial and grant-related processes.
• Periodically review existing policies and procedures and recommend revisions to reflect changes in regulations, accounting standards, audit findings, and organizational needs.
• Communicate policy and procedural updates to relevant staff and support implementation to ensure consistent application across the organization.
• Monitor team assignments and ensure staff remain on track with submissions, portfolio updates, expense reviews, and reporting requirements.
• Maintain an updated tracker of completed, pending, overdue, and upcoming deliverables.
• Follow up regularly with team members to address outstanding items and reinforce accountability for meeting deadlines.
• Communicate potential delays, compliance concerns, and financial discrepancies to the appropriate management personnel.
• Support collaboration between the grants team, Finance, and program staff to improve workflow and reporting accuracy.
• Become cross-trained in all grant management functions, processes, systems, and reporting responsibilities.
• Develop the knowledge and skills necessary to provide coverage during staff absences, peak reporting periods, and other operational needs.
• Maintain an understanding of the grant lifecycle, including grant setup, budget monitoring, expense tracking, portfolio maintenance, reporting, reconciliations, and grant closeout.
• Participate in cross-training and knowledge-sharing activities to promote consistency, efficiency, and continuity across the department.
• Perform additional ad hoc tasks, special projects, research, analysis, and administrative or financial assignments as directed by the CFO, Grant Supervisor, or other authorized management.
• Provide support for urgent departmental priorities and time-sensitive requests.
• Assist with developing reports, resolving operational issues, and improving grant management processes.
• Manage changing priorities while ensuring critical grant submissions and month-end close deadlines are met.
• Communicate progress and complete assigned tasks accurately and within established timelines.

Skills

Advanced Excel

Pivot Tables

Data Visualization

Nonprofit GAAP

Grant accounting

Budgeting

Financial analysis

Communication skills

Leadership

Audit support

Education

Bachelor’s degree in Accounting/Finance

Master’s degree preferred

Tools

FundEZ

Power BI

Tableau

Excel

ERP systems

Job description

The Economic Opportunity Council of Suffolk in Patchogue, NY is seeking a Controller to oversee grant administration, compliance, and nonprofit accounting. This role requires advanced budgeting, financial analysis, reporting, and data visualization to support leadership and funding agencies.

You will lead month-end close, cash management, and audit support, develop dashboards, and ensure CFR submissions while maintaining strong internal controls and policy adherence.