Financial Analyst III
City National Bank
Don’t send a generic resume — generate a resume and cover letter tailored to this exact role.
Benefits offered by this job
Job summary
City National Bank is seeking a Financial Analyst III to join our Budgeting and Analysis team in Los Angeles. You will collaborate with the Manager to perform annual budgeting, monthly financial performance analysis, quarterly forecasting, and acquisition analyses, supporting various line and staff groups.
You will maintain budgeting/forecasting models, generate FTP and operating performance reports, and deliver concise analyses.
Qualifications
- Bachelor's degree or equivalent
- Minimum of 3 - 5 years of financial analysis experience
- Minimum of 3 years advanced Excel experience including minimum of 1 year complex formula/function development, writing macros in VBA, and PivotTables
- 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 performance reporting and transfer pricing.
- Coordinates, consolidates and analyzes the annual budget and quarterly forecast.
- Provides financial analysis and planning support; assists in acquisition analysis and special projects.
- Adheres to Bank programs such as CustomerFirst, CRA and Equal Employment Opportunity.
Skills
Education
Tools
Job description
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.
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.
- 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.
- 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
- 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.
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.
- 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.
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.
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.
'/%3e%3cpath%20d='M101.744%2012.4726L102.894%2016.1947L99.0021%2013.2201L101.744%2012.4726ZM105.3%208.40937H100.488L99.0026%203.59473L97.5116%208.41047L92.7%208.40385L96.5965%2011.3834L95.1055%2016.1942L99.0021%2013.2196L101.408%2011.3834L105.3%208.40992V8.40937Z'%20fill='white'/%3e%3cdefs%3e%3clinearGradient%20id='paint0_linear_5593_1381'%20x1='90'%20y1='9.44471'%20x2='99'%20y2='9.44471'%20gradientUnits='userSpaceOnUse'%3e%3cstop%20stop-color='%2300AD70'/%3e%3cstop%20offset='0.998594'%20stop-color='%2300B67A'/%3e%3cstop%20offset='1'%20stop-color='%23DCDCE6'/%3e%3c/linearGradient%3e%3c/defs%3e%3c/svg%3e){kind=small}
