Northwestern Mutual is looking to support its Advanced Markets function and identify opportunities for automation within data capturing, analysis, and reporting using visualization tools.
Requirements
- Experience using SQL, Power BI, and/or Excel functions to analyze data.
- Experience in validating data for accuracy and completeness, utilizing Excel for cross-checking and troubleshooting to ensure data integrity.
- Knowledge of Excel formulas and functions, such as VLOOKUP, INDEX-MATCH, PivotTables, and other analytical tools to manipulate and analyze data effectively.
- Proficiency in data visualization techniques, including the use of Excel charts and graphs to present complex data in an understandable and visually appealing manner.
Responsibilities
- Conducting corporate and bank market analysis involving BOLI, COLI, and estate life insurance products, all while ensuring the validation of their market databases.
- Completing analysis, documenting requests, and other facets of current programs, and packaging it up for key stakeholders.
- Identifying opportunities for automation within data capturing, analysis, and reporting using visualization tools.
Other
- Incoming senior (Expected to graduate in May 2027)
- Pursuing a bachelor’s degree in Data Science, Mathematics, Finance, Business or related field from an accredited college or university
- Cumulative grade point average of 3.0 or higher
- Previous work or classroom experience in one or more of the following: Data Visualization, Probability or Statistics, Finance
- Employer immigration sponsorship is not available for this role.
