Senior Database Application Analyst

APPLY NOW »

Date: Oct 6, 2021

Location: White Plains, NY, US

Company: New York Life Insurance Co

 

When you join New York Life, you’re joining a company that values development, career growth, collaboration, innovation, and diversity & inclusion. We want employees to feel proud about being part of a company that is committed to doing the right thing. Through various resources and programs, you can grow your career while developing personally and professionally.

 

 

 

 Responsibilities

Corporate Finance is looking for a Senior Oracle Database Application Analyst with a minimum of 5 years of experience. The Financial Systems database team provides the data warehouse for life insurance financial and valuation reporting in support of New York Life’s Actuarial department.

The Senior Database Application Analyst position will maintaing and enhance our internal financial reporting database applications for life insurance. Database applications include implementation and enhancements for new and existing products, automation of reporting requirements, ensuring the successful monthly load of the data warehouse, creation of control processes, producing reports, including automated reports and ad hoc analyses. The database application analyst translates complex business and actuarial requirements into programming specifications and technology solutions collaborating with business, finance and technology teams.

 

The Senior Database Application Analyst position supports the life insurance financial reporting data warehouse including:

  • Collaborate with business partners to determine requirements and functional specifications
  • Liaise with technology database administrators and other areas of technology for implementations and maintenance
  • Coordinate and work with other members of the database application team to, implement, maintain and enhance process flows, database table structures, objects, reports, and queries
  • Maintenance of the database stored procedures, views and functions
  • Translate complex business and actuarial requirements into programming specifications
  • Perform programming based on specifications using tools such as Oracle SQL, Linux, PL/SQL
  • Analyze and produce adHoc and planned reporting requests for feasibility, impact on current processing and to support business needs
  • Deploy controls to meet audit requirements
  • Production support for jobs in process, troubleshoot, analyze and resolve incidents
  • Create test plans, test cases, test scripts and perform QA and validation
  • Document process flows for use by team members and external stakeholders
  • Create technical documentation for systems team
  • Maintain current knowledge of industry and technology process trends and apply that knowledge to existing processes with a focus towards process and methodology improvement
  • Provide technical expertise and recommendations in analyzing customer needs, document requirements, and design technical solutions
  • Contributes to solution design discussions

 

Qualifications

  • 4-year college degree preferred with a minimum of 5 years in a database application development or database administrator role 
  • Proficiency in Oracle SQL, Oracle PL/SQL, LINUX, TOAD, Excel
  • Knowledge of MS-Access, Python, Service Now, BI tools preferred
  • Experience in Performance Tuning and Query Optimization by Indexing, Partitioning
  • Excellent Programming experience in writing Complex Stored Procedures, Queries, Views, Cursors
  • 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, Data Warehouse Life Cycle
  • Business knowledge of Life Insurance Products
  • Ability to work on multiple projects with a sense of urgency and ability to change focus to complete critical systems
  • Excellent oral and written communication skills
  • Excellent interpersonal, organizational, and analytical skills with a problem-solution attitude
  • Detail oriented, with a comprehensive approach to validating and proofing deliverables
  • Experience working in a highly collaborative environment, proactively innovating solutions that support the goals and desired outcomes that provide business value

 

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 our Foundation. 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.

 

SF:LI-MC1

Job Requisition ID: 84859

 

 

 


Job Segment: Database, Oracle, Social Media, ERP, Developer, Technology, Marketing