As part of the AI, Data and Analytics (AIDA) organization at Lincoln Financial, you will build and operate the data and service capabilities that support priority AI-ready data products. The work combines Python and SQL development with production-grade data engineering practices, including testing, lineage, and provenance.
Responsibilities
- Build ingestion, transformation, and curated data models using SQL, Python, and approved AWS services.
- Develop and maintain FastAPI and Pydantic services, along with Model Context Protocol tools, using clear schemas, validation, error handling, and documentation.
- Convert source mappings and defined business rules into tested implementations, partnering with business experts to refine definitions and exceptions.
- Create unit, integration, contract, reconciliation, and data-quality tests using pytest, mocks, and reusable fixtures.
- Deploy changes using GitLab CI/CD or comparable pipelines, and support production operations through logs, metrics, traces, and runbooks.
- Include metadata, lineage, provenance, and access requirements as part of the definition of done for production delivery.
Requirements
- Bachelor’s degree or equivalent work experience, plus typically 1 to 3 years of relevant experience or equivalent demonstrated capability.
- Hands-on Python and SQL, with a strong understanding 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 practical knowledge of Git, CI/CD, and a cloud data environment.
- Ability to learn an unfamiliar business domain quickly, communicate implementation choices clearly, and handle sensitive data with care.
Technologies
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
Nice to Have
- Experience with AWS Glue, Athena, Lake Formation, IAM, Lambda, ECS, or comparable services.
- Familiarity with dbt, Apache Airflow or Amazon MWAA, Spark, or comparable data-engineering technologies.
- Background in document ingestion, classification, retrieval or RAG data preparation, or experience in insurance, financial services, healthcare, or another regulated industry.
Benefits
- Clearly defined career tracks and job levels, including associated behaviors tied to Lincoln’s core values and leadership attributes.
- Leadership development and virtual training opportunities.
- PTO and 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 and technology tools, plus training.
Work Arrangement
Hybrid: The role requires working 3 days per week in a Lincoln office.
Relocation Assistance
Relocation assistance is not available for this opportunity.
