SQL Developer II - ETL & Warehouse at Western Alliance Bank

SQL Developer II - ETL & Warehouse for Western Alliance Bank – Phoenix, AZ

Job Description: Develop SQL views, stored procedures, SSIS packages and other database objects as part of the Portfolio Credit Risk Analytics Team. Work closely with the team to populate the company’s loan and deposit data warehouses. Create and use existing tables, views, stored procedures and SSIS packages. Responsible for sourcing data, ingestion, integration and validation. Propose improvements to processes, gain approval, and document and implement upgrades. Manage a pipeline of data-related projects, identify and elevate road blocks, and execute the projects within the designated timeframes. Complete assigned projects that include acquiring new data due to new products, business acquisitions or system implementations, along with defining and documenting transformations required to load, and writing load scripts and testing. Serve as the main point of contact to internal customers for ad hoc extracts. Provide support for assigned areas of responsibility. Keep the manager, team and customers apprised of project status.

Job Requirements: Requires a Master’s degree or foreign equivalent in Computer Science, Management Information Systems, or a related field. Requires 3 years of experience with Master’s degree. Must have some experience in each of the following skills: T-SQL and SQL objects in SQL servers; SQL Server Analysis Services (SSAS); SQL Server Management Studio (SSMS); SQL Server Integration Services (SSIS) database administration; SQL, SSIS and database concepts, and the ability to document and follow procedures; Database security Tableau reporting from SQL databases; Multi-server database structures; and Visual Studio and Management Studio

How to apply: Mail resume to: Attn: Western Alliance Bank HR, One East Washington Street, Ste. 1400, Phoenix, AZ 85004. Please reference ID #199.