Lead Software Engineer

Lincoln Financial•Radnor, PA
•$120,375 - $192,600•Hybrid

About The Position

The Lead Software Engineer provides technical leadership for Lincoln Financial’s Data Strategy and Delivery team. The role designs, builds, and maintains scalable data pipelines and optimizes data systems, with particular expertise in Aurora PostgreSQL and Amazon Redshift and strong knowledge of AWS services. The engineer leads a team, owns delivery, sets technical direction, and partners with business, IT, and analytics stakeholders to provide secure, governed, high-quality data for analytics and reporting. This position leads data engineering work across batch and streaming pipelines, integrations, ETL workflows, database optimization, data lake and warehouse layers, orchestration, data quality, security, and governance. It owns end-to-end data flows from source through consumption, troubleshoots issues across the flow, and helps shape AWS data infrastructure strategy. The role is hybrid, with three days per week in a Lincoln office, in Radnor, Pennsylvania; Charlotte or Greensboro, North Carolina; or Fort Wayne, Indiana. Relocation assistance is not available.

Requirements

  • Bachelor’s degree or equivalent in Computer Science, Information Systems, Engineering, or a related field.
  • At least 7 years of experience in AWS data engineering or a similar role.
  • Demonstrated leadership, including leading a team, owning complex project delivery, communicating clearly with stakeholders, and developing as a leader.
  • Strong expertise in Aurora PostgreSQL and Amazon Redshift, including database analysis, query optimization, advanced SQL, execution plans, indexing, distribution and sort keys, and workload tuning.
  • Holistic understanding of end-to-end data processing from source to consumption, including dependencies, bottlenecks, and downstream impacts.
  • Experience integrating data and applications with upstream source systems and downstream consumers, including APIs, files, messaging, and reporting.
  • Hands-on AWS experience with Glue, Lambda, S3, Athena, EC2, and IAM.
  • Python, PySpark, and SQL development for ETL and integration in Agile, SDLC-based environments.
  • DevOps and scheduling experience, including Git, CI/CD pipelines, automated testing, CloudFormation or a similar tool, and Stonebranch or a similar scheduler such as Autosys.
  • Hands-on use of approved AI development tools such as GitHub Copilot or Claude Code, with validation of AI output and compliance with Lincoln data privacy and responsible AI requirements.

Nice To Haves

  • AWS certification such as Data Engineer – Associate, Solutions Architect, or a specialty certification.
  • Experience with EMR, Kinesis, Lake Formation, DynamoDB, or Apache Iceberg.
  • Microsoft 365 Copilot and Claude Cowork experience, including coaching teams on safe AI use.
  • Experience with RAG data preparation, embeddings, vector stores, and AWS AI services such as Bedrock, SageMaker, or Amazon Q.
  • Salesforce CRM and MuleSoft API-led integration experience with upstream or downstream systems.
  • MicroStrategy and Tableau reporting and business intelligence experience.
  • Financial data experience, especially in insurance, annuities, or retirement (401k/403b).

Responsibilities

  • Lead and prioritize work; own delivery; set standards and technical vision; review code; mentor engineers; and develop future leaders.
  • Design, build, and maintain batch and streaming data pipelines, including change data capture, to support business intelligence and analytics.
  • Integrate structured and unstructured data from internal and external sources.
  • Develop ETL workflows using AWS Glue, Lambda, custom Python, PySpark, and SQL scripts.
  • Analyze and optimize Aurora PostgreSQL and Amazon Redshift workloads, including queries, indexing, partitioning, and storage, for data integrity, performance, and cost.
  • Build S3-based data lake and warehouse layers using tools and formats such as Glue Data Catalog, Athena, and Parquet, with fine-grained access controls.
  • Own end-to-end data flows from source to consumption and trace and resolve issues across the full chain.
  • Apply data modeling standards, including normal form, star, and snowflake models, and data quality practices; create technical designs from business requirements.
  • Orchestrate and schedule workflows using Stonebranch, Step Functions, or Airflow/MWAA; monitor them with CloudWatch and automated data quality checks.
  • Ensure data security, governance, and compliance; monitor, troubleshoot, and optimize data workflows.
  • Integrate with upstream and downstream applications and collaborate with data scientists, analysts, and business stakeholders to deliver high-quality datasets.
  • Help shape data infrastructure strategy on AWS.

Benefits

  • PTO and parental leave.
  • Competitive 401(k) and employee benefits.
  • Free financial counseling, health coaching, and employee assistance program.
  • Tuition assistance program.
  • Work arrangements intended to accommodate employees’ needs.
  • Leadership development and virtual training opportunities.
  • Effective productivity and technology tools and training.
  • Potential eligibility for the discretionary Annual Incentive Program; other rewards may include long-term incentives and sales incentives.
© 2026 Teal Labs, Inc
Privacy PolicyTerms of Service