Job Title: Data Warehousing Analyst
Type Location: Contract / San Francisco Financial District
The Data Warehousing Analyst works with the project team to determine data requirements for Data Warehouse systems, develops these requirements into functional specifications, develops detailed data flow design documents, and participates in the full product development process life-cycle from.
The Data Warehousing Analyst communicates business term definition, establishes data quality rules, writes and executes data quality checks, researches and analyzes data.
The Data Warehousing Analyst collaborates with Project Manager, business partners and team members to identify data needs required that meet project objectives.
Documents and organizes data flows to enable successful implementation of products that solve the complex business problems of customers.
Creates documentation: Design specification, Data mapping , sequence diagrams, and reconciles source data with vendors.
Support the design, scoping, implementation, and testing in short agile release cycles of in-house development and vendor implementations end-to-end.
Any experience in Domain models and Canonical models is preferred.
Experience and Education:
BA or BS required
5+ years of experience in data analysis and/or data management
3+ years of experience with background in wealth management and/or client reporting/portal
Experience working with Agile and/or Scrum methodologies
Expert in writing SQL
Excellent attention to detail and experience debugging code
Experience with Canonical Data Models (nice to have)
Knowledge of Private Wealth Management/Investment Management or Financials Management business and systems - Preferred
Salesforce platform and data model principles - Preferred
TFS/JIRA or other issue tracking application - Required