Budget Analyst (3‐month Consulting Assignment) – UCLA Asset Management Dept.

The UCLA Asset Management Dept. seeks a consultant to assist with preparation of the FY1819 budgets. The work is fulltime (40 hours/week) for about 12 weeks. The consultant will report to and assist the Special Projects Manager in preparing the FY1819 budgets, which are due internally on 11/1/2017 and externally on 12/1/2017.

Duties:

  • Line‐by‐line budget decision‐making (forecasting) using trend analysis and mathematical formulas
  • Linking cells within Excel worksheets, worksheets within workbooks, and workbooks to other workbooks
  • Production of finished budget documents using multi‐sheet workbooks, including photocopying and document collating and assembly, and conversion of Excel documents to pdf using Adobe Acrobat Professional
  • Detailed spreadsheet formatting
  • Spreadsheet data entry

Required Skills:

  • Focused attention to detail
  • Extensive experience in Excel (2013) modeling and forecasting,
  • Strong financial analysis skills
  • Strong spreadsheet skills

Pay Rate: $20 to $25/hour, depending on experience and hiring method
Start Date: ASAP (no later than 9/14/2017) after successful completion of UCLA background check
Work Hours: 40 hours/week, 8 AM to 5 PM with an hour for lunch, Monday thru Friday
Job Duration: 12‐14 weeks (i.e., 3 to 3.5 months), excludes University holidays: 11/10, 11/23, 11/24
Work Location: UCLA Asset Management Dept.: UCLA Wilshire Center, Suite 815, 10920 Wilshire Blvd., Los Angeles, CA 90024
Department: The UCLA Asset Management Department provides full‐service property management for University‐owned high‐rise office buildings in Westwood (four buildings containing 900,000 SF, occupied by 150 primarily University tenants and generating $34M of revenue).

Department employees manage these functions for the building portfolio:

  • Operations (day‐to‐day activities of buildings, such as repairs, maintenance, janitorial, security, safety, parking, tenant relations),
  • Financial management (rent collection, accounting, budgeting),
  • Leasing and lease administration,
  • Contracts management (construction contracts, professional services agreements), and
  • Construction management (tenant improvements, major maintenance, capital improvements).