Bank of the West Financial Security Analytics & Reporting Data Analyst in San Ramon, California

Financial Security Analytics & Reporting Data 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.

Job Description Summary

Responsible for defining technical requirements, developing technical solutions and testing/reconciling said solutions to support the integration of new Data Sources for both Financial Security Analytics & Reporting and Compliance Reporting activities. Individual will be able to build and/or assist in the build of new analytics reports using approved Business Intelligence and Visual Analytics Platforms.

Essential Job Functions


  • Develops a strong knowledge of applications within the bank, and interactions between systems,to develop data marts and data analytics solutions.

  • Documents system parameters and formats, ensures hardware and software systems compatibility and coordinates and/or modifies system parameters in terms of existing and projected computer capacity and capabilities.

  • Creates, prepares, and documents detailed specifications of the programs utilized to pull and analyze the data. Includes: creation and use of documents to facilitate the request and data integrity of the data that is provided to the BSA/AML team members.

  • Leverages 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.


  • Completes dataprofiling,miningandanalysis.Coordinateandprioritizeallescalatedactivities,includingtesting,projectmanagementandenhancementsandbugfixes.

  • Work with IT to integrate new systems, documents business and system logic and creates tables/views to incorporate aggregated data into reports

  • Assists in developing test plans, test conditions and scripts using basic to moderate concepts of business knowledge.

  • Assist in determining the impact of operational systems and provide input into their resolution via data extraction and quantification.


  • Ensures the timely delivery of Business-as-Usual Reports to internal and external Finacial Security & Compliance Busines Partners

  • Works with Compliance IT and Technology teams to ensure product matches envisioned result.

  • Tests the mappings / views to ensure completeness and accuracy.

  • Ensures that all code and processes are documented.

  • Assist IT and Technology teams to tune the applications to meet operational production requirements.

  • Assists team members to integrate new data sources into existing reports and/or build new reports using the Bank’s approved reporting platforms.

  • Maintainscross-businessresponsibilitiesbyprovidingend-usersupporttomultipleorganizationswithinthecompanywhenissuesarise.

  • Performs other duties as assigned.


Required Experience

  • 6 to 8 years of directly related experience

  • Bachelor's degree in Information Technology, Computer Science, Engineering, or Mathematics

  • Masters / Advanced Degree in in Information Technology, Computer Science, Engineering, or Mathematics or related field or equivalent combination of education and experience (Preferred)

  • Masters in Business Administration (Preferred)


  • Advanced knowledge of SAS and SQL - Required

  • Strongproblemsolving, analytical and project management skills. Ability to think on your feet, present multiple solution options, and drive defect free products/solutions.

  • Strong knowledge of Business Insight (e.g., Business Objects, Cognos) and Visual Analytics Tools (e.g., Tableau, Oracle Visual Analytics, Power BI, Spotfire)

  • Demonstrated ability to interpret and fulfill requirements by partnering with business and technology leads in providing high performing, scalable and maintainable solutions.

  • Abilitytoprioritize, manageandresolvemultiplecomplexandcriticalissues.

  • Ability to communicate with various levels of technical and non-technical stakeholders and explain complex concepts in simple terms.

  • Excellent documentation skills to keep the system knowledge current.

  • Knowledge of compliance products such as Actimize, Mantis, etc. or compliance functions such as KYC/KYA, transaction monitoring, CDD, etc.

  • Strong knowledge of SDLC/RDLC development methodologies

  • Strong knowledge of Business Systems Architecture and Relational Databases

  • Advanced knowledge of Data and Analytics

Equal Employment Opportunity Policy

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.

Job: Operations

Location: United States-California-San Ramon

Requisition ID: 043438