Associate ETL Developer

Lincoln Financial; Radnor (Delaware County); Hybrid; USD 55,700 - 100,200; Full time

Benefits offered by this job

PTO/Parental leave

401K and Benefits

Tuition assistance

Job summary

Lincoln Financial is seeking an ETL Developer within the RetailIQ team to design, build, and maintain ETL pipelines in a cloud environment using Python and AWS Glue, integrating Oracle and PostgreSQL data. The role supports batch and near real-time ingestion, APIs, and data workflows within established SDLC practices.

You will collaborate with analytics teams to deliver scalable data solutions, learn AWS data services, and contribute to continuous improvement in data integration projects.

Qualifications

• 1–3+ years of experience in application development or ETL/data engineering roles.
• 1–3+ years of experience with data warehouses, ODMS, or data marts.
• Hands-on experience with Python or another OO language (Java/.NET).
• Working knowledge of relational databases and data integrity concepts.
• Basic to intermediate data modeling concepts (conceptual, logical, physical).
• Familiarity with SQL and databases such as Oracle or PostgreSQL.
• Experience with consuming APIs (REST/JSON) for data integration.

Responsibilities

• Participate in analysis, design, and ETL development as part of an Agile/Scrum team.
• Assist in data mapping and modeling (normalized, star, snowflake) to support quality and integrity.
• Perform SDLC tasks including analysis, requirements, development, testing, and support.
• Develop and maintain data pipelines using AWS services like Glue, S3, and Redshift.
• Integrate data from external/internal systems using RESTful APIs and API-based ingestion/delivery.
• Collaborate with team to deliver data solutions and support enhancements.
• Stay informed about tools and best practices in data engineering and apply them.
• Support process improvements to increase efficiency and quality.
• Work with stakeholders to understand data requirements and implement solutions.

Skills

Python

SQL

API integration

Agile/Scrum

Tools

AWS Glue

AWS S3

AWS Redshift

Oracle

PostgreSQL

Job description

Alternate Locations: Greensboro, NC (North Carolina); Charlotte, NC (North Carolina); Fort Wayne, IN (Indiana); Radnor, PA (Pennsylvania)

Work Arrangement: Hybrid : Employee will work 3 days a week in a Lincoln office

Relocation assistance: is not available for this opportunity.

Requisition #: 76149

The Role at a Glance

As an ETL Developer within Lincoln’s RetailIQ team, you will support the design, development, and delivery of data solutions and pipelines in a cloud environment. This role focuses on building, enhancing, and maintaining ETL processes using Python and AWS Glue to integrate data across Oracle and PostgreSQL systems. You will collaborate with analytical teams to implement data solutions, contribute to new and existing workflows, and provide post-production support. The role also includes working with APIs to ingest and expose data, supporting both batch and near real-time integrations. Working within established SDLC practices, you will help deliver reliable, scalable data integration solutions while continuing to grow your technical expertise in AWS-based data services

What You'll Be Doing

• Participate in analysis, design, and ETL development as part of an Agile/Scrum team
• Assist in implementing data mapping and data modeling techniques (e.g., normalized, star, and snowflake schemas) to support data quality and integrity
• Perform technical tasks including analysis, requirements gathering, development, testing (unit and integration), and support following SDLC practices
• Develop and maintain data pipelines using AWS services such as Glue, S3, and Redshift
• Integrate data from external and internal systems using RESTful APIs and support API-based data ingestion and delivery
• Collaborate with team members to deliver data solutions and support ongoing enhancements
• Stay informed about current tools, technologies, and best practices in data engineering, and apply them when appropriate
• Support process improvements within the team to increase efficiency and quality
• Work with stakeholders to understand data requirements and help implement solutions

What We’re Looking For

Must-Haves:

• 1–3+ years of experience in application development or ETL/data engineering roles
• 1-3 + years of experience working with data warehouses, operational data stores, or data marts
• Hands-on experience with Python or another object-oriented programming language (Java, .NET, etc.)
• Working knowledge of relational database systems and data integrity concepts
• Basic to intermediate understanding of data modeling concepts (conceptual, logical, and physical design)
• Familiarity with SQL and databases such as Oracle or PostgreSQL
• Experience working with or consuming APIs (REST/JSON) for data integration

Nice-to-Haves:

• Experience working with ETL tools or frameworks (e.g., AWS Glue, Informatica, etc.)
• Exposure to AWS services such as S3, Glue, Lambda, Redshift, and Aurora
• Experience developing or integrating with APIs for data exchange (RESTful services, microservices)
• Understanding of batch and/or real-time/event-driven data processing concepts
• Familiarity with Big Data or NoSQL technologies (MongoDB, Cassandra, Hive, etc.)
• Experience supporting or developing data pipelines in a team environment

Application Deadline

Applications for this position will be accepted through June 26th, 2026, subject to earlier closure due to applicant volume

What’s it like to work here?

At Lincoln Financial, we love what we do. We make meaningful contributions each and every day to empower our customers to take charge of their lives. Working alongside dedicated and talented colleagues, we build fulfilling careers and stronger communities through a company that values our unique perspectives, insights and contributions and invests in programs that empower each of us to take charge of our own future.

What’s in it for you:

• Clearly defined career tracks and job levels, along with associated behaviors for each of 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 employee assistance program
• Tuition assistance program
• Work arrangements that work for you
• Effective productivity/technology tools and training

The pay range for this position is $55,700 - $100,200 with anticipated pay for new hires between the minimum and midpoint of the range and could vary above and below the listed range as permitted by applicable law. Pay is based on non-discriminatory factors including but not limited to work experience, education, location, licensure requirements, proficiency and qualifications required for the role. The base pay is just one component of Lincoln’s total rewards package for employees. In addition, the role may be eligible for the Annual Incentive Program, which is discretionary and based on the performance of the company, business unit and individual. Other rewards may include long-term incentives, sales incentives and Lincoln’s standard benefits package.

About The Company

Lincoln Financial (NYSE: LNC) helps people to confidently plan for their version of a successful future. We focus on identifying a clear path to financial security, with products including annuities, life insurance, group protection, and retirement plan services.

With our 120-year track record of expertise and integrity, millions of customers trust our solutions and service to help put their goals in reach.

Lincoln Financial Distributors, a broker-dealer, is the wholesale distribution organization of Lincoln Financial. Lincoln Financial is the marketing name for Lincoln Financial Corporation and its affiliates including The Lincoln National Life Insurance Company, Fort Wayne, IN, and Lincoln Life & Annuity Company of New York, Syracuse, NY. Lincoln Financial affiliates, their distributors, and their respective employees, representatives and/or insurance agents do not provide tax, accounting or legal advice.

Lincoln is committed to creating an inclusive environment and is proud to be an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, disability, age, or veteran status.

Follow us on Facebook, X, LinkedIn, Instagram, and YouTube. For the latest company news, visit our newsroom.

Additional Information

This position may be subject to Lincoln’s Political Contribution Policy. An offer of employment may be contingent upon disclosing to Lincoln the details of certain political contributions. Lincoln may decline to extend an offer or terminate employment for this role if it determines political contributions made could have an adverse impact on Lincoln’s current or future business interests, misrepresentations were made, or for failure to fully disclose applicable political contributions and or fundraising activities.

Any unsolicited resumes or candidate profiles submitted through our web site or to personal e‑mail accounts of employees of Lincoln Financial are considered property of Lincoln Financial and are not subject to payment of agency fees.

Lincoln Financial ("Lincoln" or "the Company") is an Equal Opportunity employer and, as such, is committed in policy and practice to recruit, hire, compensate, train and promote, in all job classifications, without regard to race, color, religion, sex, age, national origin or disability. Opportunities throughout Lincoln are available to employees and applicants are evaluated on the basis of job qualifications. If you are a person with a disability that impedes your ability to express your interest for a position through our online application process, or require TTY/TDD assistance, contact us by calling 260-455-2558.

This Employer Participates in E-Verify. See the E-Verify notices.

Este Empleador Participa en E-Verify. Ver el E-Verify avisos.