City National Bank · 3 hours ago
Portfolio Analyst Credit III
City National Bank is a subsidiary of Royal Bank of Canada, focused on providing exceptional financial services. The Portfolio Analyst Credit III will design and generate reports to support credit portfolio management, maintain a database reporting system, and produce analytical models to identify risk trends.
BankingFinanceFinancial Services
Responsibilities
Prepare and generate internal and external reports
Develop and support the delivery of information to assist tactical and strategic programs
Design and maintain database applications, reports/lists, statistics, graphics, etc. to provide credit analytics
Develop quantitative methods to measure credit and financial performance
Maintain and utilize system to gather and analyze credit and financial data
Analyze data and review for reasonableness a large volume of monthly credit activity and financial data. Reconcile with general ledger
Design and execute controls
Coordinate and obtain access to data and identifies technical resources for project support. Work with colleagues to define their information requests
Proactively troubleshoot for the best solution given the strategic direction of the division
Prepare documentation of any project/activity assigned
Recommend, update, or design new reports and useful tools to measure performance
Maintain a current awareness and understanding of appropriate banking laws, regulations, internal policies and procedures, and to comply fully with those laws, regulations, policies and procedures
Qualification
Required
Bachelor's Degree or equivalent
Minimum 3 years experience in a credit environment
Minimum 5 years experience working in data analysis
Minimum 5 years of experience with SAS or SQL, or other data management, reporting and query tools (Sharepoint, SAP, Business Objects, Tableau, Crystal reports/Dashboard, etc)
Preferred
Expert knowledge of PC computing environments, extensive experience with database reporting using query tools such as Brio, SQL, Python, Tableau and Excel
Prior banking experience and extensive experience writing and developing reports, and financial modeling
Excellent process management and problem solving skills
Ability to independently design and tailor solutions to the required objectives
Good knowledge of accounting and financial analysis techniques
Strong analysis and reporting skills
Excellent verbal and written communication skills
Benefits
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
Company
City National Bank
City National Bank offers a full complement of banking, trust and investment services. It is a sub-organization of City National.
H1B Sponsorship
City National Bank has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (76)
2024 (78)
2023 (145)
2022 (93)
2021 (107)
2020 (62)
Funding
Current Stage
Public CompanyTotal Funding
unknown1978-01-13IPO
Leadership Team
Recent News
UPSTATE BUSINESS JOURNAL
2025-12-18
Venture Capital Firms
2025-11-08
Company data provided by crunchbase