Data Operations Analyst (Investment Data)

Quick Facts

• Role: Data Operations Analyst (Investment Data)
• Focus: Investment data quality, reconciliation, and data governance for portfolios backing life and annuity liabilities

Description

Maintain the quality, accuracy, and completeness of investment data used across investment management, actuarial, finance, and forecasting. Identify, investigate, and resolve data anomalies, reconciliation breaks, and discrepancies across multiple investment systems and data sources, ensuring integrity and reliability. Support validation of asset inputs for FP&A and projection models, and assist with forecasting tool/process execution as needed.

Responsibilities

• Monitor investment data quality across multiple asset classes (public fixed income, structured products, private credit, mortgages, alternatives)
• Perform daily, monthly, and quarter-end reconciliations across systems (investment accounting, portfolio platforms, custodians, data warehouses, analytical applications)
• Investigate and resolve reconciliation breaks involving positions, market/book values, cash balances, accrued interest, investment income, ratings, security master attributes, and cash flows
• Analyze anomalies to determine root causes (source feeds, accounting treatment, transformations, system configuration, timing, operational processes)
• Partner with Investment Operations, Accounting, Technology, and external service providers to remediate and validate fixes
• Maintain reconciliation inventories, exception logs, and supporting documentation for auditability
• Ensure data consistency across upstream/downstream systems used for investment management, actuarial modeling, FP&A, regulatory and management reporting
• Help establish/enhance data quality controls, exception monitoring, and operational workflows
• Support data validation for security onboarding, portfolio transfers, acquisitions, system implementations, and data migration
• Act as a liaison across Asset Analytics, Investment Operations, Finance, Accounting, Actuarial, and Technology
• Communicate findings, requirements, and remediation priorities to stakeholders
• Coordinate exception resolution from identification through testing/validation and closure
• Participate in UAT for system enhancements and process changes
• Document data definitions, reconciliation procedures, exception management workflows, and operating controls
• Prepare/validate/reconcile asset-related inputs for FP&A forecasts and financial projection models
• Ensure completeness/accuracy of modeled attributes (cash flows, yields, spreads, ratings, durations, reinvestment assumptions)
• Support forecasting/planning processes with timely data extracts and validation checks
• Perform reasonability reviews of projection tool outputs and resolve input/data issues affecting models
• Identify opportunities to improve reconciliation processes and operational efficiency; support automation of data validation/reconciliation where appropriate
• Assist with data governance improvements (lineage, transparency, consistency) and best practices for investment data management and controls

Requirements

• Bachelor’s degree in a relevant discipline (Finance/Accounting/Economics/Math/Statistics/Data Analytics/Information Systems/Engineering/Actuarial Science or related)
• 1–4 years of experience in investment operations, data management, accounting, financial services, insurance, asset management, or related
• Experience with financial data reconciliations, operational controls, or data quality processes preferred
• Exposure to life insurance/annuities and investment accounting/operations/asset management is a plus

Hard Skills & Technologies

• Microsoft Excel (advanced)
• SQL (database querying)
• Preferred/Plus: Python, Power BI, Alteryx

Benefits

• Comprehensive Medical/Rx, Dental and Vision plans
• 401(k) with company match
• Flexible Savings Accounts (FSA)
• HSA with company contribution
• Basic and Voluntary Life Insurance
• LTD and STD insurance
• Employee Assistance Program (EAP) and Commuter Benefits
• Additional benefits include medical advisory team access, mental health app, mindfulness/wellbeing app, financial wellness support, new parent leave, reproductive and adoption assistance, emergency backup care, matching gift program, and education sponsorship