Sr. Associate - SQL Developer - Compliance Department


Date: Jul 29, 2019

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


The Compliance Analytics Team is responsible for reporting compliance data on a scheduled and ad hoc basis. The team is also tasked with identifying opportunities to strengthen the Company's sales practice and supervision processes, and to provide valuable and strategic feedback to the business units on emerging sales practice trends. This is accomplished through analysis and trending, which may be used to define new reports that better identify potential risks.



  • Collect and analyze data related to customer complaints, sales, customer and agent data on a scheduled and ad hoc basis
  • Identify trends and associated root causes. Propose solutions where possible
  • Write ad hoc reports using SQL or other scripting programming tools and update existing reports when needed
  • Prepare reports for Regulators, Senior Management, New York Life’s Board of Directors and other NYL departments
  • Ensure key trends, issues and watch items are presented clearly and accurately
  • Participate in the design and testing of new reports and enhancements to existing reports and systems to improve and/or automate existing processes
  • Review business processes and coordinate with the Enterprise Technology group to ensure that all new system development and enhancements meet the business needs, are delivered on time and within budget
  • Handle special projects as needed
    Qualifications and Job Requirements
  • Bachelor’s Degree
  • At least 2-3 years of experience in compliance related field, preferably in a compliance reporting function
  • Advanced analytical and problem-solving skills
  • Analyzes possible solutions using experience, judgment and precedents. Receives a moderate level of guidance and direction
  • Knowledge of life insurance, long term care insurance and annuity products preferred
  • Strong working knowledge of the products offered by New York Life and its affiliates
  • Proficient in analytics visualization tools like Tableau and Power BI and coding languages like Python and R
  • Proficiency in leveraging technical tools for Hadoop environment is a plus
  • Proficient knowledge of script development using SQL to be run against SQL Server, Oracle and other data warehouses. Experience designing and modifying Crystal Reports for data presentation based on criteria and presentation requirements
  • Knowledge of Microsoft Excel and Access, including pivot tables, macros, forms and reports.   Demonstrates comfort with learning new technical software and analytical tools
  • Excellent written and oral communication skills with the ability to present information in differing degrees of detail and form depending on the audience
  • Excellent organization skills, ability to prioritize multiple tasks and follow through to meet deadlines
  • Must have good judgment, be a self-starter and proactive
  • Must be able to work independently as well as within a team environment



#LI –MM1



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 Segment: Developer, Database, SQL, Social Media, Outside Sales, Technology, Marketing, Sales