AWS Cloud Data Engineer & Delivery (REMOTE) at Lincoln Financial Group in Boise, Idaho, United States 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. What we’re looking for + 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. Must-haves + 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) Nice-to-haves + Knowledge of insurance, financial systems/products Life Insurance, Annuity and 401k/ 403K + AWS Developer or Architect or Specialty Certification (Active certifications) #DICE 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: + A clearly defined career framework to help you successfully manage your career + 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 Pay Range: $87,700 – $155,000 Actual base pay could vary 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 provides advice and solutions that help people take charge of their financial lives with confidence and optimism. Today, approximately 16 million customers trust our To view full details and how to apply, please login or create a Job Seeker account
PostgreSQL Git SDLC amazon-s3 Python Amazon Web Services (AWS) data-security Amazon Redshift aws-lambda DevOps amazon-cloudformation data governance microstrategy ETL amazon-rds aws-glue amazon-iam liquibase