The Data Analyst professional will develop a deep understanding of the data flows across many of First Republic Investment Management (FRIM) systems, reconciling data from disparate sources, to ensure a robust data set for portfolio management and business reporting. The Data Analyst works with subject matter experts from FRIM team to determine data requirements for FRIM systems, develop these requirements into functional specifications and data flow design documents and implements this vision. Workflow includes identifying necessary data, reconciling with the new application and the legacy data sources and ensuring a successful operation of the PWM Data Warehouse. This will include communicating business term definition, 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.
- Ensure that all and only the expected records appear
- Ensure that calculated values are correct
- Ensure that abnormal/edge cases are handled as expected
- Ensure that all values fall within expected range
Experience & Education: