Staff IT Analyst III - Senior Data Analyst at Western Alliance Bancorporation

Phoenix, Arizona, United States -

Full Time

Start Date

Immediate

Expiry Date

04 Jul, 26

Salary

0.0

Posted On

05 Apr, 26

Experience

5 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

Data analysis, Data warehousing, Regulatory reporting, T-SQL, PL/SQL, Spark SQL, PowerBI, Tableau, SPSS, SAS, Data profiling, Data quality management, Source to target mapping, Metadata management, Financial services, Critical thinking

Industry

Banking

Description

Job Title: Staff IT Analyst III - Senior Data Analyst Location: Block 23 What you'll do: The Senior Data Analyst is a catalyst for driving Enterprise Data & Analytics solutions, specifically the data solutions required for Regulatory Reporting including Large Financial Institution requirements. 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 Staff 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 Regulatory Reporting Analytics Data Store. 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 in the Team. The Staff 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 and analytics data store 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. • Assist with ad hoc business inquiries by extracting the data from primary and secondary sources using SQL queries and/or PowerBI dashboards. 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 the processes and best practices for data exploration, data profiling, data quality and data mapping required for the implementation of the Western Alliance Bank Regulatory Reporting Solutions. Define source to target mapping for the data transformations required in the end-to-end Regulatory Reporting data solutions. Collaborate with business data owners to execute data profiling and source data analysis for source systems needed for Regulatory Reporting. Participate in data governance activities by partnering with the Enterprise Data Stewards and Business Data Governance. 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 and/or analytics data stores. Prepare analysis findings and communicate to both business and technical stakeholders. Create data visualizations using Power BI to explain data analysis recommendations. What you'll need: 7+ years’ experience with data analysis specifically as it relates to enterprise data management including data warehousing and source to target mapping. Bachelor's degree in related field required. 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: Informatica IDMC (preferred), Alteryx, Paxata, Trifacta, Tamlr, etc.). Strong experience using common file formats such as CSV, TEXT, JSON, XML, XSD, etc. Experience integrating with data quality, data catalog and data lineage tools is preferred. Intermediate knowledge of general Financial Services or Banking is preferred. Intermediate knowledge of applicable regulatory and legal compliance obligations, rules and regulations, industry standards and practices. Advanced in process and data analysis within a specific domain or functional area utilizing demonstrated critical thinking skills. Advanced working in Microsoft Office & relevant Diagramming Software (e.g. Lucid, Visio, etc.), as well as technical aptitude & experience within a specific domain. Advanced speaking and writing communication skills. Occasional travel required. Benefits you’ll love: We offer all the important things you'd want — like 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, and a wellness program. In addition, you’ll have the opportunity to bolster your 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! About the company: Western Alliance Bank is a wholly owned subsidiary of Western Alliance Bancorporation. Alliance Bank of Arizona, Alliance Association Bank, Bank of Nevada, Bridge Bank, First Independent Bank, and Torrey Pines Bank are divisions of Western Alliance Bank; Member FDIC. AmeriHome Mortgage is a Western Alliance Bank company. Western Alliance Bancorporation is committed to equal employment and will consider all qualified applicants without regard to race, sex, color, religion, age, nation origin, marital status, disability, protected veteran status, sexual orientation, gender identity or genetic information. Western Alliance Bancorporation is committed to working with and providing reasonable accommodations for individuals with disabilities. If you are an individual with a disability and require a reasonable accommodation to complete any part of the application process and/or need an alternative method of applying, please email HR@westernalliancebank.com or call 602-386-2488. When contacting us, please provide your contact information and state the nature of your accessibility issue. We will only respond to inquiries concerning requests that involve a reasonable accommodation in the application process. © Western Alliance Bancorporation About Western Alliance Bancorporation With more than $80 billion in assets, Western Alliance Bancorporation (NYSE:WAL) is one of the country’s top-performing banking companies. Through its primary subsidiary, Western Alliance Bank, Member FDIC, clients benefit from a full spectrum of tailored commercial banking solutions and consumer products, all delivered with outstanding service by industry experts who put customers first. Major accolades include being ranked as a top U.S. bank in 2023 by American Banker and Bank Director. Serving clients across the country wherever business happens, Western Alliance Bank operates individual, full-service banking and financial brands with offices in key markets nationwide. For more information, visit Western Alliance Bancorporation. For more information, visit Western Alliance Bank online. Terms & Notices Privacy Policy FDIC Insurance

How To Apply:

Incase you would like to apply to this job directly from the source, please click here

Responsibilities

The Senior Data Analyst will drive enterprise data and analytics solutions, specifically focusing on regulatory reporting and large financial institution requirements. They will also mentor team members and collaborate with business and technical stakeholders to ensure data quality and effective data mapping.