Analyst Analytics and Reporting

Not Interested
Bookmark
Report This Job

profile Job Location:

Phoenix, NM - USA

profile Monthly Salary: Not Disclosed
Posted on: 8 hours ago
Vacancies: 1 Vacancy

Job Summary

Job Title:

Analyst - Analytics and Reporting

Location:

CityScape

What youll do:

As a Analyst - Reporting and Analytics youll play a critical role in driving data-driven decision-making across the organization. Youll gather data develop reports analyze performance metrics and assist in the creation of data-driven insights to help inform business decisions. One of your key responsibillities is to ensure data analysis needs by the business are met while operating within data governance requirements.
  • Consolidate and prepare banks deposit and loan portfolio and reconciling the data using SQL functionalities.
  • Create and analyze complex queries to extract transform and analyze large datasets in Excel.
  • Work with large datasets and translate business requests into actionable analytical solutions.
  • Validate results against source systems and reconcile metrics to ensure consistency.
  • Assist in design maintenance and enhancement of dashboards and reports using Power BI
  • Create interactive visuals and self-service reporting solutions for business stakeholders.
  • Document report definitions calculation logic and data lineage for transparency and auditability.

What youll need:

  • 1 years of related experience in Data Analytics & Data Management or similar field.
  • Bachelors degree in related field required.
  • 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.
  • Intermediate experience with data analysis tools (e.g. SQL Excel) and data visualization platforms (e.g. Tableau Power BI).
  • Intermediate knowledge of Excel including Lookups PivotTables and advanced formulas.
  • Intermediate speaking and writing communication skills

Benefits youll love:
We offer all the important things youd 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 addition youll 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 or call . 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


Required Experience:

IC

Job Title:Analyst - Analytics and ReportingLocation:CityScapeWhat youll do:As a Analyst - Reporting and Analytics youll play a critical role in driving data-driven decision-making across the organization. Youll gather data develop reports analyze performance metrics and assist in the creation of dat...
View more view more

Key Skills

  • Cognos
  • Microsoft Access
  • SQL
  • Crystal Reports
  • Financial Report Writing
  • Power BI
  • Pivot tables
  • ssrs
  • Tableau
  • Regulatory Reporting
  • SAS
  • Data Analysis Skills