Data Analyst - Portfolio Reporting

Location: San Francisco, CA
Job Title:       Data Analyst - Portfolio Reporting
Type: Contract
Location: San Francisco, CA
Job Description:
The Data Analyst works with SMEs from the project team to determine data requirements for Performance Reporting, develop these requirements into functional specifications and detailed data flow design documents, and participates in the full development process life-cycle from concept, through testing, to implementation. This includes identifying necessary data, reconciling with the new application and the data sources. Establishing data quality rules, writing and execute data quality checks, researching and analyzing data in support of business functions, process and workflow knowledge and user acceptance testing.

- Reconcile source data with data at vendor to support transition of data between sources
- Develop and verify data mapping as needed to support the project.
- Provide Technical specs to Data Team such that ETLs can be built to spec
- Write and execute data quality checks
- Communicate standard calculation logic and business term definition
- Establish best practices and data quality rules benefiting all aspects of the business.
- Work closely with vendors to debug data issues

-   BA in Mathematics, Computer Science, or Engineering required
-   5+ years of relevant work experience with background in wealth management and performance reporting
-   5+ years of relevant experience in data analysis and/or data management
Technical Skills:
-   Solid expertise writing SQL and experience debugging code
-   Knowledge of Private Wealth Management / Investment Management – with ability to  interpret definitions and calculations from business language to developer logic
-   Strong quantitative and analytical skills - ability to quickly analyze data to identify key insights and apply them to the business 
-   High-level understanding of complex data models and software integration/ delivery
-   Strong orientation to clients, including demonstrated ability to understand needs and apply this knowledge to drive data enhancements
-   Understanding of traditional and alternative asset class investment data, including equity, fixed income, private equity
this job portal is powered by CATS