Financial Analyst 2 - 71822
RESIDENTIAL & DINING ENTERPRISES AT STANFORD UNIVERSITY
Residential & Dining Enterprises (R&DE), the largest auxiliary organization at Stanford University, supports the academic mission of the University by providing the highest quality services to students and other members of the University community. The department has an annual operating budget of over $200 million, oversees a 5 million sq. ft. physical plant across the campus, provides housing for 11,000 students, serves 18,000 daily meals at twenty-two dining and retail locations, and serves 5,000 meals at Athletic Concessions events, hosts 14,000 conference guests, and operates a guest house.
SUMMARY OF POSITION
The Project Accountant primarily supports Capital Planning and Project Management (CPPM) group in Residential and Dining Enterprises. The position will report to the Senior Finance Manager of R&DE CPPM, and provide full cycle financial oversight for over 300 / $50Mln in active projects annually, in close collaboration with another Financial Analyst/Project Accountant for CPPM and other campus partners. This role will provide both consolidated and detailed tracking and reporting of projects, maintenance of the project financial records in department's project management database application (currently MRPP), month-end and year-end close activities, as well as tracking and monitoring of pay applications for all projects under purview of the R&DE Capital Planning and Project Management group.
- Full cycle accounting, tracking and reporting of project expenses and commitments for a complex portfolio (across mixed funding sources and cost centers) of over 300 construction projects of various sizes (from $10k to $3mln) annually, including, but not limited to:
- Ascertain correct PTA and GL code breakdown for project requisitions and availability of funding
- Reconciliation of Budget vs commitments vs actuals.
- Monthly accruals and reconciliation of project status versus expenses booked to date.
- GL review and reconciliation. Review of expenditure statements and commitments for PTA accuracy and preparation of correcting journals as necessary.
- Update various campaign and project tracking documents in Excel, including commitments and expense tracking and reconciliation (Campaign, Project and Requisition level).
- Preparation of financial reports as needed : consolidated and detailed construction projects financial reports - pull and consolidate information from multiple systems and databases to prepare accurate financial reports of projects performance against plan, by category of spend as well as at high level.
- Project variance analyses, researching anomalies/discrepancies.
- Contract and change order tracking
- Construction, Architectural and other Invoice initial review, tracking (excel and project database), upload for payment, reconciliation, status update GMP, (including GMP and Lump sum contracts invoice review and reconciliation).
- Maintenance of CPPM project tracking database (currently Major Repair/Planned Project (MRPP) ), including but not limited to setting up campaigns and budgets, monitoring projects, entering transaction data, reconciling with Oracle, and assisting project managers in proper use of the system.
- Perform and design ad hoc analyses of large complex data sets: reconcile complex accounts. Identify and resolve complex issues which may span multiple areas.
- Construct and assemble data for budgeting and decision making; develop conclusions, and present high level summary of recommendations. May develop annual budget for individual department/unit.
- Conduct analysis and resolution, and recognize exceptions. Participate in developing solutions that may require policy changes or the development of new processes; maintain broader organizational perspective in decision making.
- Execute internal control programs established by management, research new regulations, and recommend and implement approved changes. May manage compliance program for area of responsibility, and create complex compliance reports.
- Develop reports and presentations of complex financial data and metrics for management and third parties.
- Participate as a member of a project team; support new initiatives. Make decisions determining approach to managing and completing processes.
- Contribute to unit and organization strategy; assist in the development of change management plans and materials as needed.
- Develop and maintain desktop procedures and process documentation for area of responsibility.
- Define requirements, develop and implement complex test cases, perform system testing and analyze results.
- Participate in critical analysis of existing systems and processes, and identify opportunities for process improvement.
- Other duties as assigned or as necessary.
KEY EXPERIENCE PREFERRED:
- Owner-side accounting and finance experience in construction.
- Experience with review and reconciliation of vendor invoices for construction projects, including GMP.
- Hands on experience with month-end and year-end close cycles.
Education & Experience:
Bachelors degree and four years of relevant experience or combination of education and relevant experience.
Preferred: Degree in Business, Accounting, or Finance.
Knowledge, Skills and Abilities:
- Superior Microsoft Excel skills.
- Advanced proficiency in business applications, such as Microsoft Office suite.
- Demonstrated knowledge of accounting, financial systems; internet and computer literacy.
- Strong communication skills, including ability to prepare materials for and clearly and effectively communicate information to internal and external audiences and client groups.
Certifications and Licenses:
- Constantly sitting.
- Frequently perform desk-based computer tasks, use telephone, writing by hand, sort/file paperwork.
- Occasionally stand/walk, lift/carry objects weighing 11-20 pounds.
- Rarely reach/work above shoulder.
* - Consistent with its obligations under the law, the University will provide reasonable accommodation to any employee with a disability who requires accommodation to perform the essential functions of his or her job.
- Routine extended working hours during peak cycles; travel to school/unit sites across university.
- Occasional late night/weekend work.
- Interpersonal Skills: Demonstrates the ability to work well with Stanford colleagues and clients and with external organizations.
- Promotes Culture of Safety: Demonstrates commitment to personal responsibility and value for safety; communicates safety concerns; uses and promotes safe behaviors based on training and lessons learned.
- Subject to and expected to comply with all applicable University policies and procedures, including but not limited to the personnel policies and other policies found in the Universitys Administrative Guide, http://adminguide.stanford.edu.
Location: Residential & Dining Enterprises
Job Code: 4452