Reconciliation Implementation Analyst
Core
Reconciles transactions and holdings of investment portfolios against external data to ensure accurate accounting, analytic, and compliance reports.
Role type
Reconciliation Implementation Analyst
Builds
Investment portfolio data, accounting reports, and automated reconciliation processes
Domain
Finance / Investment Management / Fixed Income & Equity
Deliverable
production ML models | product features | dashboards & analysis | client delivery
Required skills
Investment accounting, Fixed income investments, Equity investments, GAAP, Excel (VLookUp, SUMIF, Pivot Tables), SQL query writing, Data flow understanding (CW tools)
Preferred skills
Time Value of Money, Duration, Yield, Risk exposures, Alternative security types, Automation identification
Technologies
CW (Scavenger, Prometheus, Prezo, Titan), Excel, SQL
Responsibilities
Validate investment data against third-party market data, Manage inquiries from Treasurers and Accounting Managers, Create and maintain relationships with data providers and clients, Work with product teams to iterate reconciliation tools, Work with data engineers to automate reconciliation processes, Resolve daily reconciliation errors and issues
Seniority
Junior to Mid-level, hands-on IC