Analyst, Application Development

Overview

Sign in to access AI-powered advices

Alternate Locations:
Charlotte, NC;
Fort Wayne, IN;
Greensboro, NC;
Radnor, PA

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

Relocation assistance: is not available for this opportunity.

Requisition #: 75361

The Role at a Glance:
As Lincoln continues in its technological transformation, the IT Business to Business (B2B) Team provides Lincoln’s Business partners with data for informed operational and strategic decisions. The B2B Team is seeking an ETL Programmer to expand data processes, extract creation, and evolve data-driven insights. You will participate in the end-to-end data extraction lifecycle: gathering requirements, optimizing ETL code, writing and standardizing SQL for data delivery, and creating customer-facing dashboards.

As a technical partner and analyst, you will work with other ETL developers, systems analysts, systems owners, and stakeholders to develop a strong data foundation.

• Create customer-facing data extracts, gathering metadata to support B2B reporting, including project management, team collaboration, and creating/revising SQL, coding and processing standards.
• Expand technical and design skillsets with IDMC training, SQL Server training, and mentoring to support expansion of data extractions and file transmission processes.
• Automate data extraction from various sources, perform data wrangling to transform data, and transfer to and from an AWS Cloud environment.
• Document created data flows and data definitions, and communicate these efficiently with stakeholders.
• Collaborate with stakeholders to understand business needs, goals, and objectives; evaluate data’s current state and provide feedback to create efficient ETL processes.
• Work with the team to ensure quality objectives are met for all requirements.

Must Haves:

• 3+ years of Business to Business (B2B) experience
• 3+ years experience creating DTCC Feeds
• 11+ years experience in Informatica ETL
• 3+ years SQL Server Database experience
• 3+ years Teradata experience
• Understanding of testing concepts related to functional, non-functional, and performance
• Growth mindset and enthusiasm for learning new skills
• Strong analytic, problem-solving, and research skills
• Proficiency with Microsoft Office Suite (Word, Excel, PowerPoint, Outlook)

Nice-to-have:

• Database Management
• Python/Perl
• SQL
• Experience interpreting COBOL documentation and pulling data from mainframe sources
• ETL/data wrangling experience

Final date to receive applications:
November 14, 2025 (subject to earlier closure due to applicant volume).

What’s it like to work here? Lincoln Financial is committed to empowering customers and building fulfilling careers in an inclusive environment. We value diverse perspectives and invest in programs that enable employees to take charge of their own future.

• Defined career tracks and leadership attributes
• Leadership development and virtual training
• PTO/parental leave
• Competitive 401K and benefits
• Free financial counseling, health coaching, and EAP
• Tuition assistance
• Flexible work arrangements
• Productivity tools and training

Pay range: $69,000 – $124,600 with anticipated pay for new hires between the minimum and midpoint of the range and may vary otherwise. Pay is based on non-discriminatory factors and is one component of Lincoln’s total rewards.

About the company:

Lincoln Financial helps people plan for a secure future through products like annuities, life insurance, and retirement services. We are committed to equal opportunity and an inclusive environment.

Be aware of fraudulent recruiting activities. Lincoln will not request sensitive information via insecure channels or free e-mail accounts. If you encounter suspicious activity, contact