Overview

OverviewThe Investment and Loan Program, Inc. (ILP) is a nonprofit corporation of PC(USA) created to provide low-cost loans to congregations, governing bodies and related entities of PC(USA). We provide loans for the construction or purchase of buildings, renovations, and even refinancing of existing debt.Whether it is reshaping a space to meet the needs of a changing congregation, reducing the carbon footprint by utilizing energy efficient products and renewable energy sources, or expanding mission and outreach efforts by reducing the amount of funds necessary for debt service, the Program seeks to partner with congregations to determine the best financial results for the project.The Investment and Loan Program raises funds for lending by selling interest-bearing term notes. Every day, Presbyterians across the country are supporting the growth of mission and ministry throughout our denomination. The Investment & Loan Program, as a nonprofit, does not have any shareholders. Its sole member, which is nonvoting, is the Presbyterian Church (U.S.A.), A Corporation. Position Purpose: The Associate for Data Operations & Accounting oversees and manages data operations related to loan and investment administration, provides support for various accounting functions, maintains the records retention policy, and tracks insurance renewals. This role requires expertise in banking software, data extraction, and report generation to support various administrative and financial operations. A key responsibility of this role is to ensure the integrity and accuracy of all data managed.Roles and Responsibilities: Utilize banking software to extract and generate data for operations and financial administration Ensure accurate and timely data extraction from banking software system.Generate comprehensive reports to support operations and administrative tasks. Collaborate with other departments to ensure data integrity and consistency. Review loan/investment files and maintain exception reports Conduct thorough reviews of closed loan and investments files to ensure compliance.Identify and document any exceptions or discrepancies in investment and loan files. Update and maintain exception reports for ongoing monitoring. Support Accounts Payable operations Verify and batch expenses submitted for payment. Support AP Manager as back-up for check run processing (outgoing checks, wires, ACHs). Prepare monthly reconciliation reports through accounting software Perform monthly bank reconciliations.Maintain depreciation and amortization schedules.Track administrative service fee details for invoicing. Track insurance renewals and manage reinstatement processes for loan customers Coordinate with insurance providers to manage reinstatement of policies.Maintain detailed reports of insurance status and renewal dates. Monitor insurance policies to ensure timely renewals are occurring or have occurred. Prepare investment support and rebate reports Monitor and review monthly investment allocations and create monthly reports for distribution to borrowers. Administer and track monthly reporting of the Program's rebate program. Administer the records retention policy On-going review, maintenance, transferring and destroying of program loans, investments, and administration files/records. Develop strategies and processes for retention metric and tracking. Prepare mortgage releases for investor and endowment loans and mortgage grants Work closely with the department of legal services to ensure compliance with legal requirements and obtain necessary approvals. Prepare and generate quarterly/annual reports for the issuance of the Program's Offering Circular.Responsible for special assignments as requested by Senior Management. Essential Position Requirements: An undergraduate degree preferable in business or equivalent business experience.Minimum 3 years of experience in data operations, accounting or a related field.Proven experience in banking software and data extractio