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
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 - Masters Cash Masters Checking and Agents 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 Universitys 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 Universitys 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
Bachelors 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.
Required Experience:
IC
Teachers College, Columbia University, is the first and largest graduate school of education in the United States, and also perennially ranked among the nation's best.