Financial Analyst - Portfolio Management, Assistant Vice President

Company: Union Bank
Location: Walnut Creek
Posted on: November 26, 2022

Job Description:

Are you passionate about creating an exceptional client experience?

Discover your opportunity with Union Bank -, a division of the Mitsubishi UFJ Financial Group (MUFG), the 5th largest financial group in the world. At Union Bank, we have our clients' best interest in mind and draw on more than 160 years of experience to understand their distinct needs to tailor our solutions. We're part of 180,000 colleagues around the globe striving to be the world's most trusted financial group, knowing that trust starts with a culture of putting people first and empowering you to achieve your potential.

Join Union Bank, where being inspired is expected and creating results is rewarded.

Job Summary:

Community Development Finance ("CDF") provides real estate construction, permanent loans, and tax credit equity investments, and is a leader in affordable housing finance in California. The Portfolio Financial Analyst is responsible for supporting the Portfolio Management team for CDF.

Responsibilities include, but not limited to the following:

In this role you will work closely with and support the supervisor on the monthly accounting, quarterly reporting, and other finance processes. You will assist in maintaining databases accuracy for reporting and financial analysis purposes, including owning and developing portfolio financial summaries, ensuring books and records / transactions are accurate and complete. Responsibilities include:

Review annual financial statement and tax returns for CDF's investment portfolio, including review of CDF's Syndication Fund financial statement and tax returns.

Perform financial analysis and interpretation, supporting the investment portfolio. Contributing with investor reporting duties. Confidently analyze financial operations in conjunction with underwriting, project-level agreements, partnership, appraisals, including property level performance analysis for CDF's portfolio.

Forecast preparation and ownership over flux analysis and how transactions impact the future forecast and other PM team members, requiring quantitative and qualitative analysis.

Ownership over the accounting and finance aspect of Disposition related matters (Disposition Memos, yield proof, cash flow analysis, Gain/Loss analysis, coordination w/ other stakeholders including different departments and within the Portfolio Management team)

Prepare transactions for the database (such as equity projection updates, tax return and financial statement updates) and month end reconciliations.

Additional responsibilities may include invoice processing or reviews, check and wire review/preparation for Non-Interest Income and Operating Expense forecast.

Ownership over monthly month-end close preparation and memo of notable items and track open items to follow-up and resolve.

Prepare and own QuickBooks Fund Financials workpaper and VIE work product, including impairment workpapers, CDF sponsored fund financials, Bank Recons, address UB sponsored fund and investor related inquiries.

Collaborate with internal and external partners (such as SOX team, Corporate Tax Department, Business Unit Controllers, Investors, Auditors, etc.) for any quarterly reporting and deliverables.

Own efficiency projects, operational improvement projects, and other ad-hoc special projects and analyses as directed.

Qualifications:

5+ years of public accounting, finance, and/or FP&A experience or equivalent, with a working knowledge of Partnership Tax Returns or working experience in tax accounting.

Experience in affordable housing is a plus.

Advanced working knowledge of U.S. GAAP Accounting to propose journal entries (Fund Financials, etc.).

Advanced Excel and PowerPoint skills to interpret formulas and understand the intended goal.

Self-starter, quick learner, operates with a high degree of accuracy

Exceptional ability to work with large sets of data, think critically to recognize discrepancies, correlations and anomalies through analysis & problem-solving capabilities.

Extraordinary ability to work proactively and independently, multi-task to adhere to strict deadlines while performing a variety of complex tasks without compromising quality and competing deadlines.

Excellent communication (verbal & written) skills. sense of ownership, and receptive to coaching.

#LI-Onsite

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 on the basis of race, color, national origin, religion, gender expression, gender identity, sex, age, ancestry, marital status, protected veteran and military status, disability, medical condition, sexual orientation, genetic information, or any other status of an individual or that individual's associates or relatives that is protected under applicable federal, state, or local law.

#LI-Onsite%11401842%

Keywords: Union Bank, Walnut Creek , Financial Analyst - Portfolio Management, Assistant Vice President, Professions , Walnut Creek, California