Hybrid ETL Data Engineer - Python & AWS Glue

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

Job summary

Lincoln Financial Group is seeking an ETL Developer to support the design, development, and delivery of data solutions in a cloud environment. Focused on ETL processes with Python and AWS Glue, you will integrate data across Oracle and PostgreSQL and work with APIs for data ingestion.

You'll participate in Agile/Scrum, build scalable pipelines with AWS services, and collaborate with analytics teams to deliver reliable data integrations while growing your AWS and data engineering skills.

Qualifications

• 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.

Responsibilities

• Participate in analysis, design, and ETL development as part of an Agile/Scrum team.
• Assist in implementing data mapping and data modeling techniques (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.

Skills

Python

ETL/Data engineering

SQL

APIs (REST/JSON)

Oracle/PostgreSQL

Agile/Scrum

Tools

AWS Glue

S3

Redshift

AWS Lambda

Job description

Lincoln Financial Group is seeking an ETL Developer to support the design, development, and delivery of data solutions in a cloud environment. Focused on ETL processes with Python and AWS Glue, you will integrate data across Oracle and PostgreSQL and work with APIs for data ingestion.

You'll participate in Agile/Scrum, build scalable pipelines with AWS services, and collaborate with analytics teams to deliver reliable data integrations while growing your AWS and data engineering skills.