Back to Search

Sr. ETL Consultant

Date Posted: 10/29/2019

Apply Now

Job Description

DIRECT HIRE OPPORTUNITY!  Looking for a Sr. ETL Consultant to work in Newport Beach, CA!


Currently, we are seeking a talented Senior ETL Consultant to lead analysis and coordination of Data Integration projects of varying size and complexity in the Retirement Solutions Division based in Newport Beach, California.  The Retirement Solutions Division leverages its strengths in product development, technology, services and risk management to create retirement solutions for individuals, families, and businesses.  With the guidance of financial professionals, customers have access to an array of annuities and mutual funds designed to help grow assets and to provide retirement income for financial independence.


The RSD Data Integration team captures and incorporates diverse data from various internal systems and external vendors. Data is loaded, manipulated, and housed in the divisional data warehouse.  The team services numerous key consumers and critical downstream applications including:  BI reporting, Analytics, Actuarial models (Risk Management, Valuation), Sales & Marketing, Finance, Compliance and Operations.  In addition to support for existing processes, the team is modernizing opportunities to migrate its infrastructure technologies and data warehouse to the cloud (AWS). 

*Lead Data Integration (DI) projects of varying size and complexity including the Cloud (AWS) migration efforts.
*Conduct analysis on assigned projects and translate the business needs into business requirement document as input for system design & development, testing and user acceptance.
*Create and maintain source -target data movement specifications for an ETL tool like Informatica
*Develop and communicate work plans, schedules, project estimates and status reports for assigned projects.
*Provide creative solutions to business and technical issues, identify and propose process improvement opportunities.
*Work independently, multi-task and receives minimal guidance and oversight from manager. 

*Bachelor's degree from a four-year college or university, Master's degree in Computer or data science preferred
*5+ years of experience as technical systems analyst role in data warehouse and ETL projects
*Experience in the domain of financial services products like Annuities and Mutual funds 
*Strong SQL skills and knowledge of database objects like stored procedures/view/synonyms/indexes
*Minimum of one year hands-on experience working with Snowflake or AWS technologies (Redshift, S3, Athena, Spectrum, DMS, PostgreSQL, Glue etc.)  AWS certification preferred.
*Excellent communication, technical documentation and team work skills
*Ability to manage medium to large size projects of varying complexity
*Preferred experience in Informatica, Oracle, Control M


Must Haves

  • Informatica
  • SQL
Nice To Haves

We are an equal opportunity employer and make hiring decisions based on merit. Recruitment, hiring, training, and job assignments are made without regard to race, color, national origin, age, ancestry, religion, sex, sexual orientation, gender identity, gender expression, marital status, disability, or any other protected classification. We consider all qualified applicants, including those with criminal histor

Apply Now Send to a Friend

Job Snapshot

  • Employee Type:Full-Time
  • Location:Newport Beach, CA
  • Job Type:I.T.
  • Experience:Not Specified
  • Education:Not Specified
  • Date Posted:10/29/2019
  • Contact: Tim Kim (949) 265-6070
  • Pay Range: $110,000.00 - $130,000.00 Annually
Get Job Alertsby Email
  • Receive alerts with new job opportunities that match your interests
  • Receive relevant communications and updates from our organization

Sign Up Now

Job Reference: JO-1909-71860