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.
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.
Location: United States-California-San Ramon
Requisition ID: 054164