Senior Data Engineer
Western Alliance Bank
full-time
Posted on:
Location Type: Office
Location: Phoenix • Arizona • Ohio • United States
Visit company websiteExplore more
Job Level
About the role
- Provide expertise in a suite of technical tools and products in a given domain to ensure solutions are safe, secure, compliant and reliable
- Identify develop and support needs, as well as taking on design responsibilities supporting project tasks
- Facilitate dialogue and activities to ensure team collaboration including teams outside of your domain
- Develop effective presentations and narratives for their teams
- Champion data quality and discipline in the full data lifecycle
- Partner closely with enterprise architects to understand and implement solutions based on the recommended Azure Cloud data architecture and capabilities
- Know and/or learn modern automation and integration methods and tools, with Cloud-First design patterns, frameworks, critical thinking, and problem-solving skills
- 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
- Implement data engineering solutions that satisfy the full data lifecycle including efficient technical hygiene and the use of Azure DevOps for the implementation of the Western Alliance Bank Regulatory Reporting and Analytics strategy and roadmap
- Develop ETL and data pipeline capabilities considering how data is created, transformed, maintained, stored, archived, analyzed, and shared across Western Alliance Bank and our partners
- Implement Azure DevOps CI/CD pipelines in accordance with Western Alliance Bank technical standards
- Implement data governance and data quality controls in all data solutions in accordance with enterprise standards
- Apply Test Driven Development methodology to all data solution design and implementations
- Implement methods to include unstructured data and big data
- Lead the implementation of outcomes, recommendations, and designs from Data Governance and Enterprise Architecture
- Actively participate in making data architecture decisions
- Collaborate with product owners and business stakeholders to gain a working understanding of business requirements and operational processes
- Provide technical mentorship to team members and other data professionals
- Perform data exploration and data profiling with tools such as Informatica Intelligent Data Management Cloud and/or SPSS when needed.
Requirements
- 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
- 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 preferred
- Bachelor’s degree in engineering or related field or equivalent experience in data management and/or data analytics
- 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
- Expert level experience with at least one RDBMS and query language such as T-SQL, PL/SQL, Spark SQL
- Experience in conceptual, logical, and physical data design
- Experience with design tools as it relates to creating conceptual architecture diagrams and data flow diagrams such as Visio, Archimate, Lucid Chart
- Familiarity with data science and analytics tools such as SAS, Tableau, PowerBI
- Familiarity with multi-cloud data management and transformation platforms or tools such as Databricks, Snowflake, Matillion, etc.
- Experience in Agile, SAFe, and/or Scrum is preferred
- Experience integrating with data quality, data catalog and data lineage tools is preferred
- Certifications within Azure such as Azure Fundamentals, Azure Data Engineer, Azure Data Scientist, and/or Azure DevOps Engineer is preferred
- Banking or financial services industry experience or other highly regulated industry experience
- Experience implementing Large Financial Institution (LFI) Regulatory Reporting data solutions is preferred
- Advanced speaking and writing communication skills
- May require up to 25% travel.
Benefits
- 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
- a wellness program
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard Skills & Tools
data engineeringETLAzure Data LakeAzure Data FactoryAzure SynapseAzure Logic AppsAzure DevOpsRDBMST-SQLdata design
Soft Skills
leadershipcollaborationproblem-solvingcommunicationconflict resolutionrisk mitigationmentorshipstrategic planningcritical thinkingorganizational alignment
Certifications
Azure FundamentalsAzure Data EngineerAzure Data ScientistAzure DevOps Engineer