SENIOR ASSOCIATE - Data Warehouse / ETL Developer


Date: Sep 22, 2022

Location: Austin, TX, US

Company: New York Life Insurance Co



When you join New York Life, you’re joining a company that values career development, collaboration, innovation, and inclusiveness. We want employees to feel proud about being part of a company that is committed to doing the right thing. You’ll have the opportunity to grow your career while developing personally and professionally through various resources and programs. New York Life is a relationship-based company and appreciates how both virtual and in-person interactions support our culture.


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  and maintain SSIS packages, projects, solutions to import/export data, and load and process data.
•    Support nightly loads and various Data Warehouse activities.
•    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.

•    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

•    Excellent Programming experience in writing Complex Stored Procedures, Queries, Views, User Defined Functions, Cursors and Common Table Expressions using T-SQL.
•    Proficient 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),  and Data Warehouse Life Cycle
•    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.


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 volunteerism, supported by the Foundation. We're proud that due to our mutuality, we operate in the best interests of our policy owners. 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

Job Requisition ID: 87676




Nearest Major Market: Austin

Job Segment: Data Warehouse, Testing, Developer, SQL, Database, Technology