Associate Data Engineer, AI Data Products

Lincoln Financial’s AI, Data and Analytics (AIDA) organization is building priority AI-ready data products, and this role supports the data and service components that help them run in production. If you enjoy turning legacy data into reliable, agent-facing interfaces with strong testing and metadata practices, this is a great place to apply your Python and SQL skills alongside modern AWS-based tooling.

Location: Radnor, PA (hybrid). Work model: 3 days a week in a Lincoln office.

What you’ll do

• Build ingestion, transformation, and curated data models using SQL, Python, and approved AWS services.
• Create and maintain FastAPI and Pydantic services, including Model Context Protocol tools, with clear schemas, validation, error handling, and documentation.
• Convert source mappings and defined business rules into tested logic, partnering with business experts to clarify definitions and exceptions.
• Develop unit, integration, contract, reconciliation, and data-quality tests using pytest, mocks, and reusable fixtures.
• Deploy services through GitLab CI/CD (or comparable pipelines) and support production workloads with logs, metrics, traces, and runbooks.
• Include metadata, lineage, provenance, and access requirements as part of the definition of done.

What you bring

• A bachelor’s degree or equivalent work experience, plus typically 1 to 3 years of relevant experience or demonstrated capability.
• Hands-on Python and SQL, with a solid grasp of joins, keys, data types, and foundational data modeling.
• Working experience with FastAPI, Pydantic, pytest, and testable Python design.
• Experience building or extending a Model Context Protocol server or a comparable agent-facing tool interface, along with working knowledge of Git, CI/CD, and a cloud data environment.
• Ability to learn an unfamiliar business domain quickly, explain implementation choices clearly, and handle sensitive data with care.

Technologies you’ll work with

Python, SQL, FastAPI, Pydantic, Model Context Protocol, pytest, GitLab CI/CD, Git, AWS Glue, Athena, Lake Formation, IAM, Lambda, ECS, dbt, Apache Airflow, Amazon MWAA, Spark

Why this role

• Clearly defined career tracks and job levels, with behaviors tied to Lincoln’s core values and leadership attributes.
• Leadership development and virtual training opportunities.
• PTO/parental leave.
• Competitive 401K and employee benefits.
• Free financial counseling, health coaching, and an employee assistance program.
• Tuition assistance program.
• Work arrangements that work for you.
• Effective productivity/technology tools and training.

Nice to have

• Experience with AWS Glue, Athena, Lake Formation, IAM, Lambda, ECS, or comparable services.
• dbt, Apache Airflow, Amazon MWAA, Spark, or comparable data-engineering technologies.
• Document ingestion, classification, retrieval, or RAG data preparation experience, or experience in insurance, financial services, healthcare, or another regulated industry.

Relocation assistance: not available for this opportunity.