• Job Type: Officer of Administration
• Bargaining Unit:
• Regular/Temporary: Regular
• End Date if Temporary:
• Hours Per Week: 35
• Standard Work Schedule:
• Building:
• Salary Range: 70,000-87,000

Position Summary

Reporting to the Director of Sponsored Projects Finance and Reporting, the Accounts Receivables Analyst provides a wide range of financial review and operational duties in support of the Climate School as it is related to institutional, sponsored project and contract-based funding. The Analyst will take a leading role in all Climate School accounts receivables including reconciliation and monitoring of OMO Research Vessel accounting and Climate School recharge centers. The Analyst will receive training in a variety of financial operating activities for the school to provide additional support as needed.

Responsibilities

Review recharge center budgets for approval at the beginning of every fiscal year.  Regularly monitor recharge center activities to ensure timely recovery of costs.  Review all recharge center recovery requests received for processing.  Assure compliance with the University's recharge center policy.

Research and resolve issues concerning all Account Receivable (AR) accounts including third parties

Contract review and maintenance for third party billing

Develop and create correspondence in response to AR inquiries

Assist in the management of the billing, collections, payment tracking and revenue/expense accruals

Manage business processes, systems, and workflows, to support and respond to the needs of the University and vendors

Work collaboratively with the Climate School and other University departments to serve, be a core part of the team, and ensure compliance with regulations and policies

Ensure that appropriate internal controls are in place

Comply with changes in accounting standards or other compliance issues regardless of organizational structure

Analyze, monitor, approve, and issue invoices to university departments and external organizations on a regular basis, including final invoices, in accordance with the terms of the award or contract.

Develop and maintain accounting related specialized spreadsheets and reports to monitor the Ship related accounts - Master's Cash, Master's Checking and Agent's Advances related to the Marine Ship operations. Review OMO bank statement reconciliations for submission to the Controllers Office.

Prepare accurate and timely financial reports as needed

Participate as an active member of the University’s cash management team by monitoring receivable balances reported in the financial system on a regular basis, inquiring about delinquent payments, posting payments accurately and timely to the bank and financial system, researching any unidentified payments as needed

Reconcile financial system subsidiary ledgers, including the receivable ledger, with the University’s general ledger

Maintain current knowledge of various University systems and all related interfaces needed for day-to-day responsibilities

Assist with the implementation of new financial systems and upgrades to existing financial systems

Maintain working knowledge of Office of Management and Budget (OMB) policies for federal awards, such as 2 Part CFR 200 (Uniform Guidance), federal and state agency specific grant guidance and University policies and procedures

Complete quarterly accounts receivables analysis for Climate School leadership to monitor and flag any delays or variances

Perform other duties as assigned to assist departments as necessary and ensure timely processing of transactions.

Minimum Qualifications

Bachelor’s degree and or combination of education and related experience. Minimum of three years of financial accounting experience

Demonstrated ability to work independently and as part of a team

Demonstrated attention to detail and ability work with a high degree of accuracy

Demonstrated experience with organizing and managing multiple tasks and deadlines

Demonstrated experience using financial or ERP systems

Demonstrated strong verbal and interpersonal communication skills

Demonstrated proficiency in written communication skills

Willingness to learn new processes and keep current on emerging industry trends

Preferred Qualifications

Strong analytic skills, accuracy and attention to detail. Excellent organizational and follow-up skills with a proven ability to prioritize and multi-task. Professional, ethical and able to handle confidential information; ability to remain impartial and objective. Excellent communication, interpersonal and writing skills including the ability to work independently and as part of a team at various levels in an organization.

Computer skills, including excellent skills in Microsoft Excel required. Strong analytical skills a plus.  Microsoft Office knowledge and university financial systems (ARC, Finsys and FDS).

Other Requirements

Equal Opportunity Employer / Disability / Veteran

Columbia University is committed to the hiring of qualified local residents.