logo

View all jobs

Data Architect

San Francisco, CA
Job Title: Data Architect
Location: San Francisco, CA
Type: Long-Term Contract

Job Description

Our client is migrating its banking platform from one vendor to another. This migration will modify the existing data models and taxonomy significantly.

Responsibilities

The Data Architect will perform thorough analysis between the two vendor platforms, review the documentation provided by the new vendor, prepare mapping documents, document the data anomalies and issues, assess the impact on our client's existing user base, and provide guidelines on how to migrate to the new data models. The Data Architect will closely work with various teams such as Regulatory, Compliance, Operational, Accounting, Digital Banking, etc. to socialize the changes and solutions. 

Note: This is a senior-level position that requires a wide breadth of knowledge and outstanding communication skills.

Current Environment

- Data lake and data marts in SQL Server database, SSAS
- ETL used – SSIS, Informatica, Stored procs
- Reports/Dashboards – SSRS and Tableau
- Data model and reporting needs are based on client's current system

New Environment

Data lake and data marts in SQL Server database, SSAS and Snowflake (mostly)
- ETL used – Informatica and Stored procs compatible with Snowflake
- Reports/Dashboards – SSRS and Tableau
- Data model and reporting needs are based on the client's current system (mapping documents from current data model to new)

Skills Required

- Very strong SQL background and data analysis skills
- Financial services experience strongly desired
- Minimum of 5+ years of experience
- Some experience to import/export data using simple ETL techniques or Python scripting
Powered by