Western Alliance Bank
Risk Data Analyst II -ETL and Warehouse
Western Alliance Bank, Phoenix, Arizona, United States, 85003
Risk Data Analyst II - ETL and Warehouse
Location: CityScape The Portfolio Credit Risk Management department is a high performing, dynamic team within Western Alliance Bank. 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. Access Analytical Data Store or other data repositories to meet the reporting needs of various customers within the Bank. Proposes improvements to existing processes, obtains approval, completes documentation 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. Understand business unit reporting and analytical needs and translate business questions into analytical tasks that help drive strategic decisions. Present analytical findings and recommendations to senior management and key stakeholders. 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. Bachelor's degree in related field required. Intermediate experience with data analysis tools (e.g., SQL, Excel). 3+years of related experience in Banking, Data Analytics, Data Management or similar field. Experience with project management and managing multiple priorities and deliverables. Intermediate experience presenting findings from large datasets in a clear, actionable way. 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! 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.
Location: CityScape The Portfolio Credit Risk Management department is a high performing, dynamic team within Western Alliance Bank. 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. Access Analytical Data Store or other data repositories to meet the reporting needs of various customers within the Bank. Proposes improvements to existing processes, obtains approval, completes documentation 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. Understand business unit reporting and analytical needs and translate business questions into analytical tasks that help drive strategic decisions. Present analytical findings and recommendations to senior management and key stakeholders. 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. Bachelor's degree in related field required. Intermediate experience with data analysis tools (e.g., SQL, Excel). 3+years of related experience in Banking, Data Analytics, Data Management or similar field. Experience with project management and managing multiple priorities and deliverables. Intermediate experience presenting findings from large datasets in a clear, actionable way. 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! 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.