Job Requisition Number: 27455. The Contracts & Grants (CGA) Office has campus-wide responsibility for the administration of all federal and private contract and grant funding received by UC Berkeley, which in fiscal year 2018 totaled over $700M. CGA is responsible for supporting the Berkeley campus with fund set up, preparing regular financial reports, ongoing analysis and reconciliation, interpreting policy, collecting reimbursable expenditures through billing and cash draw down, and closing out contracts and grants. CGA manages and coordinates campus-wide audits of contracts and grants performed by Federal and other external auditors, and develops responses to audit findings and corrective actions necessary to resolve audit issues. CGA is also responsible for providing systems, policies, procedures, and training campus-wide to facilitate the management of more than 5,000 contracts and grants across campus.
•Prepare regulatory reporting and reconciliations in compliance with requirements set forth in contracts and grants from various sponsoring agencies, coordinating the collection of information for various awards and other financial records. •Oversee administration of the Effort Reporting System and conduct post award compliance monitoring. •Prepare quarterly Federal Financial Reports for each federal agency participating in the cash drawdown process in the Department of Health and Human Services Payment Management System. •Prepare quarterly Federal Financial Reports for each federal agency participating in the cash drawdown process in the Department of Health and Human Services Payment Management System. •Design, update, and create reports for award-related transactions using the Berkeley Financial System (BFS) query and the Berkeley Administrative Initiative Reporting System (BAIRS) tools as requested by the CGA Director, Accounting Manager, or Team Leads. •Apply advanced accounting concepts to perform highly complex technical analysis and reporting including reconciliation and recording of intercampus initiating payment entries to the other nine UC campuses and preparing summary schedules for submission to the Office of the President (UCOP). •Participate in fiscal period closes by reconciling/clearing deficit and small balances on various contracts and grants, by distributing membership funds overhead assessments to various Departments, and by distributing the management fee assessments to the California Institute for Energy and Environment (CIEE) in accordance with campus policy. Run BFS queries and CalAnswers reports to review and analyze data for the revenue deferral/accrual and expense deferral for year-end close. Prepare financial year-end reports for the Office of the President. •Calculate Short Term Investment Pool (STIP) income earned on federal funds and submit a refund check to DHHS annually. •Analyze and provide explanations for general ledger account variances. •Provide reports and analysis to support audit inquiries and investigations; review, analyze and develop responses to audit findings and reports; identify and develop corrective actions. •Assist in implementation, testing, data validations, and maintenance efforts for Contracts and Grants accounting and other related systems. •Attend training workshops toward present and future career development, participate in general staff meetings, and contribute to the implementation of special projects when assigned. •Interpret reports and records for campus administrators and managers. •Run queries to identify closed C&G funds; review and analyze data; and inactivate funds in BFS •Review revenue and expense balances for the Federal Financial Aid Program Awards and draw down funds as needed. •Assist the Compliance Unit with correcting the fund attribute errors on the UCOP Fund Error Report. •Work closely with the Sponsor Projects Office (SPO) to resolve issues with the SPO-BFS Award Information Data Feed process. •Act as a generalist to cover other areas in CGA and assist the Award Analysts with issues related to financial and budgetary data.•Has advanced knowledge of accounting functions and assignments. •Is able to extract, verify and compile accounting information from a variety of sources. •Has an understanding of the interrelationship of procedures and desired results. •Ability to present complex accounting and finance related information in a clear and concise manner, both in writing and verbally. •Independent judgment and strong organization and communication skills and customer service focus across broad and diverse subject areas. •Knowledge in contracts and grants accounting, processing and compliance requirements. •Knowledge and experience of internal and external audit requirements. •Must be experienced in use of financial transactions and financial systems including queries and pivots, as well as related policies and procedures, accounting and regulatory compliance requirements. •Knowledge of OMB’s Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance); knowledge of Federal Acquisition Regulations and principles of cost accounting standards. •Demonstrated skill to communicate effectively with people at all levels in order to explain policies, regulations, and procedures, present facts, conclusions, and recommendations in a clear, concise, and tactful manner. •Strong statistical and analytical skills and ability to explain statistical information so that it is easily understood at all levels. •Advanced level in computers, including ability to operate personal computer software (for example, Word, Access, Excel, email, electronic calendaring, internet, etc) with sophisticated retrieval, storage, and merging capabilities. •Extensive experience in the use of spreadsheets and database systems for financial analysis and financial reporting. •Excellent interpersonal skills and ability to work in diverse groups; ability to multi-task and work with frequent interruptions; ability to work under pressure of deadlines in an environment of changing priorities; willingness to participate on departmental project teams. •Strong persuasive abilities to influence cooperation and compliance •Bachelor’s degree in related area or equivalent experience. Professional certification preferred. •Experience with contracts and grants preferred. •At least 7 years of related experience preferred.
The University of California was chartered in 1868 and its flagship campus - envisioned as a "City of Learning" - was established at Berkeley, on San Francisco Bay. Today the world's premier public university and a wellspring of innovation, UC Berkeley occupies a 1,232 acre campus with a sylvan 178-acre central core. From this home its academic community makes key contributions to the economic and social well-being of the Bay Area, California, and the nation.