Disability Solutions - Phoenix, AZ
posted 4 months ago
Western Alliance Bank is seeking a passionate, results-driven SQL/ETL Developer to deliver innovative, industry-leading solutions. We want a creative, highly-motivated developer who can take initiative, has a good sense of urgency, and is comfortable working in a fast-paced, agile environment. The role involves the design, development, and deployment of data extracts, transformations, or loads, supporting the ingestion and transformation of data as needed using Azure Data Factory and SSIS packages. Key responsibilities include providing database administration support for on-prem and cloud databases, working with different teams to understand complex business logic, and designing ETL processes. The developer will design and develop data warehouse ETL processes in SSIS and SQL stored procedures, analyze business user requirements, assess different source data from banking applications, and design data flow to implement ETL processes using Microsoft SSIS tools. Additionally, the role involves developing reports using SSRS and SQL stored procedures, analyzing and providing suggestions to tune database stored procedures for optimal performance, troubleshooting and fine-tuning database configurations, and adhering to all data security and integrity policies. The developer will also contribute to continuous improvements of existing applications, conduct code reviews, and maintain documentation patterns for all applications. Active participation in all aspects of the software engineering process is expected, and the developer will efficiently work in an Agile environment.