Data Analyst (Analytics & Reporting)

Western Alliance Bank; Phoenix (AZ); On-site; USD 65,000 - 90,000; Full time

Benefits offered by this job

Competitive salaries

Ownership stake in the company

Medical and dental insurance

Time off

Great 401k matching program

Tuition assistance program

Employee volunteer program

Wellness program

Job summary

Western Alliance Bank in CityScape is seeking a Data Analyst (Analytics & Reporting) to transform business data into actionable insights by building analytical solutions and reports. You will work with regulatory stakeholders and data governance to deliver high-value external filings and performance metrics.

The role requires accounting or finance background, 1+ year in data analytics, and intermediate SQL and visualization skills.

Qualifications

• Bachelor’s degree in accounting, finance, business or related field.
• 1+ years of experience in data analytics or data management.
• Basic banking operations knowledge desired (deposits, loans, treasury).
• Familiarity with regulatory obligations and compliance basics.
• Proficiency with SQL, Excel and data visualization tools (Tableau/Power BI).
• Ability to present findings clearly to stakeholders.
• Strong problem-solving and attention to detail.

Responsibilities

• Consolidate and prepare bank's deposit and loan portfolio; reconcile with general ledger.
• Translate business requests into actionable analytical solutions with large datasets.
• Validate GL data against source systems and ensure metric consistency.
• Manage and review data quality metrics in the data warehouse.
• Support preparation of regulatory and financial reports.
• Create reports and analytical solutions for business stakeholders.
• Document report definitions, calculation logic, and data lineage.

Skills

Data analytics

Data management

Communication skills

Problem solving

Attention to detail

Education

Bachelor's degree in accounting/finance/business/data science

Tools

SQL

Excel

Tableau

Power BI

Job description

What You'll Do

The Data Analyst will be responsible for producing the bank's deposit and loan portfolios, understanding and transforming business data into actionable insights by building robust analytical solutions, performing advanced data analysis, and ensuring data integrity. Strong Accounting or finance skills along with experience in data analytics are required. Intermediate knowledge of SQL and data visualization tools is a plus. This role partners closely with regulatory stakeholders and data governance teams to deliver high value reporting for external filings and company performance.

• Consolidate and prepare bank's deposit and loan portfolio and reconcile the data in the database against the general ledger.
• Ability to work with large financial datasets and translate business requests into actionable analytical solutions.
• Validate general ledger data against source systems and reconcile metrics ensure consistency.
• Responsible for managing and reviewing data quality metrics of the portfolio data in the data warehouse.
• Support in the preparation of bank’s regulatory and other financial reports.
• Create reports and analytical solutions for business stakeholders.
• Document report definitions, calculation logic, and data lineage for transparency and auditability.

Job Title

Data Analyst (Analytics & Reporting)

Location

CityScape

What You'll Need

• Bachelor’s degree in accounting, Finance, Business Administration, Data Science, Finance, Accounting, or related field.
• 1+ years of related experience in Data Analytics & Data Management or similar field
• Entry level knowledge of general banking operations, including deposit operations, loan administration, treasury management and/or other commercial banking products and services.
• Entry level knowledge of applicable regulatory and legal compliance obligations, rules and regulations, industry standards and practices.
• Entry level to intermediate experience with data analysis tools (e.g., SQL, Excel) and data visualization platforms (e.g., Tableau, Power BI).
• Entry level to intermediate experience presenting findings from large datasets in a clear, actionable way.
• Intermediate to Advanced knowledge of Excel including Lookups, PivotTables, and advanced formulas.
• Intermediate speaking and writing communication skills.
• Demonstrated experience with financial reporting or regulatory reporting.
• Strong problem-solving skills and analytical skills
• Strong attention to detail and commitment to data quality.
• Ability to work collaboratively across teams and functions.

Benefits You’ll Love

• 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

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, Member FDIC, is a wholly owned subsidiary of Western Alliance Bancorporation. Serving clients nationwide, Western Alliance Bank includes six legacy bank brands - Alliance Association Bank, Alliance Bank of Arizona, Bank of Nevada, Bridge Bank, First Independent Bank and Torrey Pines Bank - that remain part of the company’s heritage, as well as AmeriHome Mortgage, a Western Alliance Bank Company.

Equal Employment Opportunity

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 [e-mail] 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