Financial Analyst III

Financial Analyst IIIWorks 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.Required Qualifications*Bachelor's Degree or equivalentMinimum of 3 - 5 years of financial analysis experience required.Minimum of 3 years advanced Excel experience including 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 OfficeAdditional QualificationsExperience 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 effectAbility to analyze large amounts of data from disparate sources and formulate a supportable conclusionAbility 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 solutionsRelies on experience and judgment to plan and accomplish assigned tasks and goals.Must be able to work independently and in teams.CompensationStarting 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 PerksComprehensive healthcare coverage, including Medical, Dental and Vision plans, available the first of the month following start dateGenerous 401(k) company matching contributionCareer Development through Tuition Reimbursement and other internal upskilling and training resourcesValued Time Away benefits including vacation, sick and volunteer timeSpecialized health and family planning benefits including fertility benefits, and cancer, diabetes and musculoskeletal support programsCareer Mobility support from a dedicated recruitment teamColleague Resource Groups to support networking and community engagementSince 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.