Associate ETL Developer

About the role

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.

Responsibilities

• Participate in analysis, design, and ETL development as part of an Agile/Scrum team
• Aid 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
• Support process improvements within the team to increase efficiency and quality
• Work with stakeholders to understand data requirements and help implement solutions

Requirements

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

Qualifications

• Must have experience working with or consuming APIs for data exchange (RESTful services, microservices)
• Must have understanding of batch and/or real-time/event-driven data processing concepts
• Must have familiarity with Big Data or NoSQL technologies (MongoDB, Cassandra, Hive, etc.)
• Must have experience supporting or developing data pipelines in a team environment

Skills

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

Benefits

At Lincoln Financial, we offer:

• 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
• Effective productivity/technology tools and training

Pay

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.

Schedule

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

Benefits

Additional benefits include:

• Annual Incentive Program (discretionary and based on the performance of the company, business unit and individual)
• Long-term incentives
• Sales incentives
• Lifetime learning and professional development opportunities

Company Culture

At Lincoln Financial, we believe in empowering our customers to take charge of their lives. We value our unique perspectives, insights, and contributions and invest in programs that empower each of us to take charge of our own future. Our company culture is built on our core values and leadership attributes, and we strive to create a workplace where everyone feels valued and supported.

Equal Opportunity Employer

Lincoln Financial 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.