Credit Portfolio Risk Analyst I - Phoenix, United States - Western Alliance Bank

Western Alliance Bank Phoenix, United States

3 weeks ago

Full time

Description

Job Title:
Credit Portfolio Risk Analyst I - ETL and Warehouse

Location:
CityScape

What you'll do:
The Portfolio Credit Risk Management department is a high performing, dynamic team within Western Alliance Bank. The ETL and SQL Data Analyst - Portfolio Credit Risk will take an ownership role in populating the Bank's loan and deposit data warehouses with responsibilities including data sourcing, ingestion, integration, validation, and reconciliations to the general ledger. The ETL and SQL Data Analyst - Portfolio Credit Risk will have recurring production responsibilities as well as project or ad hoc duties; both requiring a high attention to detail. Critical to success in this position is an understanding of SQL, SSIS and database concepts, as well as the ability to document and follow procedures. Additionally, the position requires independent problem solving, adaptability to changing priorities, a sense of urgency, on-time delivery and the ability to support diverse projects. This position requires an understanding of banking concepts, and an aptitude for learning new technology. This position interacts with personnel in WAB's Information Technology, Accounting, Loan Servicing and other business groups.

What we are looking for:

Responsibilities:

Responsible for loading and certifying one or more of the Bank's loan and deposit data warehouses, including data validation, and reconciliations. Loads must be conducted in accordance with procedures and data quality artifacts produced.
Creates and/or uses existing tables, views, stored procedures and SSIS packages in the execution of regular duties.
Proposes improvements to processes, gains approval, documents and implements upgrades.
Completes assigned projects, which may be individual or team projects and include acquiring new data sources (due to new products, new business acquisitions, new system implementations, etc.), defining/documenting transformations required to load, writing load scripts and testing.
Effectively applies technical expertise and software knowledge to address complex projects. Proficient / expert in the Microsoft suite of technologies including Visual Studio and Management Studio.
Manages a pipeline of data and process related projects, identifying and elevating road blocks and executing within designated time frames.
Serves as the point of contact to internal customers for ad hoc extracts and support for assigned areas of responsibility.
Uses excellent communication skills to keep manager, team and customers apprised of project statuses.

Qualifications:

Bachelor degree in Accounting; Business Management; Economics; Finance; Statistics; MIS or equivalent
1-3+ years of technical experience with ETL, including expert or near expert level SQL proficiency and proficiency with SSIS
Expert level skills with Microsoft Office Suite, with emphasis on Excel and Pivot Tables.
1-3+ years of experience in the Banking or Financial Services industry preferred
Experience with Alteryx preferred
Progress toward CFA, CPA, CAIA, CFM, DBA or other related designation preferred

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 is a wholly owned subsidiary of Western Alliance Bancorporation. Alliance Bank of Arizona, Alliance Association Bank, Bank of Nevada, Bridge Bank, First Independent Bank, and Torrey Pines Bank are divisions of Western Alliance Bank; Member FDIC. AmeriHome Mortgage is 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 or call 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

Corporate Risk Analyst Ii

1 week ago

Glacier Bancorp Phoenix, United States

**About The Role** · **Summary** · Under the direction of the GBCI Director of Risk Management, the Corporate Risk Analyst uses problem solving, analytical, project management, and organizational skills, as well as bank/risk knowledge to coordinate a variety of risk management fu ...
Corporate Model Risk Analyst Ii

2 weeks ago

Glacier Bancorp Phoenix, United States

**About The Role** · **Summary** · Under the supervision of the Model Risk Manager, the Model Risk Analyst II - Credit will use quantitative expertise, critical thinking, problem solving, and analytical skills in the bank's Model Risk Management (MRM) program to ensure compliance ...
Risk Analyst

3 weeks ago

DriveTime Automotive Group, Inc. Tempe, United States

**What's Under the Hood** · DriveTime Family of Brands includes in-house financing and servicing through Bridgecrest, which is one of the country's leading financial servicing providers. Bridgecrest services roughly $17 billion in finance receivables for DriveTime and other third ...
Risk Management Analyst

2 weeks ago

Public Storage Glendale, United States

**Company Description** Public Storage** is recognized as one of **America's Best Large Employers** in 2022 by Forbes and our employees have also voted us as a **Great Place to Work in 2022 and 2023**, having **Best Career Growth**, ranked us in the **Top 5% for Work Culture**, a ...
Risk Management Analyst

1 week ago

Public Storage Glendale, United States

**Company Description** Public Storage** is recognized as one of **America's Best Large Employers** in 2022 by Forbes and our employees have also voted us as a **Great Place to Work in 2022 and 2023**, having **Best Career Growth**, ranked us in the **Top 5% for Work Culture**, a ...
Cyber Risk Analytics Analyst

2 weeks ago

Procom Phoenix, United States

Cyber Risk Analytics Analyst Intro · We are seeking a detail-oriented and experienced Cyber Risk Analytics Analyst to join our dynamic team. In this role, you will be responsible for creating and managing metrics and Key Risk Indicators (KRIs), developing insightful analytics ar ...
ERM Risk Senior Analyst

1 week ago

Western Alliance Bank Phoenix, United States

Job Title: · ERM Risk Senior Analyst · Location: · CityScape · What you'll do: · Western Alliance Bank Corporation is currently seeking a highly qualified and experienced Second Line of Defense Technology, Information Security and Third-Party Risk Senior Analyst to join our IT/ ...
ERM Risk Senior Analyst

3 weeks ago

Western Alliance Bank Phoenix, United States

Job Title: · ERM Risk Senior Analyst · Location: · CityScape · What you'll do: · Western Alliance Bank Corporation is currently seeking a highly qualified and experienced Second Line of Defense Technology, Information Security and Third-Party Risk Senior Analyst to join our ...
Senior Credit Risk Analyst

1 week ago

BECU Phoenix, United States

Senior Credit Risk Analyst - Credit Card/Other Unsecured page is loaded · Senior Credit Risk Analyst - Credit Card/Other Unsecured · Apply · locations · Remote, WA · Remote, TX · Remote, ID · Remote, SC · Remote, OR · time type · Full time · posted on · Posted Yesterd ...
Senior Analyst, Credit Risk

3 weeks ago

Broadstone Net Lease, Inc. Phoenix, United States

The Senior Analyst, Credit Risk will conduct in-depth financial analysis for Broadstone Net Lease. This position will support the timely and accurate production of detailed financial analysis and prepare and present financial reports, findings, and recommendations to inform decis ...
Senior Analyst, Credit Risk

3 weeks ago

Broadstone Real Estate Phoenix, United States

At BNL, we're as passionate about people as we are about real estate. · BNL is a collaborative, inclusive, and creative workplace where people with unique talents can flourish, their opinions are valued, and their contributions are recognized. Our professionals enjoy fascinating ...
Senior Analyst, Credit Risk

3 weeks ago

Broadstone Net Lease, LLC Phoenix, United States

Job Description · Job DescriptionThe Senior Analyst, Credit Risk will conduct in-depth financial analysis for Broadstone Net Lease. This position will support the timely and accurate production of detailed financial analysis and prepare and present financial reports, findings, an ...
Senior Analyst, Credit Risk

1 week ago

Broadstone Real Estate Phoenix, United States

At BNL, we're as passionate about people as we are about real estate. · BNL is a collaborative, inclusive, and creative workplace where people with unique talents can flourish, their opinions are valued, and their contributions are recognized. Our professionals enjoy fascinating ...
Senior Financial Risk Analyst ALM

3 weeks ago

Western Alliance Bank Phoenix, United States

The Sr Financial Risk Analyst is part of the second line of defense in Corporate Risk reporting to the ALM Risk Director and Head of Financial Risk Management (FRM). The individual is a key strategic partner that will help shape strategic decisions a Risk Analyst, Risk, Financial ...
Credit Portfolio Risk Analyst I

3 weeks ago

Western Alliance Bank Phoenix, United States

The Portfolio Credit Risk Management department is a high performing, dynamic team within Western Alliance Bank. The ETL and SQL Data Analyst Portfolio Credit Risk will take an ownership role in populating the Banks loan and deposit data warehouse Risk Analyst, Risk, Portfolio, W ...
Senior Financial Risk Analyst ALM

3 weeks ago

Western Alliance Bank Phoenix, United States Full time

Job Title: · Senior Financial Risk Analyst ALM · Location: · CityScape · What you'll do: · The Sr Financial Risk Analyst is part of the second line of defense in Corporate Risk reporting to the ALM Risk Director and Head of Financial Risk Management (FRM). The individual is a key ...
Senior Financial Risk Analyst ALM

1 week ago

Western Alliance Bank Phoenix, United States

Job Title: · Senior Financial Risk Analyst ALM · Location: · CityScape · What you'll do: · The Sr Financial Risk Analyst is part of the second line of defense in Corporate Risk reporting to the ALM Risk Director and Head of Financial Risk Management (FRM). The individual is a k ...
Cbb Risk Customer Remediation Data Analyst

2 days ago

U.S. Bank National Association Tempe, United States

At U.S. Bank, we're on a journey to do our best. Helping the customers and businesses we serve to make better and smarter financial decisions and enabling the communities we support to grow and succeed. We believe it takes all of us to bring our shared ambition to life, and each ...
Senior Financial Risk Analyst- Governance

3 weeks ago

Western Alliance Bank Phoenix, United States Full time

Job Title: · Senior Financial Risk Analyst- Governance · Location: · CityScape · What you'll do: · As a Sr Financial Risk Analyst, you will be responsible for supporting the overall governance and control function for Financial Risk Management, ensuring compliance with key regula ...
Sr. Catastrophe Risk Management Analyst

3 weeks ago

Homesite Services Phoenix, United States

This position leads, supports, and executes catastrophe risk management tasks and projects in conjunction with related teams in the organization. · Will lead and design projects and solutions with other parts of the organization to solve catastrophe risk business problems. · Wi ...