Urgently Need AWS Cloud Data Engineer & Delivery (REMOTE) in Radnor, PA
Job title: AWS Cloud Data Engineer & Delivery (REMOTE)
Company: Lincoln Financial Group
Job description: Alternate Locations: Work from Home
Work Arrangement:
Hybrid/Flexible : Work at home and use the office as appropriate for in-person collaboration.
Relocation assistance: is not available for this opportunity.
Requisition #: 72250
The Role at a Glance
This role will provide subject matter expertise and direction on complex projects/initiatives related to the configuration of systems and across operations for LFD IT data in applicable system(s). They will collaborate with business and IT teams and other stakeholders to understand data warehouse design and will focus on maintaining and improving our data environment, as well as providing expertise on system functionality to accommodate requirements. They will configure applicable system(s) when appropriate to provided required capabilities.
This position will consult/analyze, design, and build on data assignments/projects for your assigned area(s) of application design responsibility to build out a data transformation through ETL on AWS to integrate with number of upstream and downstream applications.
What you'll be doing
- Participates in analysis, design, and build solution as part of Agile / Scrum Develop Team.
- Implement and support large data initiatives for the enterprise (using AWS PostgreSQL, Redshift, Glue and Python to further these objectives).
- Understands data mapping and data modeling methodologies including normal form, star, and snowflake to reduce data redundancy and improve data integrity.
- Consult with internal Lincoln business partners on requirements, design, testing and production topics to create solution proposals and develop code.
- Performs technical tasks including estimating, analysis, technical requirements, design, build and unit & integration testing following SDLC.
- Assist analytical teams with the design and implementation of Data solutions and systems, including integration with Operational Datastores and Data Warehouses, both on-premises and in the Cloud.
- Maintains knowledge on current and emerging developments/trends for assigned area(s) of responsibility, assesses the impact, and collaborates with Scrum Team and Leadership to incorporate new trends and developments in current and future solutions.
- Participates and enhances organizational initiatives by positively influencing and supporting change management and/or departmental/enterprise initiatives within assigned area(s) of responsibility.
- Identifies and directs the implementation of process improvements that significantly improve quality across the team, department and/or business unit for his/her assigned area(s) of responsibility.
- Provides expertise to team members and applicable internal/external stakeholders on complex assignments/projects for his/her assigned area(s) of responsibility.
- Assists on complex assignments, projects, and/or initiatives to build and enhance the capability of his/her assigned area(s) of responsibility.
- Coordinate and release management activities the functions of (continuous integration/continuous delivery) Pipeline and is responsible in creating and maintaining automated CICD build and release pipelines using GitLab DevOps.
- 4 Year/bachelor's degree or equivalent work experience (4 years of experience in lieu of Bachelors) _Minimum Required in Computer Science, Computer Information Systems, Information Systems, Information Technology or Computer Engineering or equivalent work experience.
- 3+ years developing data movement and engineering applications and worked on integrating disparate systems using batch ETL/API following SDLC and/or Agile methodologies.
- 3+ years of experience working on various AWS Cloud services as Data Engineer experience.
- 3+ years of experience in creating complex technical specifications from business requirements/specifications.
- 2+ years of experience in scheduling jobs using Autosys (or comparable distributed scheduler like Stonebranch)
- Strong understanding of data architecture principles, methodologies, and best practices.
- Proficiency in relational database management systems, particularly AWS RDS and Postgres.
- Experience with data integration technologies and ETL tools a plus
- In-depth knowledge of AWS data services such as AWS Redshift, AWS Athena, AWS S3 and AWS Lambda a plus
- Experience in writing cloud formation templates and build IAM roles and policies.
- Understanding of data governance frameworks, data quality management, and data security practices.
- Strong analytical, problem-solving, and critical-thinking skills.
- Self-starter and highly motivated individual with strong AWS skills, problem solving skills, attention to detail, and ability to work in a fast-paced environment.
- Expert in development of cloud base Data analytics solution, adoption cloud architecture, engineering, modeling, enterprise data platforms, based on Event-driven architecture, Microservices Pattern or serverless pattern implementations.
- AWS Glue/ Python/ Cloud Database development experience
- Rest API development experience
- Moderate to senior database knowledge (PostgreSQL, Redshift)
- Effective communication skills of complex solutions to technical and non-technical audience
- Solid understanding of DevOps processes and best practices.
- Knowledge of source control (Git or similar).
- Knowledge of Liquibase deployment patterns.
- Knowledge of MuleSoft API is plus.
- Knowledge of Salesforce CRM is plus.
- Knowledge of MicroStrategy or other BI reporting is plus.
- Knowledge of Master Data Management (MDM)
- Knowledge of insurance, financial systems/products Life Insurance, Annuity and 401k/ 403K
- AWS Developer or Architect or Specialty Certification (Active certifications)