Financial Analyst

Location: Palo Alto, CA

Job Description
CORE DUTIES*:

Help monitor financial activity Maintenance and Capital Projects. Participate in preparation of Division-level, Department-level and Group-level variance reports on a monthly basis using OBI and Report Mart 3 reporting tools. Identify areas of concern. Identify, analyze, report on, and discuss trends and variances with managers at various levels.
Process Invoices, including review, tracking, obtaining proper approvals, reconciliation to Purchase Order, trouble shooting, following-up on payments, alerting managers/requestors to problems and insufficient funding, liaising unit managers and project managers.
Create Open Commitments and Expense detail reports for departments on a monthly basis to help monitor financial activity. Assist departments with expenses and commitments review to ensure that charges are not misapplied, and that outstanding commitment balances are accurate. Assist operators with tracking of balances on blanket service agreements.
Perform fund statement and balance sheet reconciliations.
Perform month-end and year-end close activities: perform monthly accruals to ensure that expenses are booked in Oracle as they are incurred; prepare journal entries as necessary to ensure that expenses and revenues are booked to correct accounts.
Manage MCP billing to third parties (currently Maintenance billing), to include transactions audit, follow-up, preparation of monthly feeder journals and detailed billing reports as necessary.
Work with groups and Accounts Payable and Contracts specialists to reduce the backlog of outstanding commitments, open invoices, etc., in order to minimize the need for accruals in the long run.
Perform moderately complex finance functions, including structured analysis; conduct data mining; identify, clarify, and investigate discrepancies and exceptions; proactively develop solutions and processes.
Maintain, reconcile, review, combine, and validate moderately complex financial data sets, including large volumes of data, financial reports, financial databases, and key financial information.
Run and analyze moderately complex financial reports, often from multiple systems; assist in preparation of management information reports.
Resolve transactional inquiries, escalate broader issues, and respond in a professional and timely manner.
Participate as a member of a team; support new initiatives; cooperate and adapt to changes and processes. Participate in change management strategy through communication and collaboration with others.
Understand and participate in cross training on core functions in work area or unit; serve as a back-up to other functions.
Analyze budget and financial information, input and review system data, summarize and develop reports/charts for presentations.
Design and perform ad hoc analyses; develop and maintain complex data models, perform sensitivity analysis, analyze large complex data sets, and reconcile complex accounts.
Identify and resolve complex issues which may span multiple areas; apply ingenuity and creativity to problem 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.
Develop and maintain desktop procedures and process documentation for multiple areas 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.
Execute internal control programs established by management, research new regulations, and recommend and implement approved changes. Manage compliance program for area of responsibility, and create complex compliance reports.
May supervise, train, coach, and review the work of other staff, as needed. Contribute primarily through applying individual expertise.
* – Other duties may also be assigned

MINIMUM REQUIREMENTS:

Education & Experience:

Bachelor’s degree and four years of relevant experience or combination of education and relevant experience