Staff ETL Developer

Western Alliance Bank - Grove City, OH

Full-time - Mid Level

Grove City, OH

Credit Intermediation and Related Activities

About the position

The Staff ETL Developer at Western Alliance Bank is responsible for developing and deploying data extracts, transformations, and loads to support data ingestion and transformation using Azure Data Factory and SSIS packages. This role requires a creative and motivated developer who can thrive in a fast-paced, agile environment, ensuring optimal performance of database processes and contributing to continuous improvements of existing applications.

Responsibilities

• Develop and deploy data extracts, transformations, and loads using Azure Data Factory and SSIS packages.
• Provide database administration support for on-prem and cloud databases.
• Collaborate with different teams to understand complex business logic and design ETL processes.
• Deliver data warehouse ETL processes designed by data architects in SSIS & SQL stored procedures.
• Develop reports using SSRS & SQL stored procedures.
• Analyze and provide suggestions to tune database stored procedures for optimal performance.
• Troubleshoot and fine-tune database configurations, ETL processes, and SQL code.
• Maintain database standards and documentation patterns for all applications.
• Adhere to data security and integrity policies.
• Participate in all aspects of the software engineering process in an Agile environment.

Requirements

• 5+ years of solid experience in SQL development.
• 5+ years of hands-on experience in ETL design and development using Microsoft SQL Server ETL tools or Informatica.
• 4+ years in database administration.
• 3+ years' experience in Azure Data Factory.
• Good understanding of data cleansing, normalization, standardization, enrichment, fuzzy match techniques, and data governance concepts.
• Excellent troubleshooting and problem-solving skills.
• Outstanding SQL and data analysis skills.
• Experience in analyzing and building reports/dashboards using BI reporting tools such as Tableau.
• Experience in BI development, database development, and SQL Database.

Benefits

• Competitive salaries
• Ownership stake in the company
• Medical and dental insurance
• Time off
• 401k matching program
• Tuition assistance program
• Employee volunteer program
• Wellness program