Bank of the West Sr Data Analytics Analyst in Tempe, Arizona
Sr Data Analytics Analyst
What sets Bank of the West apart from other banks is our team members–they embody the optimistic spirit of the West. There is a spirit here that drives us to do more. Our team of more than 10,000 employees is vital to the success of our Bank. They reflect our modern western values—straightforward, entrepreneurial and optimistic. We seek to create a corporate culture that fosters and rewards excellence, encourages creative thinking and respects diversity – an environment where team members are engaged, supportive of one another and enthusiastic about serving our customers. Bank of the West offers the stability of a company that has a 135 year history and is part of BNP Paribas, a European leader in global banking and financial services and one of the 6 strongest banks in the world. We offer opportunities across our diverse business lines – Retail Banking, Commercial Banking, National Finance, and Wealth Management.
Responsible for managing data analytics that provide overall data management and reporting. Oversees the development of analytical tools and solutions to support the business line. Responsible for source system data analysis, variable gap analysis, data extraction design and coding, and data modeling. As a member of the Enterprise Risk team the Data Analyst will collaborate across business lines to collect, organize and analyze data from several source systems within the Bank. This is the highest level with the Data Analytics job family and is reserved for the Enterprise Risk Group for enterprise-wide duties and responsibilities.
Identifies data analytics opportunities, designs, and executes test, data extraction, and analysis utilizing the department's various computer software packages within established deadlines. Analyze source data/file structures, metadata, profile source data.
Develop data mapping and transformation rules and detailed designs based on system and business requirements.
Creates, prepares, and documents detailed specifications of the programs utilized to pull data. Includes: creation and use of documents to facilitate the request and data integrity of the data that is provided to the internal customer.
Analyzes and recommends business, technology, and process improvement opportunities. Utilize automation tools to schedule, execute and monitor jobs. Performance tune the applications to meet operational production requirements
Knowledge of applications within the bank to interpret data requests and identify data analytics opportunities.
Design and code functions of the application in accordance with the standards and architectural guidelines.
Maintain the quality control and auditing of Risk DataMart to ensure the accuracy and quality of data. Protect and insure the stability of the operational systems as well as maintain the integrity of the data they contain.
Assist in determining the impact of operational systems and provide input into their resolution via data extraction and quantification.
Data modeling, profiling, mining and analysis. Developing reports and framework per requirements.
Coordinate and prioritize all escalated activities, including testing, project management and enhancements and bug fixes.
Maintain cross-business responsibilities by providing end-user support to multiple organizations within the company when issues arise.
- Required Education or Equivalent Experience
Bachelor’s Degree in Computer Science, MIS or related field
Master’s/Advanced Degree in Computer Science, MIS or related field
Required license(s) or certification(s) ACL Certified Data Analyst (ACDA)
Required Experience 6 to 8 years of directly related experience
Field of Experience
Strong experience working on any ETL tool (SAS, SQL, Informatica, etc)
Strong knowledge of relational database design and support, including the support of large UNIX/Oracle based enterprise software systems
Expert knowledge of SQL structured query language
Strong experience with Oracle on UNIX using command line and GUI SQL tools
Strong experience of working with Tableau, Power BI or other visual analytics platform.
Business systems analytical experience required
Strong problem solving; analytical; project management and communication skills
Banking industry experience is preferred
Ability to prioritize and resolve multiple complex and critical issues
Excellent organizational and documentation ability to create and maintain detailed documentation for data warehouse and procedures
Bank of the West is an Equal Opportunity employer and proud to provide equal employment opportunity to all job seekers without regard to any status protected by applicable law. Bank of the West is also an Affirmative Action employer - Minority / Female / Disabled / Veteran. Bank of the West will consider for employment qualified applicants with criminal histories pursuant to the San Francisco Fair Chance Ordinance subject to the requirements of all state and federal laws and regulations.
Location: United States-Arizona-Tempe
Other Locations: United States-Nebraska-Omaha
Requisition ID: 055874