Credit Portfolio Analyst II

Western Alliance Bank • Phoenix, AZ

14h • Onsite

About The Position

The Credit Portfolio Analyst II works in Credit Administration and supports the institution’s LFI aligned risk, credit, and data ecosystem by managing analytical workflows, enhancing system functionality, and contributing to scalable and controlled processes appropriate for a Category IV bank. This role places strong emphasis on Python, SQL for troubleshooting data issues, validating results, and understanding data transformation logic. This role also requires familiarity working with API’s and integrated data sources to support analytics requests that span multiple systems and require data integration or automation. Critical to success in this position is the ability to display a high level of independent problem solving, prioritization, adaptability, on-time implementation and the ability to support diverse projects/problems. Responsible for supporting the Credit Portfolio leadership in creating or using various database objects, reporting tools, or other Bank approved technology in the execution of regular duties and proposing improvements to processes, gains approval, documents and implements upgrades. Partner with IT and Business Data Governance as required. Complete assigned projects, which may be individual or team projects and include acquiring new data sources, defining and documenting transformations required to load, writing load scripts and testing. Independently frame requirements for moderately complex data and business processes. Develop reporting dashboards, monitoring concentration limits, KRIs, RCSA or other projects. Apply technical expertise and software knowledge to address complex projects and manage a pipeline of data, reporting, and process related projects, identifying and elevating road blocks and executing within designated time frames. Participate in the development of relevant policies, procedures, methodologies and training and collaborate with Credit Administration group. Collaborate cross functionally on projects.

Requirements

• 3+ years of related experience in Accounting, Finance, Economics or similar field
• Bachelor's degree in related field required.
• Intermediate knowledge of general banking operations, including deposit operations, loan administration, treasury management and/or other commercial banking products and services.
• Intermediate knowledge of applicable regulatory and legal compliance obligations, rules and regulations, industry standards and practices.
• Intermediate to advanced experience in application testing skills to be able to create test cases and for documentation.
• Intermediate to advanced MS Excel skills and the ability to create pivot tables, perform XLOOKUPs, use conditional logic, compare data, and banking applications.
• Intermediate to advanced Python experience, specifically relating to data analytics with a solid understanding of common data science libraries.
• Intermediate to advanced SQL experience with knowledge of advanced syntax (window functions, common table expressions, etc) and an understanding of data structures.
• Intermediate ability to independently problem solve, adapt to changing priorities, act with a sense of urgency, on-time delivery and support diverse projects.
• Experience navigating and searching codebases in version control systems to support data troubleshooting and data quality validation.
• Intermediate speaking and writing communication skills.

Nice To Haves

• Experience developing Python-based solutions in Databricks and Microsoft Fabric environments is a plus.

Responsibilities

• Manage analytical workflows, enhance system functionality, and contribute to scalable and controlled processes.
• Troubleshoot data issues, validate results, and understand data transformation logic using Python and SQL.
• Work with APIs and integrated data sources for analytics requests spanning multiple systems, requiring data integration or automation.
• Support Credit Portfolio leadership in creating or using database objects, reporting tools, and other Bank-approved technology.
• Propose improvements to processes, gain approval, document, and implement upgrades.
• Partner with IT and Business Data Governance.
• Complete assigned projects, including acquiring new data sources, defining and documenting transformations, writing load scripts, and testing.
• Frame requirements for moderately complex data and business processes.
• Develop reporting dashboards, monitor concentration limits, KRIs, RCSA, or other projects.
• Apply technical expertise and software knowledge to address complex projects.
• Manage a pipeline of data, reporting, and process-related projects, identifying and elevating roadblocks, and executing within designated time frames.
• Participate in the development of relevant policies, procedures, methodologies, and training.
• Collaborate with the Credit Administration group and cross-functionally on projects.

Benefits

• Competitive salaries
• An ownership stake in the company
• Medical and dental insurance
• Time off
• A great 401k matching program
• Tuition assistance program
• An employee volunteer program
• A wellness program
• Opportunity to bolster business knowledge, learning the ins and outs of how successful companies operate and manage their finances, giving you invaluable hands-on experience to help grow your career!

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level