Associate ETL Developer Job Details | Lincoln Financial
Lincoln Financial is a company focused on helping 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, utilizing tools like Python and AWS Glue to enhance ETL processes.
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
- 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.
Company Overview