Sr. ETL Data Software Engineer

Company: Lincoln Financial Group
Location: Cheyenne
Posted on: March 18, 2023

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 #: 71248
The Role at a Glance
This is a great opportunity to join the growing Life IT organization at Lincoln Financial Group to build next generation application solutions to help our customers achieve their financial goals and objectives. This position will consult/analyze and deliver on more complex assignments/projects for your assigned area(s) of application development responsibility to build out a new data and analytics platform on AWS to integrate with a number of back-end applications. You will also act as a resource and develop more complex innovative business solutions by creating new applications, modifying existing applications and providing post production support (as necessary). You will deliver more complex business application software solutions following the system development life cycle process.
What you'll be doing

• 
  
• 
  Participates in analysis, design, and ETL development as part of Agile / Scrum Develop Team
  
  
• 
  Architect, implement and support big data initiatives for the enterprise (using AWS, Informatica and Python to further these objectives)
  
  
• 
  Lead other developers, solution designers and quality analysts on project led efforts to add new data sources to the Life data platform
  
  
• 
  Understands data mapping and data modeling methodologies including normal form, star, and snowflake to reduce data redundancy and improve data integrity.
  
  
• 
  Liaise with internal Lincoln business partners on requirements, design, testing and production topics in order to create solution proposals and develop code.
  
  
• 
  Performs technical tasks including estimating, analysis, technical requirements, design, construction 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-premise and in the Cloud.
  
  
• 
  Develop, enhance, and support Informatica workflows and processes using Informatica Power Center for the extraction and transformation of data in UNIX/Oracle, Windows/MS SQL Server and Aurora/postgres database environments.
  
  
• 
  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
  
  
• 
  Provides direction on complex assignments, projects, and/or initiatives to build and enhance the capability of his/her assigned area(s) of responsibility
  
  
  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
    
    
  • 
    5+ years developing data movement and engineering applications and worked on integrating disparate systems using ETL following SDLC and/or Agile methodologies7+ years of experience in ETL application development that directly aligns with the specific responsibilities for this position
    
    
  • 
    10+ years utilizing Structured Query Language optimization on platforms including Redshift, Oracle, Postgres in order to build and manage large scale data warehouses
    
    
  • 
    10+ years utilizing programming languages such as Python in order to program and develop software
    
    
  • 
    3 + years of experience in Informatica Big Data Management Solution on AWS Cloud
    
    
  • 
    3 + years of experience working on Elastic Map Reduce using AWS Cloud services to process massive amount using Informatica Big Data Management solution
    
    
  • 
    5+ years of experience in Informatica PowerCenter (or comparable tool) developing ETL mappings using Designer, Workflow Manager, Workflow Monitor, and Repository Manager
    
    
  • 
    5+ years of experience with Architecture Design and Data Modeling
    
    
  • 
    5+ years of experience writing Unix/Linux or Windows Scripts in tools such as PERL, Shell script, Python, etc.
    
    
  • 
    2+ years of experience in scheduling jobs using Autosys (or comparable distributed scheduler)
    
    
  • 
    5+ years of experience in creating complex technical specifications from business requirements/specifications
    
    
  • 
    3+ years of experience as a Sr Developer leading/mentoring other Developers on the team
    
    
  • 
    Big Data - NO SQL Modeling, Hive, HBase, Pig, Cassandra, MongoDB, Redshift utilizing AWS Services and integrating data on cloud is a plus
    
    
    #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 (https://hrdirectdocs.lfg.com/misc/HR/Recruiting/BenefitsResourcesGuide.pdf)
      
      
    • 
      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: $102,301 - $184,500
      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, a Fortune 200 company with over 10,000 employees, provides advice and solutions that help empower Americans to take charge of their financial lives with confidence. Our core business areas - Life Insurance, Annuities, Retirement Plan Services and Group Protection - focus on supporting, preserving and enhancing over 17 million customer's lifestyles and retirement outcomes.
      Headquartered in Radnor, Pennsylvania, Lincoln Financial Group is the marketing name for Lincoln National Corporation (NYSE: LNC) and its affiliates. The company had $324 billion in end-of-period account values as of June 30, 2021.
      Ranked one of the Best Large Employers in America and Best Employers for Women by Forbes magazine as well as one of Newsweek's Most Responsible Companies, Lincoln Financial Group makes a serious investment in our employees' futures through a broad range of wealth accumulation and protection plans, health and wellness programs, and career development resources designed to help each individual reach their personal and professional goals.
      Lincoln is committed to creating a diverse and inclusive (https://www.lfg.com/public/aboutus/companyoverview/diversityinclusion?audience_page_id=1422918942386) 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.
      Lincoln Financial Group is a committed corporate citizen included on major sustainability indices including the Dow Jones Sustainability Index North America and FTSE4Good. Dedicated to diversity and inclusion, we earned perfect 100 percent scores on the Corporate Equality Index and the Disability Equality Index. Follow us on Facebook (http://www.facebook.com/lincolnfinancialgroup) , Twitter (https://mobile.twitter.com/lincolnfingroup) , LinkedIn (https://www.linkedin.com/company/4307?trkInfo=tas%3Alincoln+financial%2Cidx%3A3-1-3&trk=tyah) , and Instagram (https://www.instagram.com/lincolnfingroup/) . Sign up for email alerts at http://newsroom.lfg.com
      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/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 (https://www.e-verify.gov) notices.
      Este Empleador Participa en E-Verify. Ver el E-Verify (https://www.e-verify.gov/es) avisos.
      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, veterans status, or genetic information. Opportunities throughout LFG are available to employees and applicants and are evaluated on the basis of job qualifications. We have a drug free work environment and we perform pre-employment substance abuse testing.

Keywords: Lincoln Financial Group, Cheyenne , Sr. ETL Data Software Engineer, IT / Software / Systems , Cheyenne, Wyoming