Credit Portfolio Analyst II: Python & SQL

Western Alliance Bancorporation; Phoenix (AZ); On-site; USD 75,000 - 110,000; Full time

Benefits offered by this job

Medical and dental insurance

401k matching program

Tuition assistance program

Employee volunteer program

Wellness program

Job summary

Western Alliance Bancorporation is seeking a Credit Portfolio Analyst II to support the LFI-aligned risk, data ecosystem, and analytics workflows. The role emphasizes Python, SQL, data transformation logic, and API integrations across systems.

You will contribute to scalable, controlled processes within Credit Administration. Responsibilities include collaborating with IT and Business Data Governance, developing data load pipelines, dashboards, and monitoring KRIs/RCAs.

Qualifications

• 3+ years of related experience in Accounting, Finance, Economics or similar field.
• Bachelor's degree in related field required.
• Knowledge of general banking operations and financial products.
• Familiar with regulatory and legal compliance obligations.
• Experience writing test cases and documentation.
• Advanced MS Excel skills (pivot tables, XLOOKUP, logic).
• Advanced Python for data analytics; Databricks & Fabric is a plus.
• Advanced SQL (window functions, CTEs) and data structures.
• Strong problem-solving, prioritization, and on-time delivery.
• Experience navigating codebases in version control systems.

Responsibilities

• Support Credit Portfolio leadership by creating or using database objects and reporting tools.
• Develop data transformations, load scripts, and test pipelines.
• Build reporting dashboards and monitor KRIs, RCSA, and concentration limits.
• Collaborate with IT and Business Data Governance; work cross-functionally on projects.
• Address data issues across multiple systems and automate where possible.

Skills

Python

SQL

MS Excel

Data analytics

Communication

Problem solving

Databricks

Microsoft Fabric

Version control

Education

Bachelor's degree

Tools

Databricks

Microsoft Fabric

Git

Job description

Western Alliance Bancorporation is seeking a Credit Portfolio Analyst II to support the LFI-aligned risk, data ecosystem, and analytics workflows. The role emphasizes Python, SQL, data transformation logic, and API integrations across systems.

You will contribute to scalable, controlled processes within Credit Administration. Responsibilities include collaborating with IT and Business Data Governance, developing data load pipelines, dashboards, and monitoring KRIs/RCAs.