Senior Associate, Sr. Net/SQL Developer (Remote Role)

APPLY NOW »

Date: Sep 7, 2022

Location: New York, NY, 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.

 

This position involves a hybrid work schedule – working remotely: Monday & Friday / on site: Tuesday through Thursday

 

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 Data Warehouse Developer is part of an agile team focused on creating and sustaining an accurate, integrated, and authoritative business information analysis capability with powerful, easy-to-use, and highly available tools. This person works to improve and extend the abilities of data analysts and managers to easily interpret large amounts of complex data to identify actionable business insights, make better business decisions, and discover strategic opportunities. This is a highly technical role that includes understanding business data analysis requirements, building new data mart components to ingest and transform business operations data, and designing and delivering business intelligence assets. In addition to technical skills, effective communication is a key success factor as changes in scope, effort, and timeline to meet business objectives is a constant requirement.

 

The Actuarial Data and Analytics (DnA) team within Actuarial Services owns the Actuarial Data Mart.  Actuarial Data Mart (ADM) is a complex environment requiring expertise with:

 

  • Microsoft SQL Server
  • Visual Studio
  • Team Foundation Services / Azure Development Operations
  • SQL Server Data Tools (SSDT)
  • SQL Server Management Studio (SSMS)
  • SQL Server Integration Services (SSIS)
  • SQL Server Analysis Services (SSAS)
  • Microsoft Master Data Services (MDS)

 

Responsibilities

The developer will support the development and implementation of ongoing improvements and change requests to the data architecture of the Actuarial Data Mart required to meet or exceed the need of financial reporting and analytics.

  • Work with business analysts and stakeholders to understand requirements for data analysis, data structures, information delivery and reporting.
  • Perform data analysis and develop source-to-target data mapping.
  • Work with data architects to design and implement data mart components including database tables, views, stored procedures, databases, etc.
  • Develop extract-transform-load (ETL) processes using SSIS to extract data from various data sources, transform and normalize it as necessary, and ingest it into the Actuarial Data Mart.
  • Test, deploy and promote database objects to system environments following standard methodologies.
  • Use sound software engineering principles to ensure that data mart components are modifiable, efficient, reliable, understandable, and fault tolerant.
  • Perform system maintenance and support including modifying existing data mart code as needed.
  • Provide production support for production jobs and processes by working with operators, network administrators, technical support staff, application development teams, and 3rd party vendors to implement tactical solutions and maintain high availability of data mart systems.
  • Work with technical support staff to determine root cause of production database application issues.
  • Support business users and other stakeholders with the use of data warehouse systems, user acceptance testing, etc.
  • Create and maintain documentation for data mart components, technical specifications, and other technical documentation for use by the team and other stakeholders.

 

Qualifications

We are looking for someone with the following skill set:

  • Bachelor of Science degree in Computer Science, Information Systems, or equivalent preferred.
  • Five to seven years of relevant experience.
  • Ability to manage workload and priorities in a fast-paced, multi-tasking environment.
  • Experience working in an Agile software development methodology (e.g., Scrum, Kanban).
  • Proficient skills with Oracle, SQL Server, and SSIS.
  • Experience with relational and dimensional databases.
  • Experience with integrated development environments (IDE) such as Visual Studio.
  • Experience with source code management tools such as TFS/DevOps and Git.
  • Strong PC experience including Windows and the MS Office suite.
  • Strong oral and written communications.
  • Ability to effectively function as a member of a team.
  • Ability to share learned knowledge to increase support level of database systems.
  • Willingness to learn through on-the-job experience and to support new technology.
  • Willingness to perform additional, unplanned project work as assigned.

 

Preferred skills/experience

  • Database certifications in Oracle or MS SQL Server
  • Familiar with C# Development of SSIS Components to add to the SSIS Toolbox
  • Ability to script in MDX as well as T-SQL

 

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 www.NewYorkLife.com.

Job Requisition ID: 87186

 

 

 


Nearest Major Market: Manhattan
Nearest Secondary Market: New York City

Job Segment: Database, SQL, Test Engineer, Accounting, Actuarial, Technology, Engineering, Finance, Insurance