Staff Engineer II - Master Data Management

Western Alliance Bank • Phoenix, AZ

17h • Onsite

About The Position

As a Staff Engineer II, you'll provide expertise in a suite of technical tools and products in a given domain to ensure solutions are safe, secure, compliant and reliable. You'll identify, develop, and support needs, as well as taking on design responsibilities supporting project tasks. As the Staff Engineer II, you'll facilitate dialogue and activities to ensure team collaboration, including teams outside of your domain. You'll develop effective presentations and narratives for their teams. The Staff Engineer II will contribute to or oversee data solutions in areas such as implementing enterprise data warehouse and analytics data store solutions, including analysis of source systems, source-to-target mapping, and built-in data quality; supporting Data Governance, including data profiling for source systems, identifying critical data elements, and managing the business glossary; and assisting with ad hoc business inquiries by extracting data from primary and secondary sources using SQL queries or PowerBI dashboards. 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. Lead the design, development, and maintenance of MDM solutions using Profisee, including data models, workflows, business rules, and user interfaces. Develop and implement data quality rules and processes within Profisee to ensure data accuracy and consistency. Design, develop, and implement match and merge functionalities, as well as hierarchical structures, utilizing Profisee. Establish and implement survivorship rules, business rules, and workflow automations. Diagnose and resolve long-running processes, as well as memory and CPU performance concerns. Address and correct scheduling inefficiencies within the system. Design and implement Azure DevOps CI/CD pipelines to facilitate the deployment of Profisee deliverables, while also providing comprehensive support for deployment processes, monitoring, and performance diagnostics. Design and implement data integration processes between Profisee and other enterprise systems using various integration techniques (API, ETL, etc.). Participate in the full MDM implementation lifecycle, including requirements gathering, design, development, testing, deployment, and support. Proficiency in SQL, ETL tools such as Azure Data Factory, SSIS etc., and other relevant technologies used in MDM implementations. Collaborate with cross-functional teams and business stakeholders to define master data domains, hierarchies, and data models aligned with business objectives and data governance principles. Design, develop, and deploy enterprise-grade data engineering solutions utilizing Azure Data Factory, Synapse Analytics, Azure DevOps, and related technologies. Design and implement end-to-end ETL and data pipeline solutions managing the full data lifecycle for Western Alliance Bank and partner systems. Review Azure Data Factory pipelines, Synapse artifacts, and scripts from data engineering teams to ensure quality standards are met. Provide thorough, actionable feedback on all deliverables. Ensure Profisee remains safe, secure, compliant, & reliable by ensuring all operational & security practices & controls are followed. Stay current on Profisee roadmap & identify opportunities for ED&A Architecture Runway to leverage Profisee for value-add opportunities.

Requirements

• 7+ years of related experience with MDM solutions using Profisee or any other MDM tools.
• 3+ years’ experience designing, implementing, and supporting cloud data solutions; Azure Data Lake Storage, Azure Data Factory, Azure Data Services, Azure Logic Apps etc.
• Bachelor's degree in related field required.
• Intermediate level experience with at least one RDBMS and query language such as T-SQL, PL/SQL, Spark SQL.
• Intermediate level experience in conceptual, logical, and physical data design.
• Proficiency in SQL, ETL tools such as Azure Data Factory, SSIS etc., and other relevant technologies used in MDM implementations.
• Advanced speaking and writing communication skills.

Nice To Haves

• Previous leadership experience preferred.
• Certifications within Azure such as Azure Fundamentals, Azure Data Engineer, Azure Data Scientist, and/or Azure DevOps Engineer preferred.
• Familiarity with multi-cloud data management and transformation platforms or tools such as Databricks, Snowflake etc.
• Experience integrating with data quality, data catalog and data lineage tools 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.

Responsibilities

• 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.
• Contribute to or oversee data solutions in areas such as implementing enterprise data warehouse and analytics data store solutions, including analysis of source systems, source-to-target mapping, and built-in data quality.
• Support Data Governance, including data profiling for source systems, identifying critical data elements, and managing the business glossary.
• Assist with ad hoc business inquiries by extracting data from primary and secondary sources using SQL queries or PowerBI dashboards.
• 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.
• Lead the design, development, and maintenance of MDM solutions using Profisee, including data models, workflows, business rules, and user interfaces.
• Develop and implement data quality rules and processes within Profisee to ensure data accuracy and consistency.
• Design, develop, and implement match and merge functionalities, as well as hierarchical structures, utilizing Profisee.
• Establish and implement survivorship rules, business rules, and workflow automations.
• Diagnose and resolve long-running processes, as well as memory and CPU performance concerns.
• Address and correct scheduling inefficiencies within the system.
• Design and implement Azure DevOps CI/CD pipelines to facilitate the deployment of Profisee deliverables, while also providing comprehensive support for deployment processes, monitoring, and performance diagnostics.
• Design and implement data integration processes between Profisee and other enterprise systems using various integration techniques (API, ETL, etc.).
• Participate in the full MDM implementation lifecycle, including requirements gathering, design, development, testing, deployment, and support.
• Collaborate with cross-functional teams and business stakeholders to define master data domains, hierarchies, and data models aligned with business objectives and data governance principles.
• Design, develop, and deploy enterprise-grade data engineering solutions utilizing Azure Data Factory, Synapse Analytics, Azure DevOps, and related technologies.
• Design and implement end-to-end ETL and data pipeline solutions managing the full data lifecycle for Western Alliance Bank and partner systems.
• Review Azure Data Factory pipelines, Synapse artifacts, and scripts from data engineering teams to ensure quality standards are met.
• Provide thorough, actionable feedback on all deliverables.
• Ensure Profisee remains safe, secure, compliant, & reliable by ensuring all operational & security practices & controls are followed.
• Stay current on Profisee roadmap & identify opportunities for ED&A Architecture Runway to leverage Profisee for value-add opportunities.

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
• Opportunity to bolster 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!

What This Job Offers

• Job Type: Full-time
• Career Level: Senior