Demo

Systems Analysis, Data Integration & ETL Engineer (REMOTE)

Lincoln Financial Group
Radnor, PA Remote Full Time
POSTED ON 3/19/2025
AVAILABLE BEFORE 4/18/2025

What you'll be doing

DUTIES AND RESPONSIBILITIES

  • Partner with business and technical teams to refine business requirements and convert into concise technical (functional and non-functional) requirements via creating the technical stories for the agile team to execute.
  • Organize information to create data models, source-to-target mappings, and solution diagrams.
  • Develop, automate ETL data pipelines that implement key aspects of the full data pipeline lifecycle, including acquisition, transformation, management, export, and analytics.
  • Experience to efficiently handle complex structures of data and normalize them into a single database structure.
  • Develop and support data warehouses and data marts.
  • Maintain best practices to facilitate optimized software development, continuous improvement / continuous delivery (CI / CD) and observability.
  • Provides input on the development of project plans, test plans and implementation plans including determining estimates on time frames.
  • Maintains knowledge on current and emerging developments / trends for assigned area(s) of responsibility, assesses the impact, and collaborates with management to incorporate new trends and developments in current and future solutions.
  • Champions and enhances organizational initiatives by positively influencing and supporting change management and / or departmental / enterprise initiatives within assigned area(s) of responsibility.
  • Serves as a resource to team members and applicable internal / external stakeholders on more complex assignments / projects for their assigned area(s) of responsibility.
  • Identifies and recommends process improvements that significantly reduce workloads or improve quality for their assigned area(s) of responsibility.
  • Analyzes, designs, codes, debugs, integrates and tests increasingly complex software application solutions for systems.
  • Analyzes increasingly complex systems specifications of existing programs to determine requirements.
  • Prepares and / or generates test data.
  • Tests increasingly complex program changes thoroughly to ensure accuracy.
  • Partners with internal stakeholders to ensure that systems are designed, developed and implemented from a business point of view.
  • Consults and / or participates in the requirements, design and coding walkthroughs to ensure the development of quality solutions.
  • Investigates and resolves increasingly complex problems including providing support for production systems in a timely manner.
  • Proactively identifies problems and presents / develops solutions.
  • Communicates effectively with internal stakeholders and management.

ADDITIONAL POSITION RESPONSIBILITIES

  • Makes a positive contribution as demonstrated by : - Making suggestions for improvement - Learning new skills, procedures and processes.
  • Performs other duties as required.
  • What we’re looking for

    EDUCATION AND EXPERIENCE

  • 4 Year / Bachelor's degree (or equivalent) in Computer Science, Computer Information Systems, Information Systems, Information Technology or Computer Engineering (Minimum Required)
  • 2 - 5 Years experience in application development
  • 2 - 5 Years experience in systems analysis
  • Technically proficient in some or all of the following languages / frameworks, application platforms and developer tools :
  • KEY SKILLS :

  • Technical Writing
  • Requirements Specification
  • Informatica
  • Python & PySpark
  • Data Modeling
  • SUPPLEMENTAL SKILLS :

  • Amazon Web Services (Glue, Lambda, RDS PostgreSQL, S3, CloudFormation, SNS, SQS, Step Functions, CloudWatch, SM, IAM, KMS, Athena, Redshift, Serverless, EKS, QuickSight, CDK / CLI)
  • Stonebranch, Autosys
  • GitLab
  • Visual Studio Code
  • Unittest, Pytest
  • SonarQube, Lint, Fortify
  • Splunk
  • JFrog
  • OTHER SKILLS AND ABILITIES

  • Ability to perform under stress in cases of emergency, critical or hazardous situations.
  • Ability to work with others in a team environment.
  • Demonstrated strong relationship management skills with internal clients ( management, peers and colleagues); proven ability to develop collaborative approaches.
  • Demonstrates ability to identify and recommend process improvements.
  • Demonstrates excellent organizational skills with the ability to prioritize workload and multi-task while maintaining strict attention to detail.
  • Demonstrates strong interpersonal skills with a collaborative style.
  • Demonstrates the ability to use sound judgment and discretion regarding confidential information.
  • Finds common ground and can gain collaboration among management, colleagues and peers; can influence outcomes without directing or commanding.
  • Proficiency with Microsoft Office Suite (Word, Excel, PowerPoint, Outlook).
  • Strong project management skills including, critical ability to coordinate and balance multiple projects in a time-sensitive environment, under pressure, and meeting deadlines.
  • Successfully completes regulatory and job training requirements.
  • The job demands described here are representative of those that must be met by an employee to successfully perform the functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. This job description is not intended and should not be construed to be an exhaustive list of all responsibilities, skills, efforts, or working conditions associated with the job. It is intended to be a reflection of those principal job elements essential for recruitment and selection, for making fair job evaluations and for establishing performance standards. The percentage of time spent performing the various job duties is not absolute. The incumbent shall perform all other functions and / or be cross trained as shall be determined by the sole discretion of management, who has the right to amend, modify, or terminate this job in part or in whole. This document is not a contract for employment. Employment is at-will.

    Application Deadline

    Applications for this position will be accepted through January 31st, 2025, subject to earlier closure due to applicant volume.

    What’s it like to work here? At Lincoln Financial Group, we love what we do. We make meaningful contributions each and every day to empower our customers to take charge of their lives. Working alongside dedicated and talented colleagues, we build fulfilling careers and stronger communities through a company that values our unique perspectives, insights and contributions and invests in programs that empower each of us to take charge of our own future. What’s in it for you :

    Clearly defined career tracks and job levels, along with associated behaviors for each Lincoln leadership Attribute.

    Leadership development and virtual training opportunities

    PTO / parental leave

    Free financial counseling, health coaching and employee assistance program

    Tuition assistance program

    A leadership team that prioritizes your health and well-being; offering a remote work environment and flexible work hybrid situations

    Effective productivity / technology tools and training

    The pay range for this position is $79,601 - $145,100 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. The base pay is just one component of Lincoln’s total rewards package for employees. 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.

    Salary : $79,601 - $145,100

    If your compensation planning software is too rigid to deploy winning incentive strategies, it’s time to find an adaptable solution. Compensation Planning
    Enhance your organization's compensation strategy with salary data sets that HR and team managers can use to pay your staff right. Surveys & Data Sets

    What is the career path for a Systems Analysis, Data Integration & ETL Engineer (REMOTE)?

    Sign up to receive alerts about other jobs on the Systems Analysis, Data Integration & ETL Engineer (REMOTE) career path by checking the boxes next to the positions that interest you.
    Income Estimation: 
    $105,489 - $131,507
    Income Estimation: 
    $128,913 - $157,494
    Income Estimation: 
    $84,222 - $112,497
    Income Estimation: 
    $115,390 - $147,559
    Income Estimation: 
    $106,780 - $140,358
    Income Estimation: 
    $104,963 - $131,876
    Income Estimation: 
    $86,680 - $110,316
    Income Estimation: 
    $110,730 - $135,754
    Income Estimation: 
    $117,033 - $148,289
    Income Estimation: 
    $110,730 - $135,754
    Income Estimation: 
    $128,617 - $162,576
    Income Estimation: 
    $117,033 - $148,289
    Income Estimation: 
    $106,780 - $140,358
    Income Estimation: 
    $136,671 - $177,110
    Income Estimation: 
    $128,093 - $158,900
    View Core, Job Family, and Industry Job Skills and Competency Data for more than 15,000 Job Titles Skills Library

    Job openings at Lincoln Financial Group

    Lincoln Financial Group
    Hired Organization Address Harrisburg, PA Full Time
    Alternate Locations : Work from Home; Fort Wayne, IN (Indiana) Work Arrangement : Hybrid / Flexible : Work at home and u...
    Lincoln Financial Group
    Hired Organization Address Sacramento, CA Full Time
    Alternate Locations : Work from Home; Fort Wayne, IN (Indiana) Work Arrangement : Hybrid / Flexible : Work at home and u...
    Lincoln Financial Group
    Hired Organization Address Concord, NH Full Time
    Alternate Locations : Work from Home; Atlanta, GA (Georgia); Boston, MA (Massachusetts); Charlotte, NC (North Carolina);...
    Lincoln Financial Group
    Hired Organization Address Radnor, PA Full Time
    What you'll be doing Define and execute the strategy and roadmap for IT infrastructure and operations solutions to antic...

    Not the job you're looking for? Here are some other Systems Analysis, Data Integration & ETL Engineer (REMOTE) jobs in the Radnor, PA area that may be a better fit.

    Systems Analysis, Data Integration & ETL Engineer (REMOTE)

    Lincoln Financial Services, Radnor, PA

    AI Assistant is available now!

    Feel free to start your new journey!