Staff Engineer II Senior Data Engineer

Job Title:

Location:

What youll do:

• Desing develop and deploy data engineering solutions with Azure Data Factory Synapse Analytics and Azure DevOps to support Western Alliance Banks regulatory reporting and LFI strategy.
• Develop data engineering solution designs that can be handed off to data engineering teams for execution ensuring the reuse of components wherever feasible to maximize efficiency.
• Develop ETL and data pipeline capabilities considering how data is created transformed stored archived analyzed and shared across Western Alliance Bank and our partner systems.
• Implement Azure DevOps CI/CD pipelines for all data solutions in adherence to Western Alliance Bank technical standards.
• Apply Test Driven Development methodology to all data solutions designed built and implemented.
• Lead the implementation of outcomes recommendations and designs from Data Governance and Enterprise Architecture.
• Lead the migration of multidimensional cubes to tabular models optimizing data architecture for enhanced analytics and performance.
• Utilize Power BI to design deploy and visualize tabular cubes ensuring seamless business intelligence integration and actionable insights.
• Perform data exploration and data profiling with tools such as Excel and Informatica.
• Actively participate in making data architecture decisions.
• Provide technical mentorship to team members and other data professionals.
• Collaborate with product owners and business stakeholders to gain a working understanding of business requirements and operational processes.
• Implement built-in quality and compliance- by-design in all data solutions.
• Review Azure Data Factory pipelines Synapse artifacts and other scripts developed by data engineers and provide feedback to ensure all deliverables meet quality standards.

What youll need:

• 7 years experience with data engineering specifically in Extract Transform and Load (ETL) concepts and processes enterprise data warehouse capabilities database principles and other related tools and technologies; preferably strong in Azure Data Factory Azure Synapse Analytics and/or Databricks.
• 2 years experience designing implementing and supporting cloud data solutions; Azure Data Lake Azure Data Factory Azure Data Services Azure Synapse Azure Logic Apps and Azure DevOps experience strongly preferred.
• Bachelors degree in related field required.
• Advanced level experience with at least one RDBMS and query language such as T-SQL PL/SQL Spark SQL.
• Advanced level experience in conceptual logical and physical data design.
• Familiarity with data science and analytics tools such as SAS Tableau Power BI.
• Familiarity with multi-cloud data management and transformation platforms or tools such as Databricks Snowflake etc.
• Previous leadership experience preferred.
• Intermediate to advanced knowledge of general Financial Services or Banking is preferred.
• Advanced knowledge of applicable regulatory and legal compliance obligations rules and regulations industry standards and practices.
• Advanced proven experience in leading cross-functional teams and managing multiple projects simultaneously. Additional experience with pipeline development and leveraging Azure DevOps while working on multiple projects simultaneously.
• Advanced ability to see the big picture and align projects with organizational goals. Capable of leading and motivating cross-functional teams. Expertise in resolving conflicts and addressing challenges as well as skilled at identifying and mitigating risks at the project level. Proficient in governance patterns tied to intake technical reviews and architectural compliance.
• Advanced speaking and writing communication skills.
• May require up to 25% travel.

Benefits youll love:
We offer all the important things youd 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 addition youll 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 or call . 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