Common Table Jobs in Phoenix, AZ (NOW HIRING)

Job Title:

Credit Portfolio Analyst II

Location:

CityScape

What you'll do:

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.

What you'll need:

• 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. Experience developing Python-based solutions in Databricks and Microsoft Fabric environments is a plus.
• 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.

Benefits you'll love:
We offer all the important things you'd want - like 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, and a wellness program. In addition, you'll have the opportunity to bolster your 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!

About the company:

Western Alliance Bank, Member FDIC, is a wholly owned subsidiary of Western Alliance Bancorporation. Serving clients nationwide, Western Alliance Bank includes six legacy bank brands - Alliance Association Bank, Alliance Bank of Arizona, Bank of Nevada, Bridge Bank, First Independent Bank and Torrey Pines Bank - that remain part of the company's heritage, as well as AmeriHome Mortgage, a Western Alliance Bank Company.

Western Alliance Bancorporation is committed to equal employment and will consider all qualified applicants without regard to race, sex, color, religion, age, nation origin, marital status, disability, protected veteran status, sexual orientation, gender identity or genetic information. Western Alliance Bancorporation is committed to working with and providing reasonable accommodations for individuals with disabilities. If you are an individual with a disability and require a reasonable accommodation to complete any part of the application process and/or need an alternative method of applying, please email HR@westernalliancebank.com or call 602-386-2488. When contacting us, please provide your contact information and state the nature of your accessibility issue. We will only respond to inquiries concerning requests that involve a reasonable accommodation in the application process.

Western Alliance Bancorporation