Radnor, PA, US
9 hours ago
Systems Analysis, Data Integration & ETL Engineer (REMOTE)

Alternate Locations: Radnor, PA (Pennsylvania)

 

 Work Arrangement:

Remote : Work at home employee residing outside of a commutable distance to an office location.

 

Relocation assistance:  is not available for this opportunity.

 

Requisition #: 74107

 

The Role at a Glance

 

This engineer position will analyze and deliver on complex assignments/projects for their assigned area(s) of application development responsibility. In this role, you will be responsible for working with business analysts and product owners to transform ideas and business requirements into refined technical requirements.  You will also be responsible for hands-on development, creating and modifying Informatica ETLs for our Retirement Plan Services business as well as contributing to building new (and migrating existing) functionality to our AWS Workplace Solutions data platform. 

 

The ideal candidate must have a demonstrated background in systems analysis with a focus in data-centric projects/efforts.  They must have excellent soft skills and the ability to communicate complex concepts in an easy-to-understand manner (verbally and visually); success in this role is predicated on building and managing relationships across teams in both business and IT.

 

They must also have experience in data pipelines, performance optimization and/or data modeling. This ideal candidate will have well-rounded experience across analysis, development and quality assurance/testing.  This role will also contribute to the design, development and implementation of business solutions by creating new applications, modifying existing applications and providing post-production support. 

 

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 SQL 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 (e.g. 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

Competitive 401K and employee benefits

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.

 

About The Company

Lincoln Financial Group helps people to plan, protect and retire with confidence. As of Dec. 31, 2023, approximately 17 million customers trust our guidance and solutions across four core businesses – annuities, life insurance, group protection and retirement plan services. As of December 31, 2023, the company had $295 billion in end-of-period account balances, net of reinsurance. Headquartered in Radnor, Pa., Lincoln Financial Group is the marketing name for Lincoln National Corporation (NYSE: LNC) and its affiliates. Learn more at LincolnFinancial.com.

 

Lincoln is committed to creating a diverse and inclusive environment and is proud to be an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, disability, age, or veteran status. 

 

Follow us on Facebook, X, LinkedIn, and Instagram. For the latest company news, visit our newsroom. 

 

Be Aware of Fraudulent Recruiting Activities

If you are interested in a career at Lincoln, we encourage you to review our current openings and apply on our website. Lincoln values the privacy and security of every applicant and urges all applicants to diligently protect their sensitive personal information from scams targeting job seekers. These scams can take many forms including fake employment applications, bogus interviews and falsified offer letters.

Lincoln will not ask applicants to provide their social security numbers, date of birth, bank account information or other sensitive information in job applications. Additionally, our recruiters do not communicate with applicants through free e-mail accounts (Gmail, Yahoo, Hotmail) or conduct interviews utilizing video chat rooms. We will never ask applicants to provide payment during the hiring process or extend an offer without conducting a phone, live video or in-person interview.  Please contact Lincoln's fraud team at fraudhotline@lfg.com if you encounter a recruiter or see a job opportunity that seems suspicious.

 

Additional Information

This position may be subject to Lincoln’s Political Contribution Policy.  An offer of employment may be contingent upon disclosing to Lincoln the details of certain political contributions. Lincoln may decline to extend an offer or terminate employment for this role if it determines political contributions made could have an adverse impact on Lincoln’s current or future business interests, misrepresentations were made, or for failure to fully disclose applicable political contributions and or fundraising activities.

 

Any unsolicited resumes or candidate profiles submitted through our web site or to personal e-mail accounts of employees of Lincoln Financial Group are considered property of Lincoln Financial Group and are not subject to payment of agency fees.

 

Lincoln Financial Group (“LFG”) 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 (including pregnancy), age, national origin, disability, sexual orientation, gender identity and expression, Veteran status, or genetic information.  Applicants are evaluated on the basis of job qualifications.  If you are a person with a disability that impedes your ability to express your interest for a position through our online application process, or require TTY/TDD assistance, contact us by calling 260-455-2558.

 

This Employer Participates in E-Verify. See the E-Verify notices.

Este Empleador Participa en E-Verify. Ver el E-Verify avisos. 

Confirm your E-mail: Send Email