Financial Data Analyst

  • Full-time

Company Description

Phoenix American is a leader in the field of securitization administration and accounting. For over thirty years the Phoenix American family of companies has specialized in creating lease and loan portfolios and has securitized six of its own structured transactions. Directly involved in the securitization market since 1995, today Phoenix American manages securitized aviation assets appraised at over $9 billion.

Our long history of success attests to Phoenix American's peerless industry knowledge, skilled and seasoned professional staff and solid relationships with major players in the securitization industry.

  • Aircraft Lessors
  • Investment Banks
  • Investors
  • Trustees
  • Rating Agencies
  • Auditing and Accounting Firms
  • Law Firms
  • Appraisers

Job Description

Job heading: Financial Data Analyst with GL accounting and banking experience

Job Summary: Maintain or develop processes and databases (including MS Access) for several data reporting projects, back-up daily AP duties if needed, lead role in banking relationships for client and corporate bank accounts.

Current Job Duties:

· Maintain MS Access application for daily upload process of banking transaction details to support monthly reconciliation, daily cash planning and forecasting, report distribution and client cost allocations. Separately, developed an MS Access data base application supporting daily cash receipt reporting and report distribution thereby enabling reduced usage of legacy system.

· Maintain cash basis management budget reporting system utilizing Oracle data integrated into an MS Access data base application using report writer to detail month and year to date actual, budget and variance data. Expense data was incorporated with billing data to create operating division cash based Profit and Loss statements.

· A/P lead on current reinstallation / upgrade from Oracle 10.7 to Oracle R12 applications, training of staff, documenting procedures and defining new and revised processes.. Responsible for supplier data load using Excel to Oracle of approximately 1,750 vendor sites, downloading and cleaning old data, testing,

· Lead on banking relationships for client and corporate bank accounts. Manage processes including ACHs / NACHA files, positive-pay controls and electronic deposit activities as issues arrise. Download of monthly bank transactions to Access. Create and maintain queries and reporting to Excel.

· Back-up to Cash Management staff to support client requirements and process corporate payable and deposit transactions.

· Additional responsibilities may include GL close and financial statement preparation for corporate US subsidiary and Irish affiliate, download and journal payroll expense distribution.

Qualifications

Essential Intermediate to Advance skill level in:

· MS Excel

· MS Access

· Crystal Reports

· Oracle Financials (Release 12 is a plus)

Additional Information

Candidate Profile:


· Seeks to enhance knowledge and skills.
· Adapts to new situations and changing work responsibilities.

· Places emphasis on getting results.
· Functions as an effective team member.
· Interacts and cooperates to assist others.

· Addresses issues and makes suitable suggestions.

This is a full-time, non-exempt position at our San Rafael, CA main office.

EQUAL OPPORTUNITY EMPLOYER