Analyst, Investment Data Analytics

The Role at a Glance

Lincoln's Investment Data & Analytics team is building a centralized data, operations, and technology function that delivers operational and reporting excellence across the General Account Investments organization. We are adding a data operations analyst who will roll into the Investment Data & Analytics team and serve as a key support layer between our source systems, our data engineering team, and our business partners.

This is a broad support role which will partner across the Investments organization. You will work closely with line-of-business portfolio managers and the Fixed Income, Asset Modeling, and Alternative Investments teams to provide data, operations, reporting, and coordination support across asset classes. Commercial Mortgage Loans (CML) are the primary and initial focus of the role, and over time your support will expand to cover additional investment functions and asset classes as the centralized function matures.

Across all of these areas, you will help ensure the data behind our investments is accurate, reconciled, well-controlled, and clearly reported. You will also help translate what our business partners need into the pipelines, dashboards, and controls our engineers build on our centralized data platform.

What you'll be doing

Commercial Mortgage Loan support (primary focus)

•Serve as a day-to-day data and operations point of contact for the CML production, closing/servicing, and accounting teams, translating their operational and reporting needs for the development team.
•Support reconciliation across CML data sources and accounting views, investigating and resolving breaks and exceptions with auditable data controls.
•Support the CML data lifecycle end to end — from origination through closing, servicing, and accounting — ensuring data flows cleanly and consistently between systems.
•Act as a liaison to internal and external auditors, assembling evidence, explaining data lineage, and supporting the integrity of reported figures.

General account Investment support

•Partner across the Investments organization: line-of-business portfolio managers, Fixed Income, Asset Modeling, and Alternative Investments to provide data, operations, and reporting support across asset classes.
•Serve as a coordination point between business teams, the development team, and control and audit partners, translating business and operational needs into clear technical requirements.
•Standardize reconciliation, reporting, and data-control practices across functions as the centralized data and analytics function matures.
•Onboard new data sources and reporting needs from partner teams into repeatable, well-controlled processes.

Reporting, analytics & data operations

•Build and maintain operational and management reporting and dashboards on our centralized data platform; monitor data quality and surface exceptions proactively.
•Develop and maintain SQL-backed queries and data preparation flows that ingest, validate, and reconcile investment data from source systems.
•Partner with the development team to embed controls, validation checks, and documentation into the data pipelines and dashboards built
•Contribute to data governance across the function — consistent definitions, data-quality controls, lineage, and documentation.

What we’re looking for

Core skills
•Hands-on experience with data analytics and data operations concepts: relational data, SQL, and data integration and reconciliation across systems.
•Working proficiency in Python and SQL; ability to build and maintain data preparation flows and reporting.
•Experience with a centralized data platform or comparable data-science/ETL tooling. Ability to build dashboards or reporting, preferred.
•Strong attention to data integrity, controls, and reconciliation, with the ability to trace and explain data lineage.
•Excellent partnership and communication skills, with the ability to translate business and operational needs into technical requirements.

Domain & control literacy
•Familiarity with general account investments — commercial mortgage loans, fixed income, or alternatives — preferred; strong int