Risk Data Analyst II -ETL and Warehouse

Company: Disability Solutions
Location: Phoenix
Posted on: January 23, 2025

Job Description:

Job Title:Risk Data Analyst II -ETL and WarehouseLocation:CityScapeWhat 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.

• 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
  • 5+ 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.
  • 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 preferredWhat you'll need: 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 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

Keywords: Disability Solutions, Prescott , Risk Data Analyst II -ETL and Warehouse, Professions , Phoenix, Arizona