Systems Analysis, Data Integration & ETL Engineer (REMOTE)
Lincoln Financial Group - Radnor, PA
posted 2 days ago
About the position
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.
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.
Requirements
- 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: SQL, Informatica, Python & PySpark, Data Modeling
Nice-to-haves
- 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
Benefits
- 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
