Title: Senior Data Analyst – Staff Engineer I
Location: Phoenix, AZ
Duration:: 12 Months
US Citizens and Green cards are Preferred.
What you'll do:
The Senior Data Analyst is a catalyst for driving Enterprise Data & Analytics solutions. This person is accountable to ensure the alignment of data requirements between business and technology teams by working alongside business teams to understand business process and data flows. The Senior Data Analyst documents results of data profiling to facilitate decision making with executive and senior business data owners. Additionally, this person is required to provide expertise in analytics and visualization as it relates to Western Alliance Bank's enterprise data warehouse and business line data marts.
In this position, the Senior Data Analyst is hands-on in developing and publishing analysis artifacts as well as is a mentor to other analysts on the Enterprise Data & Analytics Team. The Senior Data Analyst will contribute to or provide leadership oversight to data solutions in the following three areas:
- Implementing data quality management, including the development of the data quality rules for critical data elements based on the selected data quality dimensions and designing the data quality results database, dashboard, integration with our business glossary, and the automation of the process
- Implementing enterprise data warehouse solutions, including the analysis for source systems, source to target mapping, and built-in data quality
- Assist with Data Governance, including the data profiling for source systems, critical data element identification, and business glossary management
This exciting opportunity requires the best of your data analysis, problem solving and collaboration skills. The Senior Data Analyst will contribute to the development of cross-business unit data solutions that are leveraged to improve our products and insights.
The ideal candidate has strong business and technical analysis experience, a growth mindset, is outcome-focused, and fosters teamwork.
Essential Functions:
- Partner with the Data Product Manager, Data Architects, and Data Engineering Manager to ensure data analysis is addressed in the product development lifecycle
- Develop, implement, and support the processes and best practices for data exploration, data profiling, data quality and data mapping required for the tactical implementation of the Western Alliance Bank data strategy and roadmap
- Collaborate with business data owners to execute data profiling and source data analysis for critical Western Alliance Bank applications and systems
- Participate in data governance activities by partnering with the Enterprise Data Stewards as required
- Participate and contribute to the data issues resolution process within our Data Governance function
- Develop and manage the data lineage, business rules (data quality, cleansing, transformation rules, etc.), reference data, and mapping documents across the enterprise in the Metadata Management Tool
- Apply data analysis skills to the data quality/data governance process and/or to the data flows required to engineer the enterprise data warehouse
- Prepare analysis findings and communicate to both business and technical stakeholders
- Create data visualizations to explain data analysis recommendations
Minimum Qualifications
- Bachelor's Degree in Engineering, MIS, or Data & Analytics or equivalent experience
- 5+ years' experience with data analysis specifically as it relates to enterprise data management including data warehousing and source to target mapping
- Strong experience with RDBMS and query language such as T-SQL, PL/SQL, Spark SQL
- Strong experience using analytics tools such as SPSS, SAS, Tableau, PowerBI
- Strong experience using data profiling/wrangling tools (Example: IDQ (preferred), Alteryx, Paxata, Trifacta, Tamlr, etc.)
- Strong experience using common file formats such as CSV, TEXT, JSON, XML, XSD, etc.
- Excellent problem solving and analytic skills
- Excellent communication skills, both verbal and written, and ability to work collaboratively within a team, business stakeholders and executives
Preferred Qualifications
- Experience in Agile, SAFe, and/or Scrum
- Experience working in a data governance function
- Experience integrating with data quality, data catalog and data lineage tools is a plus
- Certifications within Azure such as Azure Fundamentals, Azure Data Engineer, Azure Data Scientist, and/or Azure DevOps Engineer
- Banking or financial services industry experience or other highly regulated industry experience
- Experience integrating and using data science or statistical solutions