Job Requisition Number: 27173. The Capital Projects team manages the design, construction, retrofitting, and restoration of campus buildings and their surroundings. Many skilled professionals work in Capital Projects as architects, landscape architects, planners, engineers, inspectors, construction specialists, contract administrators, accountants, and administrative personnel, all of whom work to serve the campus community.
Capital Projects Accounting provides project accounting and accounts payable services for the construction work in progress. The Capital Projects Accounting unit reports to the Director of Financial Planning & Budget.
As a member of the staff of Capital Projects Accounting, the Accountant position involves accounting functions such as analyzing, monitoring, preparing and reconciling financial information to reflect the condition of the organization and provide financial and other statistical data to control operations.
Accounting and Maintaining GL Systems:
•Maintains Berkeley Financial System (BFS) for plant accounting, GL reporting system (CALANSWERS), and Capital Projects shadow system (UNIFIER). •Analyzes construction payment applications for compliance with contract terms. •Coordinates partial payments requested by Project Managers. •Ensures accuracy of retention payments across all projects including multi-funded projects. •Ensures accuracy of escrow payments across all projects on multi-funded projects. •Processes Liquidated Damage (LD) claims by UCB towards contractor/vendor. •Enforces Implementation of Stop Payment Notices and Releases. •Maintains project balances to prevent overdrafts. •Makes recommendations and coordinates resolution with Project Managers and parties involved. •Helps develop accounting processes to increase unit efficiency and accuracy in maintaining accounting systems. •Acts as liaison between client, functional partners, and technical teams in trouble shooting and resolving user problems with BFS, AP/PO, and UNIFIER. •Maintains chart of accounts values or attributes to ensure integrity in the GL accounting structure.
Financial Entries and Transactions:
•Prepares journal entries, maintains and reconciles ledger accounts. •Monitors, validates, and verifies Bear buy Purchase Orders for Goods and Unifier commits and Vouchers for Construction and services. •Monitors charges in pass-through funding to ensure that correct charges are moved to client accounts monthly. •Obtains back-up documentation for external/internal audit issues at year end. •Follows close-out notification process with recharge units to capture all costs prior to close-out. •Participates in Coordination of Capital Projects Fiscal Close activities and transactions. •Liaison between Capital projects, departments and General Accounting. •Provides record of assets, liabilities and other financial transactions.
Reconciliation & Reporting:
•Reconcile General Ledger and UNIFIER system for correct expenses on a monthly basis. •Reconciliations may involve subsidiary or external systems with a high volume of detail data elements. •Prepares monthly reconciliation reports, accounting operational reports, including voucher metrics, outstanding vouchers, PO Commitment reports •Reconciles Payment Applications for correct payment amounts, retention amounts, as well as Deductions incl. Liquidation Damages. •Processes Close out notices, coordinates with PM, vendors and Campus Departments. •Assists department business officers throughout campus to understand recharge billing to their ledgers and other issues regarding project expenditures. •Responds to inquiries from Vendors on status of payments. •Initiates inquires to Vendors to clarify invoice billing. •Identifies common client issues and works out plan for corrective measures. •Analyzes sales tax billed by vendors, and uses knowledge of California Sales & Use Tax law to determine if sales tax has been applied appropriately, or if correction is required. •Participates in data gathering from the general ledger for the collection of information for UBIT, participates in preparing summary schedules for submission to OP, and either answering questions from campus departments or coordinating response from UCOP.
•Provides analysis for complex accounting projects. •In response to inquiries from campus Plant Accountant, provides analysis of project expenses using Capital Projects shadow system, AP/PO system, or General Ledger. •Analyzes expenditures in preparation for capitalization or project close-out. •Analyzes contract terms, purchase orders, change orders, and encumbrance balances to maintain project escrow accounts. •Performs other duties as assigned.•Has thorough knowledge of accounting function and assignments. •Has ability to independently gather, organize, and perform accounting related analysis. •Requires ability to present information in a clear and concise manner both in writing and verbally. •Thorough knowledge of financial transactions and financial systems, as well as related policy, accounting and regulatory compliance requirements. •Must be proficient in use of Microsoft Office and common desktop/web applications. •Must be able to work both independently and as a team member. •Must be proficient in the use of an on-line financial/general ledger transaction system. •Must be proficient in use of an on-line data warehouse reporting system; must be able to extract relevant information from the data warehouse to create custom analytical reports using queries and pivots to respond to varying inquiries from the AVC-Project Management and from Project Managers. •Demonstrated ability to juggle heavy deadline-driven workload, and set priorities. •Skill in analyzing information and objectives to define problems, identify patterns, relationships, formulate logical and objective conclusions and recognize alternatives and their implications. •Demonstrated excellent interpersonal skills to establish and maintain cooperative, tactful, effective, and harmonious working relationships with co-workers, supervisors, university employees, sponsors and the public. •Demonstrated professional experience, business acumen, judgment and integrity to effectively deliver high quality service to internal and external customers. •Demonstrated ability to manage a high volume of assignments and to set priorities, which reflect relative importance of the task to overall job responsibilities. •Skill in writing clear, concise, and grammatically correct business correspondence, analysis and financial reports intended for audiences ranging in experience from novice to advanced in the subject matter. •Superior written and oral communication skills to ensure effective communication with a wide range of audiences including internal staff, project managers, vendors, and department fund managers and controller’s staff. •Skill in organizing material and information in a systematic way to optimize effective and efficient operations. •Advanced knowledge of the most current versions of Excel and the ability to do Pivot Tables, Vlookup, and Advanced Excel Functions to prepare reports and manipulate data-sets. •Working Knowledge of Microsoft Office Word, PowerPoint, Visio and other database query programs to effectively complete primary job functions. •Ability to adapt to changes as a result of automation including re-training, workflow changes, procedural adjustments, and interactions with the campus community. •Advance skill and experience in accounting and financial management practices, including a basic understanding of systems of internal control sufficient to review, analyze and interpret procedures and results in order to determine whether transactions and activity comply with laws, regulations, terms and conditions of capital projects contract documents, policies and procedures. •Demonstrated skill in delivering high quality customer service to a diverse group of colleagues both within the organization and to external customers. •Advanced working knowledge of customer service, performance measurements and quality service principles to ensure delivery of capital projects accounting services meets established standards. •Demonstrated experience in delivering effective presentations to audiences of various sizes ranging in experience from novice to advanced in various subject matters. •Working knowledge of University accounting, payroll, personnel, material management policies and procedures to effectively review and correct financial transactions using manual forms and electronic media.
Education/Training: •Bachelor's degree in related area and/or equivalent experience/training.
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.