This job has expired, please see additional jobs below
Financial Analysis Manager
Union Bank
Walnut Creek, CA, United States
Job Details - this job has expired, please see similar jobs below
Prepare comprehensive and complex financial forecast and budget. Conduct and direct the equity investment modeling process for evaluation of new transactions. Demonstrate exceptional Excel skills to operate the equity pricing model. Develop and enhance the financial model for loan forecast and spread evaluation use. Perform ad hoc financial analysis projects.
Major Responsibilities:
(30%) Periodic Forecast & Annual Budget: Prepare the periodic financial forecast & budget. Demonstrate strong ability to translate business assumptions to forecasted financial data. Provide precise written summary with the underlying assumptions & a summary of the financial results to management. Conduct trend analysis & variance explanations for the Loan Portfolio as well as overall CDF financial results based on Management Accounting view. Exhibit a thorough understanding of the allocation mechanism on SRC and prepare a written summary on findings. Evaluate & identify opportunities to improve the financial tools (loan forecast model, equity database, equity investment model) for planning use.
(40%) Equity Investment Pricing Model: Develop and run Excel financial models for new & existing tax credit investment transactions. Establish financial assumptions and critical decision variables. Test for consistency and validity. Collaborate with relationship managers and run the pricing model to derive accurate projections for tax & book accounting purpose. Keep abreast on new financing and other issues in the LIHTC industry and be able to incorporate new requirements onto the model. Validate adjustor calculation based on the final tax projections & terms set forth in the legal documents.
(10%) Syndication Fund Accounting: Supervise / perform the annual accounting and review of the syndicated funds to ensure that yield commitment is met. Work with external CPAs for the annual tax season duties. Coordinate efforts with other CDF members to perform all necessary tasks to complete the final pricing adjustments.
(20%) Special Projects: May conduct and direct complex financial studies on such topics as risk-based capital allocation methodologies, interest rate analysis, data extract and design issues. Provide written analysis and interpretation of results. Collaborate with other units of the bank and external vendors where necessary. Assigned projects may involve implementation of databases, business processes, or data quality assurance initiatives as well as management reporting. Maintain financial systems or databases including monthly validation and related reporting structure. Run complex reports and/or program. May supervise one staff, including hiring, firing, motivating, coaching, and training
Qualifications
Typically requires a BS/BA degree in Accounting or Tax and a minimum of 10+ years of relevant experience. Knowledge of partnership & corporate income tax as well as low income housing industry is a big plus. CPA certification in California is desirable. Requires excellent excel skills with the ability to conduct complex financial analysis. Candidates with less experience will be considered for a lower grade position.
The above statements are intended to describe the general nature and level of work being performed. They are not intended to be construed as an exhaustive list of all responsibilities duties and skills required of personnel so classified.
We are proud to be an Equal Opportunity / Affirmative Action Employer and committed to leveraging the diverse backgrounds, perspectives, and experience of our workforce to create opportunities for our colleagues and our business. We do not discriminate in employment decisions on the basis of any protected category.
A conviction is not an absolute bar to employment. Factors such as the age of the offense, evidence of rehabilitation, seriousness of violation, and job relatedness are considered in all employment decisions. Additionally, it's the bank's policy to only inquire into a candidate's criminal history after an offer has been made. Federal law prohibits banks from employing individuals who have been convicted of, or received a pretrial diversion for, certain offenses.