Associate ETL Developer

Lincoln Financial is a company that helps people confidently plan for their financial future. They are seeking an Associate ETL Developer to support the design, development, and delivery of data solutions and pipelines in a cloud environment, focusing on building and maintaining ETL processes using Python and AWS Glue.

Responsibilities

• 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

Skills

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

Benefits

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

Company Overview