Financial Analyst III

City National Bank; Los Angeles (CA); On-site; USD 61,000 - 105,000; Full time

Benefits offered by this job

Healthcare coverage

401(k) company matching

Tuition reimbursement

Time Away benefits

Fertility benefits

Career mobility support

Colleague Resource Groups

Job summary

City National Bank is seeking a Financial Analyst III in Los Angeles to support budgeting, forecasting, and financial performance analysis. You will work with the Manager of Budgeting and Analysis on annual budgeting, quarterly forecasts, and acquisition analyses, enabling data-driven decisions across lines and staff groups.

The role requires strong Excel skills, VBA macros, and experience with large datasets, plus the ability to collaborate across teams on special projects while maintaining

Qualifications

• Bachelor's Degree or equivalent.
• Minimum of 3 - 5 years of financial analysis experience required.
• Minimum of 3 years advanced Excel experience including minimum of 1 year complex formula/function development, writing macros in VBA, and utilizing PivotTables and other methods to manipulate large datasets.
• Minimum of 2 years of experience working in Microsoft Office.

Responsibilities

• Responsible for the Budgeting/Forecasting Model’s system maintenance and enhancement.
• Maintains, enhances and produces the Funds Transfer Pricing (FTP) and Monthly Operating Performance Reporting.
• Conducts financial analysis and problem solving in the performance reporting and transfer pricing.
• Coordinates, consolidates and analyzes the annual budget and quarterly forecast.
• Provides financial analysis and planning support to line/staff groups; assists in acquisition analysis; works on special projects as needed.
• Maintains a proactive commitment to Bank programs such as CustomerFirst, CRA and Equal Employment Opportunity.

Skills

Advanced Excel

PivotTables

VBA Macros

Financial analysis

Data manipulation

Communication skills

Education

Bachelor's Degree or equivalent

Tools

Microsoft Office

MS Access

ODBC

Report Writers

GL Systems

Job description

FINANCIAL ANALYST III

WHAT IS THE OPPORTUNITY?

Works with Manager of Budgeting and Analysis to perform annual budgeting monthly financial performance analysis, quarterly financial forecasting, cost/profitability studies, acquisition analysis and special projects; assists in providing financial analysis and planning support to the line and staff organizations.

WHAT WILL YOU DO?

• Responsible for the Budgeting/Forecasting Model’s system maintenance and enhancement.
• Works with the Manager and/or other analysts to maintain, enhance and produce the Funds Transfer Pricing (FTP) and Monthly Operating Performance Reporting.
• Works with the Manager and/or other analysts to conduct financial analysis and problem solving in the performance reporting and transfer pricing.
• Works with the Manager and/or other analysts to coordinate, consolidate and analyze the annual budget and quarterly forecast.
• Provides financial analysis and planning support to the line/staff groups. Assists in performing acquisition analysis. Works with the Manager on special projects as needed.
• Maintains a proactive commitment to established Bank programs, such as CustomerFirst, Community Reinvestment Act (CRA) and Equal Employment Opportunity.

WHAT DO YOU NEED TO SUCCEED?

Required Qualifications*

• Bachelor's Degree or equivalent
• Minimum of 3 - 5 years of financial analysis experience required.
• Minimum of 3 years advanced Excel experience including minimum of 1 year complex formula/function development, writing macros in VBA, and utilizing PivotTables and other methods to manipulate large datasets.
• Minimum of 2 years of experience working in Microsoft Office

Additional Qualifications

• Experience with MS Access, ODBC, Report Writers, GL Systems, Query Tools (Brio, Business Objects, etc.), Data Manipulation/Compilation. VBA experience a plus.
• Ability to accurately, thoroughly and efficiently handle/analyze a high data volume; organize analyzed data into simple, complete and concise presentation formats; envision the global issue, separate symptoms from causes, research thoroughly; weigh costs/benefits and derive sound conclusions.
• Ability to perform financial and economic analyses at a macro and micro level and effectively explain cause and effect
• Ability to analyze large amounts of data from disparate sources and formulate a supportable conclusion
• Ability to prioritize tasks and handle multiple projects at the same time, working under tight deadlines.
• Effective verbal/written communication skills to interact with all levels of Bank personnel and strong analytical skills required.
• Applies advanced skills to the position.
• Adapts procedures, processes and techniques to accomplish the requirements of the position.
• Duties and tasks reflect substantial variety and complexity.
• May serve as a resource to others in the resolution of complex problems and issues.
• Must be able to think through complex problems and develop solutions
• Relies on experience and judgment to plan and accomplish assigned tasks and goals.
• Must be able to work independently and in teams.

WHAT'S IN IT FOR YOU?

Compensation

Starting base salary: $60,500 - $104,500 per year. Exact compensation may vary based on skills, experience, and location. This job is eligible for bonus and/or commissions.

Benefits and Perks

• Comprehensive healthcare coverage, including Medical, Dental and Vision plans, available the first of the month following start date
• Generous 401(k) company matching contribution
• Career Development through Tuition Reimbursement and other internal upskilling and training resources
• Valued Time Away benefits including vacation, sick and volunteer time
• Specialized health and family planning benefits including fertility benefits, and cancer, diabetes and musculoskeletal support programs
• Career Mobility support from a dedicated recruitment team
• Colleague Resource Groups to support networking and community engagement

Get a more detailed look at our Benefits and Perks.

ABOUT US

Since day one we've always gone further than the competition to help our clients, colleagues and communities flourish. City National Bank was founded in 1954 by entrepreneurs for entrepreneurs and that legacy of integrity, community and unparalleled client relationships continues today. City National is a subsidiary of Royal Bank of Canada, one of North America’s leading diversified financial services companies. To learn more about City National and our dynamic company culture, visit us at About Us.

INCLUSION AND EQUAL OPPORTUNITY EMPLOYMENT

City National Bank fosters an inclusive environment where all forms of diversity are valued and leveraged to make us a better company and employer. We are an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sexual orientation, gender identity, national origin, disability, veteran status or other basis protected by law.

It is unlawful in Massachusetts to require or administer a lie detector test as a condition of employment or continued employment. An employer who violates this law shall be subject to criminal penalties and civil liability.

*Represents basic qualifications for the position. To be considered for this position, you must at least meet the required qualifications. careers.cnb.com accepts applications on an ongoing basis, until filled.

Unless otherwise indicated as fully remote, reporting into a designated City National location is an essential function of the job.