Business Intelligence Solution Architect in Clinton, New Jersey | DiversityInc Careers
This job has expired and you can't apply for it anymore. Start a new search.

Business Intelligence Solution Architect

New York Life Insurance Company (“New York Life” or “the company”) is the largest mutual life insurance company in the United States*. Founded in 1845, New York Life is headquartered in New York City, maintains offices in all fifty states, and owns Seguros Monterrey New York Life in Mexico.


New York Life is one of the most financially strong and highly capitalized insurers in the business. The company reported 2016 operating earnings of $1.954 billion. Total assets under management at year end 2016, with affiliates, totaled $538 billion.  As of year-end 2016, New York Life’s surplus was $23.336 billion**.  New York Life holds the highest possible financial strength ratings currently awarded to any life insurer from all four of the major ratings agencies: A.M. Best, A++; Fitch AAA; Moody’s Aaa; Standard & Poor’s AA+. (Source: Individual Third Party Ratings Report as of 8/17/16).


Financial strength, integrity and humanity—the values upon which New York Life was founded—have guided the company’s decisions and actions for over 170 years.


This role requires an individual with a strong sense of ownership, technical and analytical expertise as well as the ability to effectively communicate between business teams and technical teams.  In this role, you will focus on building out our client and product data foundation requiring technical data/ETL/programming skills to ingest, wrangle and explore data.  In addition the role also requires you to function as a data expert, create dashboards, KPIs and develop innovative ways of leveraging data to support a wide cross section of our organization.


The ideal candidate will apply a high energy level and business sense to work and communicate with key stakeholders across Technology, Sales, Marketing, Relationship Management and Product Development/Management.



  • Identify, analyze, and interpret trends or patterns in complex data sets and develop graphs, reports, and presentations of results
  • Develop and produce KPIs, dashboards and scorecards
  • Surfacing information priority: Assessing the benefits and the risks of information and create an information-centric view to quickly visualize what information matters most to the organization based on the defined business strategy.
  • Enhancing decision making: Provide the organization with a future-state view of the information landscape that is unencumbered by the specific data implementation details imposed by proprietary solutions or technologies.
  • Creating more value from data: Exploring the impact of business strategy changes on information management and investigating ways to extract additional value from existing information assets.
  • Data modeling: Creating and managing data models in all their forms, including conceptual models, relational database designs, data flows and others.
  • Managing existing data: Ensuring that the architecture is used as a lens and a filter to focus only on those internal and external data sources and repositories required to deliver the targeted business value. Other responsibilities include master data management (MDM), metadata management, analytics, content management, data integration, and related information management or information infrastructure components
  • Develop business process models and documentation for internal and external data sources coming into Hadoop Data Lake and SQL Server/Oracle data warehouses.
  • Analyze and evaluate data / information gathered from multiple sources and reconcile / address conflicts or business issues
  • Write SQL to query complex data structures
  • Utilize data wrangling, data matching and ETL techniques to explore variety of data sources, gain data expertise and create datasets to support advanced modeling and Business Intelligence reports



    Required Skills / Knowledge:

  • 5+ years experience as a Business/Data Analyst, position level commensurate with experience
  • Expertise in SQL Server and/or R, Hadoop, MS Excel, Qlik
  • Excellent understanding of data and relationship. Ability to write SQL to query complex data structure.
  • Strong background in data modeling, data management and data manipulation
  • Demonstrated ability to be proficient at querying and managing data
  • High level of curiosity and investigative mind-set with an attention to detail
  • Experience using large databases to solve problems
  • Strong analytical, creative thinking and problem solving skills
  • Excellent interpersonal skills and highly experienced at dealing with clients/users at all levels
  • Experience working with Big Data is a plus


    Education - Degrees/Certificates:






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.


*Based on revenue as reported by “Fortune 500, ranked within Industries, Insurance: Life, Health (Mutual),” Fortune Magazine, June 17, 2016.  See  for methodology.

**Total surplus, which includes the Asset Valuation Reserve, is one of the key indicators of the company’s long-term financial strength and stability and is presented on a consolidated basis of the company.


1. Operating earnings is the key measure use by management to track Company’s profitability from ongoing operations and underlying profitability of the business. This indicator is based on generally accepted accounting principles in the US (GAAP), with certain adjustments Company believes to be appropriate as a measurement approach (non GAAP), primarily the removal of gains or losses on investments and related adjustments.


2. Assets under management represent Consolidated Domestic and International insurance Company Statutory assets (cash and invested assets and separate account assets) and third party assets principally managed by New York Life Investment management Holdings LLC, a wholly owned subsidiary of New York Life Insurance Company.