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.
Implement methods to include unstructured data and big data.
Review Azure Data Factory pipelines, Synapse artifacts, and other scripts developed by data engineers and provide feedback to ensure all deliverables meet quality standards.
Requirements
Bachelor's degree in engineering or related field; Masters or MBA in related field preferred.
3+ 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.
Previous leadership experience required.
Expert level experience with at least one RDBMS and query language such as T-SQL, PL/SQL, Spark SQL.
Expert 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.
Adva
Additional Information
Job Title:
Principal Engineer I - Lead Data Engineer
Location:
Block 23
Westernalliancebank · Phoenix, AZ