Bank of the West Jobs

Job Information

Bank of the West Senior Data Solutions Architect in San Ramon, California

Senior Data Solutions Architect


At Bank of the West, our people are having a positive impact on the world. We’re investing where we feel we can make the most impact, like advancing diversity and women entrepreneurship programs, financing for more small businesses, and promoting programs for sustainable energy. From our locations across the U.S., Bank of the West is taking action to help protect the planet, improve people’s lives, and strengthen communities. We are part of BNP Paribas, a global leader supporting the UN Sustainable Development Goals (SDGs). Yes, we’re a bank, but as the bank for a changing world, we are continually seeking to improve the ways we help our customers, while contributing to more sustainable and equitable growth.

Job Description Summary

Our Enterprise Data and Analytics Services group is hiring a data architect to help design, develop, and oversee Data strategy, architecture, and solutions. This role will be primarily responsible for designing, implementing and optimizing our data platforms that include Big Data platform and Enterprise Data Warehouse.

Primary Responsibilities

  • Design conceptual data architecture solution for data-centric projects

  • Prepare and maintain accurate database design and architectural documents for management and development teams.

  • Play a lead role in the development and update of enterprise data architectural strategies, standards, processes and tools.

  • Participate in the development of data management policies, standards and procedures.

  • Design and implement effective data solutions and models to store and retrieve data.

  • Design canonical data models to limit technical debt as data flows from point-to-point transformation.

  • Define integrated views of data drawing draw together data from across the enterprise, both in real-time and as extracts.

  • Write  SQL queries against relational databases (Oracle, SQL Serve etc.…)

  • Building multi-dimensional databases, cubes, and data warehouses

  • Designing and developing data pipelines or ETL processes

  • Experience in tuning queries for performance and scalability




  • 7 years of data strategy and architecture related experience

  • Expert in SQL programming AND Hands-on experience in Python

  • Experience with traditional ETL integration tools as well as more modern real-time messaging/integration platforms

  • Experience with relational database modeling concepts AND modeling for the modern big data platform

  • Strong understanding of Operational, Relational, Analytical, Master, and Reference data modelsDeep understanding of data transfer formats such as XML, JSON, and Avro

  • Understanding of Cloud technologies such as Microsoft Azure, Google Cloud, Amazon Web Services (AWS) Knowledge of NoSQL

  • Experience in Big data technology stack - Hadoop, MapReduce HBase, and Hive

  • Experience with Data visualization tools such as PowerBI

Nice to have

  • Applied Math and Statistics

  • Knowledge of event-driven architecture


  • Bachelor's Degree

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: Technology

Location: United States-California-San Ramon

Requisition ID: 054164