New York Life is seeking to improve the accuracy, consistency, and interpretability of data used in decision-making for its accelerated underwriting programs and mortality risk predictive models
Requirements
- Strong SQL skills
- Proficiency in SQL for data extraction and validation
- Proficiency in Excel for analysis and quality checks
- Familiarity with Tableau or other visualization tools is helpful for dashboard maintenance
- Ability to clearly document queries and data logic
- Comfortable working with large relational datasets and integrating multiple data sources
Responsibilities
- Support monitoring and reporting for accelerated underwriting programs and related models by writing SQL queries, validating data, and maintaining recurring dashboards and reports used by business leadership and cross-functional partners
- Assist in preparing metrics and exhibits for recurring reports that summarize program performance, identify trends or anomalies, and support executive discussions
- Conduct ad hoc analyses related to predictive model performance, fraud detection, protective value studies, and mortality risk, working in collaboration with other analysts
- Contribute to data infrastructure improvements, including the replatforming of datasets from Redshift to Databricks and DBT, and the alignment of data definitions and metrics across multiple product lines
- Collaborate with IT and data partners to ensure data integrity, troubleshoot issues, and document key logic and data transformations used in reporting
- Develop technical and business expertise in external underwriting data sources and their connection to underwriting and risk management
- Engage with business partners and end users to understand data needs, clarify metric definitions, and communicate results in a clear and actionable way
Other
- BA Degree in Computer Science, Data Science, Data Analytics/Business Intelligence
- 1-3 years of experience
- Effective communication skills and the ability to translate technical findings for business partners
- Ability to work in a team environment and collaborate with cross-functional partners
- Expected to gain a thorough understanding of the business, developing both technical proficiency and subject matter expertise that enable independent analysis and effective collaboration with cross-functional teams
