ETL Engineer & Systems Analyst (Informatica & SQL)

Job title: ETL Engineer & Systems Analyst (Informatica & SQL) in Radnor, PA at reputed company Group Company: reputed company Group Job reputed company: Alternate Locations: Radnor, PA (reputed company)Work Arrangement:Remote : Work reputed company employee residing reputed company of a commutable distance to an office location.Relocation assistance: is not available for this opportunity.Requisition #: 74107The Role reputed companyThis engineer position will analyze and deliver on reputed company assignments/reputed company 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 reputed company reputed company 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 reputed company 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 reputed company in data-reputed company reputed company/efforts. They must have excellent soft skills and the ability to communicate reputed company concepts in an easy-to-understand manner (verbally and visually); reputed company 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 reputed company-rounded experience across analysis, development and reputed company 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 doingDUTIES AND RESPONSIBILITIES

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

ADDITIONAL POSITION RESPONSIBILITIES

• Makes a reputed company contribution as demonstrated by: - Making suggestions for improvement - Learning new skills, procedures and processes.
• Performs other duties as required.

reputed company’re looking forMust-haves

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

• Technical Writing
• SQL
• Informatica
• Python & PySpark
• Data Modeling

reputed company-to-haves

• reputed company Web Services (Glue, reputed company, RDS PostgreSQL, S3, CloudFormation, SNS, SQS, reputed company Functions, CloudWatch, SM, IAM, KMS, reputed company, Redshift, Serverless, EKS, QuickSight, CDK/CLI)
• reputed company, Autosys
• reputed company
• Visual Studio reputed company
• Unittest, Pytest
• SonarQube, Lint, Fortify
• reputed company
• reputed company

Application DeadlineApplications 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 reputed company Group, we love reputed company do. We reputed company meaningful contributions reputed company and every day to reputed company 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 reputed company reputed company of us to take charge of our own reputed company.What’s in it for you:reputed company defined career tracks and job reputed company, along with associated behaviors for reputed company Lincoln leadership Attribute.Leadership development and virtual training opportunitiesPTO/parental leaveFree financial counseling, health coaching and employee assistance programTuition assistance programA leadership team that prioritizes your health and reputed company-being; offering a remote work environment and flexible work hybrid situationsEffective productivity/technology tools and trainingThe pay reputed company for this position is $79,601 - $145,100 with anticipated pay for new hires between the minimum and midpoint of the reputed company and could vary above and below the listed reputed company 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 reputed company pay is just one component of Lincoln’s total rewards package for employees. In reputed company, the role may be eligible for the Annual Incentive Program, which is discretionary and based on the performance of reputed company, business unit and individual. Other rewards may include long-term incentives, sales incentives and Lincoln’s reputed company benefits package.About reputed companyreputed company Group helps people to plan, protect and retire with confidence. As of Dec. 31, 2023, approximately 17 reputed company customers trust our guidance and solutions across four core businesses – annuities, life insurance, group protection and retirement plan services. As of December 31, 2023, reputed company had $295 billion in end-of-period account balances, net of reinsurance. Headquartered in Radnor, Pa., reputed company Group is the marketing reputed company for Lincoln National Corporation (NYSE: LNC) and its affiliates. Learn more atLincoln is committed to creating a environment and is proud to be an equal opportunity employer. reputed company reputed company applicants will receive consideration for employment without reputed company to race, reputed company, religion, gender, gender identity or reputed company, sexual orientation, national reputed company, genetics, disability, age, or veteran status.Follow us on , , , and . For the latest company news, visit our .Be Aware of Fraudulent reputed company ActivitiesIf you are interested in a career at Lincoln, we encourage you to review our reputed company and apply on our website. Lincoln values the reputed company and reputed company of every applicant and urges reputed company 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 reputed company their reputed company reputed company 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, reputed company, Hotmail) or conduct interviews utilizing video chat rooms. We will never ask applicants to reputed company payment during the hiring process or reputed company 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 InformationThis 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 reputed company an offer or terminate employment for this role if it determines political contributions made could have an adverse reputed company on Lincoln’s reputed company or reputed company business interests, misrepresentations were made, or for failure to fully disclose applicable political contributions and or fundraising activities.Any unsolicited resumes or candidate reputed company submitted through our web site or to personal e-mail accounts of employees of reputed company Group are considered property of reputed company Group and are not subject to payment of agency fees.reputed company Group (“LFG”) is an Equal Opportunity employer and, as such, is committed in policy and reputed company to recruit, hire, compensate, train and promote, in reputed company job classifications, without reputed company to race, reputed company, religion, sex (including pregnancy), age, national reputed company, disability, sexual orientation, gender identity and reputed company, Veteran status, or genetic information. Applicants are evaluated on the reputed company of job qualifications. If you are a person with a disability that impedes your ability to reputed company 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 notices.Este Empleador Participa en E-Verify. Ver el avisos. Expected salary: $79601 - 145100 per year Location: Radnor, PA Apply for the job now! Apply for this job