Staff Engineer I - Data Engineer

Western Alliance Bancorporation; Phoenix (AZ); Sur place; USD 130 000 - 180 000; Plein temps

Avantages offerts par ce poste

Dental insurance

Tuition assistance

401(k) matching

Employee volunteer program

Wellness program

Résumé du poste

Western Alliance Bank, a subsidiary of Western Alliance Bancorporation, seeks a Staff Engineer I - Data Engineer to lead enterprise data initiatives. You will design, build, and deploy data solutions ensuring security, compliance, and reliable data flows to support regulatory reporting.

You will collaborate with data stewards, analysts, and architects to refine requirements, implement CI/CD, and optimize architecture for analytics, using Azure Data Factory, Synapse, and Power BI.

Qualifications

• 5+ years in ETL and data warehousing, Azure/Data Factory/Synapse preferred.
• 2+ years cloud data solutions, Azure Data Lake/Data Services experience preferred.
• Strong SQL (T-SQL/PL-SQL) and data design knowledge.

Responsabilités

• Design, develop and deploy data engineering solutions with Azure tools.
• Lead CI/CD pipelines and ensure quality standards per bank guidelines.
• Mentor team members and collaborate with stakeholders to refine requirements.

Connaissances

Data engineering

ETL concepts

Azure Databricks

Formation

Bachelor's degree in engineering or related field

Masters or MBA preferred

Outils

Azure Data Factory

Azure Synapse Analytics

Databricks

Power BI

Informatica

Excel

Description du poste

dental insurance, tuition assistance, 401(k)

United States, Arizona, Phoenix

Job Title:

Staff Engineer I - Data Engineer

Location:

Block 23

What you'll do:

As a Senior Data Engineer, you will serve as a Subject Matter Expert in the Enterprise Data & Analytics domain, as well as in adjacent areas, ensuring that data engineering solutions are safe, secure, compliant, and reliable. You will be responsible for designing, building, and implementing critical components of the enterprise data platform, aligning with the strategic data and analytics objectives of Western Alliance Bank. In this role, you will identify development and support requirements and take ownership of large, complex design initiatives, playing a crucial part in supporting project deliverables.

As a Senior Data Engineer, you will be a pioneer in our modern data platform, collaborating directly with data stewards, data analysts, data engineers, enterprise architects, and business stakeholders to refine requirements and shape the objectives of enterprise data solutions. You will be part of a high-performing, centralized team of data engineers, developing solutions that address the complete data lifecycle management needs of our enterprise data platforms. Demonstrating exceptional technical expertise, you will also mentor and guide team members, fostering a culture of excellence and continuous learning.

• Design, develop and deploy data engineering solutions with Azure Data Factory, Synapse Analytics, and Azure DevOps to support Western Alliance Bank's 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 you'll need:

• 5+ 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.
• Bachelor's degree in engineering or related field; Masters or MBA in related field preferred.
• 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.
• Certifications within Azure such as Azure Fundamentals, Azure Data Engineer, Azure Data Scientist, and/or Azure DevOps Engineer preferred.
• 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.
• Experience in Agile, SAFe, and/or Scrum preferred.
• Experience integrating with data quality, data catalog and data lineage tools preferred.
• Advanced to expert knowledge of general Financial Services or Banking preferred.
• Advanced to expert knowledge of applicable regulatory and legal compliance obligations, rules and regulations, industry standards and practices.
• Advanced to expert experience in leading cross-functional teams and managing multiple projects simultaneously with an established expertise in one or more key domains of the bank (Deposits, Loans, Operations or Reporting) with the ability to walk-through top-level process design. Capable of collaborating with regulatory partners like the CFPB, OCC and FRB through audits and collaboration efforts as situations arise.
• Advanced to expert familiarity with the capability model across IT and the applications and infrastructures available for engagement in solutioning across the bank to develop results that leverage existing capabilities in addition to implementing innovative solutions when required. Experience in the design, enhancement, and compliance to all governance frameworks across the IT organization to ensure proper compliance with published procedures and standards.
• 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, Member FDIC, is a wholly owned subsidiary of Western Alliance Bancorporation. Serving clients nationwide, Western Alliance Bank includes six legacy bank brands - Alliance Association Bank, Alliance Bank of Arizona, Bank of Nevada, Bridge Bank, First Independent Bank and Torrey Pines Bank - that remain part of the company's heritage, as well as AmeriHome Mortgage, 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 [e-mail] 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.