Staff Engineer II - Senior Data Engineer

Job Title:

Location:

What you'll do:

• Lead the strategic planning of a project as it relates to technical solution design.
• Design and implement engineering principles aimed at reliability practices and sound recovery procedures.
• Design transaction specific application performance monitoring metrics that can be captured and passed to business partners.
• Develop and maintain technical documentation, including system configurations and procedures while also ensuring compliance with IT policies, procedures, and industry standards. Develop desktop procedures when needed that others follow.
• Analyze business user requirements, Asses different source data of banking applications and design data flow to implement ETL process using Microsoft SSIS tool and Azure data factory.
• Develop Power BI reports using DAX, analytical data sources, external data sources, and API calls.
• Analyze and provide suggestions to tune SQL queries to ensure optimal performance.
• Troubleshoot and fine tune database configurations, ETL processes and SQL code for optimal performance.
• Advanced working in Microsoft Azure DEVOPS, Office & relevant Diagramming Software (e.g. Lucid, Visio, etc.), as well as technical aptitude & experience within a specific domain.
• Efficiently work in Agile environment

What you'll need:

• 7+ years of related experience IT App Support, IT Development, IT Networking, or similar field.
• Bachelor's degree in related field required.
• Previous leadership experience preferred.
• Must have expertise in SQL development.
• Hands on proficiency in BI design and development.
• 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.
• Good understanding with development life cycle, data architect and related methodologies.
• 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 you'll love:
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!

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 HR@westernalliancebank.com or call 602-386-2488. 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