Disability Solutions - Phoenix, AZ

posted 2 months ago

Full-time - Mid Level
Phoenix, AZ
Administrative and Support Services

About the position

As a Senior Analyst in Data Management at Western Alliance Bank, you will play a crucial role in supporting the Business Data Governance team. Your primary responsibility will be to monitor and enhance business line data processes and procedures, ensuring that the collection and updating of source systems feeding into databases are efficient and accurate. You will collaborate closely with various teams, including Reporting and Analytics, to maintain data quality within the Enterprise Data Warehouse, which is essential for effective reporting and analytics. Additionally, you will assist the Policy and Procedures team in developing and updating data processes, ensuring compliance and best practices are followed. Your role will involve monitoring daily data validation processes across multiple data sources, helping to identify and resolve issues that arise from data rule reviews. You will utilize your advanced SQL Query Language skills to perform data mining and querying using SQL Server Management Studio, ensuring the accuracy of data tables and views. Summarizing data to identify or explain data issues will be a key part of your responsibilities, and you will leverage tools such as Excel, Power BI, or Tableau for this purpose. Furthermore, you will assist in the development and sourcing of data stores within the Enterprise Data Lake and Enterprise Data Warehouse, engaging in User Acceptance Testing (UAT) to validate that data stores accurately capture source data feeds. In this position, you will need to prioritize your workload effectively to meet deadlines and ensure timely resolution of data issues. You will also assist with monthly data reconciliations for the General Ledger close process, ensuring that critical data issues are addressed in preparation for this important financial task. This role offers a unique opportunity to gain hands-on experience in data management within the banking sector, enhancing your business knowledge and career growth.

Responsibilities

  • Support Business Data Governance team to monitor business line data processes and procedures in collecting and updating source systems that feed databases.
  • Ensure data quality in the Enterprise Data Warehouse for reporting and analytics.
  • Assist in the development or updates to data processes and procedures.
  • Monitor and support daily data validation processes from multiple data sources.
  • Work with business line data stewards to resolve data issues.
  • Utilize advanced SQL Query Language for data querying and coding.
  • Perform data mining using SQL Server Management Studio to review data tables or views for accuracy.
  • Summarize data to identify or explain data issues using Excel, Power BI, or Tableau.
  • Engage with Enterprise Data Governance in User Acceptance Testing (UAT) to validate data stores.
  • Assist with monthly data reconciliations for the General Ledger close process.

Requirements

  • Bachelor's Degree in Accounting, Business, Finance, Information Technology, or a closely related field to banking and loan processing.
  • 1-3 years of system administration and configuration support experience or related experience with credit/lending system processes.
  • 1-2 years of experience writing SQL Code and building tables and views in a SQL server.
  • Familiarity with SSIS packages for data management processes.
  • Experience with C# coding or other coding languages is preferred.
  • Detail-oriented, analytical, and inquisitive mindset.
  • Ability to work independently and collaboratively within a team.

Nice-to-haves

  • Experience with additional coding languages beyond SQL and C#.
  • Familiarity with data governance frameworks and best practices.

Benefits

  • Competitive salaries
  • Ownership stake in the company
  • Medical and dental insurance
  • Time off
  • 401k matching program
  • Tuition assistance program
  • Employee volunteer program
  • Wellness program
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service