Enterprise Data Warehouse Engineer
Location: SANTA CLARA, California

The Enterprise Data Warehouse team at Silicon Valley Bank is responsible for delivering data solutions that support all lines of business across the organization. This includes providing data integration services for all batch data movement; managing and enhancing the current data warehouse and dependent data marts; and providing support for analytics and business intelligence consumers.

This is a unique career opportunity for a senior data warehouse engineer. As a Data Warehouse engineer, you ?will have the opportunity to:?

- Collaborate with Data Warehousing peers, Tech. leads and business functional SME’s by understanding the business requirements, diagnose/analyze data and propose design/design alternatives and recommendations for the Fraud, Payments and compliance area
- Contribute at a senior-level to the data warehouse solution, Data Migration, design, Data Model and data preparation/documentation by implementing robust, extensible design that meets functional, analytical, service level ?requirements and standards
- Extract Structured and Unstructured data from source systems, transforming and load the data to fit business needs
- Engage with partners in testing, release management and operations to ensure quality of code development, deployment and post-production support
- Lead all aspects of software or product vendor implementations as needed to deploy solutions that integrate with SVB systems and / or processes
- Mentor and provide direction to offshore partners on larger scale projects where you will act as technical lead for the organization


Skills and Requirements:
Solution Design and Leadership:

•Lead all phases in the solution lifecycle, including architecture review, design review, code development, and deployment
•Analyze design specifications, documentation, and requirements surrounding the EDW ?technology components
•Create high-level designs based on an understanding of the functional needs of projects or internal business clients
•Ensure design of new solutions leverages existing software components where feasible
•Design and build software components in accordance with the relevant requirements, system and ?software architectures, design, and coding standards

Development activities:

•Generate SQL DDLs and physical tables for the purpose of loading target data stores
•Develop ETL packages to extract, transform and load source to target stores
•Define and implement scheduling of jobs

Testing and Support:

•Write and perform unit testing of software components and integration programs
•Execute unit tests to ensure that the software complies to functional requirements
•Tune for performance ETL packages and target data stores based on expected use
•Proactively identify and remediate coding defects
•Identify and mitigate potential issues and risk associated with development activities
•Establish and maintain software and document change management policies and procedures
•Having financial domain experience especially related to AML, Fraud Identifying/management, compliance and Case management domain would be a big plus


© 2015 SVB Financial Group ®
Member Federal Reserve System · Member FDIC · Member Nasdaq: SIVB
Privacy Policy

Job Location
Calculate Commute:
Show On Map: