- Ensure accuracy, completeness, and consistency of data extraction and aggregation of complex investment portfolio data using proprietary aggregation software.
- Identify, investigate, and resolve aggregated data inconsistencies and errors across all balances.
- Perform reconciliation on trading history and end-of-day holdings data to identify account discrepancies.
- Review reconciliation output and ensure timely identification and escalation of aging exceptions.
- Contribute to the enhancement of internal systems to drive efficiency, accuracy, and timeliness of data aggregation.
- Build tools and processes to improve and scale the data reconciliation competency.
- Collaborate with the product team on new features to understand cost and process impacts.
- Act as an escalation point for queries from Sales, Client Success, and Product teams to resolve client data-related questions.
- Liaise with custodian representatives to address gaps found in financial data sources.
- Provide training and support to staff on data-related processes and systems.
PythonSQLTableau+1 more