Staff Data Analyst

Western Alliance Bank - Dallas, TX

Full-time - Mid Level

Dallas, TX

Credit Intermediation and Related Activities

About the position

The Staff Data Analyst at Western Alliance Bank plays a crucial role in driving Enterprise Data & Analytics solutions, particularly for Regulatory Reporting. This position involves collaborating with business and technology teams to ensure data requirements are met, documenting data profiling results, and providing expertise in analytics and visualization. The analyst will also mentor other team members and contribute to data quality management, enterprise data warehouse solutions, and data governance activities.

Responsibilities

• Partner with the Data Product Manager, Data Architects, and Data Engineering Manager to ensure data analysis is addressed in the data product development lifecycle for Regulatory Reporting Solutions.
• Develop, implement, and support processes and best practices for data exploration, profiling, quality, and mapping for Regulatory Reporting Solutions.
• Define source to target mapping for data transformations in Regulatory Reporting data solutions.
• Collaborate with business data owners to execute data profiling and source data analysis for Regulatory Reporting.
• Participate in data governance activities with Enterprise Data Stewards and Business Data Governance.
• Develop and manage data lineage, business rules, reference data, and mapping documents in the Metadata Management Tool.
• Apply data analysis skills to data quality and governance processes or data flows for the enterprise data warehouse and analytics data stores.
• Prepare analysis findings and communicate them to business and technical stakeholders.
• Create data visualizations using Power BI to explain data analysis recommendations.

Requirements

• Bachelor's degree in engineering, MIS, or Data & Analytics or equivalent experience.
• 6+ years' experience with data analysis related to enterprise data management, including data warehousing and source to target mapping.
• Strong experience with RDBMS and query languages such as T-SQL, PL/SQL, Spark SQL.
• Strong experience using analytics tools such as SPSS, SAS, Tableau, PowerBI.
• Strong experience with data profiling/wrangling tools like Informatica IDMC, Alteryx, Paxata, Trifacta, Tamlr.
• Strong experience with common file formats such as CSV, TEXT, JSON, XML, XSD.
• Excellent problem-solving and analytic skills.
• Excellent communication skills, both verbal and written.

Nice-to-haves

• Banking or financial services industry experience with Regulatory Reporting or in a highly regulated industry.
• Experience in Agile, SAFe, and/or Scrum methodologies.
• Experience working in a data governance function.
• Experience integrating with data quality, data catalog, and data lineage tools.
• Certifications within Azure such as Azure Fundamentals, Azure Data Engineer, Azure Data Scientist, and/or Azure DevOps Engineer.
• Experience integrating and using data science or statistical solutions.

Benefits

• Wellness program
• Health insurance
• Dental insurance
• Tuition reimbursement
• 401(k) matching