ETL Developer

Date: Oct 12, 2021

Location: Dover, NH, US

Company: Lincoln Financial

Alternate Locations: Dover, NH (New Hampshire); Work from Home (Excluding Colorado)

 

Work Arrangement: Work from Home

 

Relocation assistance is not available for this opportunity.

 

Level: P3 

 

Requisition #: 66762

 

 


 

 

The Role at glance:

This is an exciting opportunity within Lincoln’s Group Protection IT Data Team for an ETL Developer to help build solutions for Lincoln’s Group Protection business.  This is a work from home opportunity.

Background Details:

This position will assist Analytical Teams with the design and implementation of Data solutions and systems, including integration with databases and data warehouses, both on-Premise and in the Cloud.  This candidate must be able to develop, enhance, and support Informatica workflows and processes using Informatica Power Center and Dataiku for the extraction and transformation of data in a UNIX and Oracle database environment.  They must also have experience working within BI tools such as Tableau and Microstrategy.  Experience working in the cloud using AWS native services such as Glue, Athena, Aurora, Redshift is needed.  The candidate must have experience participating in and beginning to lead teams within a Data Organization by suggesting new and innovative ways of gaining data processing efficiencies and participating in architectural and modeling discussions.
 

What you'll be doing:

  • Participates in defining architecture and modeling best practices within the team
  • Develop tools and work on integrating disparate systems using ETL 
  • Work on transformation of data into Facts and Dims in a Kimball model
  • Works with Sr. Technical Professionals to implement data development best practices 
  • Develop, enhance and support Informatica workflows and processes using Informatica Power Center for the extraction and translation of data in a UNIX and Oracle database environment. 
  • Develop, enhance and support Dataiku workflows and processes for transforming data into Kimball model Facts/Dims
  • Creates partnerships with stakeholders, POs, BSAs and Analytic teams in requirement, design and coding walkthroughs to ensure the development of quality solutions and understand complex business/technical problems and opportunities and identify potential application solutions.
  • Demonstrates expertise in a variety of the data warehouse concepts, practices, and procedures. Relies on extensive experience and judgment to plan and accomplish goals
  • Analyzes operational and analytical data requirements by working with cross functional business and application development teams
     

What we're looking for:

Must-haves:

  • Experience with ETL development
  • Must have experience with Informatica & Dataiku
  • Must have experience with BI tools such as Tableau and Microstrategy
  • Experience with AWS cloud native services, such as: Glue, Athena, Aurora, Redshift
  • Must have a proven track record working closely with business stakeholders, BSAs, and POs, Solution Architects to understand requirements and expectations to achieve quality technical solutions
  • 3 - 5+ Years’ experience in application development that directly aligns with the specific responsibilities for this position
  • 4 Year/Bachelor's degree or equivalent work experience
    • Degrees could be in:  Computer Science, Computer Information Systems, Information Systems, Information Technology or Computer Engineering or equivalent work experience 
       

 

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 

  • Ten Weeks 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 

  • Effective productivity/technology tools and training 

 

About the Company/Who is Lincoln Financial  

Led by over 10,000 employees Lincoln Financial Group provides advice and solutions that help empower people to take charge of their financial lives with confidence and optimism. Today, more than 17 million customers trust our retirement, insurance and wealth protection expertise to help address their lifestyle, savings and income goals, as well as to guard against long-term care expenses. Lincoln is committed to creating a diverse and inclusive 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. 

 

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.

 

 

Work Arrangement:

Work from Home : Employees will work fully from home. Their job will not require the employee to come into the office, unless for special circumstances. 

 

 

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, veterans 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.

 

 

#[[customString5]] 


Nearest Major Market: Dover

Job Segment: Database, Bank, Oracle, Banking, ERP, Technology, Finance