ETL / Data Warehouse Developer

APPLY NOW »

Date: Feb 21, 2021

Location: Austin, TX, US

Company: New York Life Insurance Co

 

A career at New York Life offers many opportunities. To be part of a growing and successful business. To reach your full potential, whatever your specialty. Above all, to make a difference in the world by helping people achieve financial security. It’s a career journey you can be proud of, and you’ll find plenty of support along the way. Our development programs range from skill-building to management training, and we value our diverse and inclusive workplace where all voices can be heard. Recognized as one of Fortune’s World’s Most Admired Companies, New York Life is committed to improving local communities through a culture of employee giving and service, supported by our Foundation. It all adds up to a rewarding career at a company where doing right by our customers is part of who we are, as a mutual company without outside shareholders. We invite you to bring your talents to New York Life, so we can continue to help families and businesses “Be Good At Life.” To learn more, please visit LinkedIn, our Newsroom and the Careers page of www.NewYorkLife.com.

 

General Overview:

The primary job function is to develop, test, tune, and maintain database software applications in support of the achievement of business requirements.  The position is expected to develop both data warehouse and ETL artifacts based on a defined architecture.  This would include database tables, views, stored procedures, etc., and SSIS packages.  This role is also expected to meet with their business counterparts to discuss requirements and understand their needs to provide recommendations on a solution to support the requirements.

 

 Primary Responsibility:

  • Contributes to the development and executes to deliver a future state architecture that transforms our current technology landscape to service oriented decoupling presentation layers and business logic from systems of record.
  • Provide technical expertise and recommendations in analyzing customer needs, document requirements, and design technical solutions.
  • Contributes to solution design discussions
  • Supports application teams in utilizing the integration layer effectively to facilitate speed to delivery of business capabilities
  • Create SSIS packages to import/export data, and load and process data.
  • Prepare data for job runs. Support jobs in process. Troubleshoot, analyze and repair job issues.
  • Develop and enhance stored procedures. Write ad-hoc SQL queries to support report requests.
  • Create test plans, test cases, test scripts and perform data testing and validation.
  • Experience creating technical design documentation.
  • Excellent work ethics, self-motivated, quick learner, and team oriented.

 

 

 

 

   Experience:

  • A minimum of 3 years of data warehouse / ETL development experience.
  • Experience in a BI/Data Warehouse environment with involvement in design and architecture.
  • Experience developing ETL solutions utilizing SSIS including Requirement Gathering, Analysis, Design, Development and Implementation of Enterprise solutions.
  • Experience in Performance Tuning and Query Optimization by Indexing, Partitioning and Denormalization.
  • Experience  working in a highly collaborative environment, proactively innovating solutions that support the goals and desired outcomes  that provide business value

 

 

 

 

Skills:

  • Excellent Programming experience in writing Complex Stored Procedures, Queries, Views, User Defined Functions, Cursors and Common Table Expressions using T-SQL.
  • Expert in creating tables, indexes, keys, constraints and triggers to facilitate efficient data manipulation, integration and consistency.
  • Excellent understanding of Entity-Relationship/Multidimensional Data Modeling (Star schema, Snowflake schema), Data Warehouse Life Cycle and SQL Server Analysis Services (SSAS).
  • Worked on Design, Development, Deployment & Maintenance of ETL process using SSIS to Extract, Transform and Load (ETL) data from various sources (Flat/XML/SQL/Oracle) to different targets (SQL/HDFS).
  • Excellent written and oral communications
  • Excellent listening and interpersonal skills
  • Ability to build and maintain exceptional working relationships in a diverse environment
  • Highly self-motivated and directed with ability to facilitate or independently research application issues
  • Proven ability to work in a team-oriented environment
  • Possess high level of organizational skill and keen attention to detail

 

 

Education - Degrees/Certificates

  • Bachelor’s degree in an engineering, computer science, or related discipline.

SF:LI-KV1

EOE M/F/D/V

 

If you have difficulty using or interacting with any portions of this Web site due to incompatibility with an Assistive Technology, if you need the information in an alternative format, or if you have suggestions on how we can make this site more accessible, please contact us at: (212) 576-5811.

Job Requisition ID: 83195 


Nearest Major Market: Austin

Job Segment: Data Warehouse, Database, Developer, Engineer, Social Media, Technology, Engineering, Marketing