Portfolio Analyst Credit III jobs in United States
cer-icon
Apply on Employer Site
company-logo

City National Bank · 13 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
check
H1B Sponsor Likelynote

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

Data analysisSASSQLFinancial modelingDatabase reportingPythonTableauProcess managementCommunication skillsProblem solving

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

company-logo
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 Company
Total Funding
unknown
1978-01-13IPO

Leadership Team

leader-logo
Howard Hammond
CEO City National Bank
linkedin
leader-logo
Fiyaz Khan
Senior Vice President, Structured Products
linkedin
Company data provided by crunchbase