Western Alliance Bank is looking to solve technical problems related to data engineering, including designing and implementing reliable and secure solutions, developing effective presentations and narratives, and ensuring compliance with IT policies and industry standards.
Requirements
- 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.
- Advanced working in Microsoft Azure DEVOPS, Office & relevant Diagramming Software (e.g. Lucid, Visio, etc.)
Responsibilities
- 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.
- 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.
Other
- 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.
- Advanced speaking and writing communication skills.
- May require up to 25% travel.
