Risk Data Analyst II -ETL and Warehouse

Job Title:

Location:

What you'll do:

• 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 preferred

What 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