Jobs › Northwestern Mutual

NM Capital - Investment Data Analyst

Northwestern Mutual · Milwaukee, WI · Full time

Posted Sep 24, 2026 · We last checked this listing on Oct 6, 2026

Apply at Northwestern Mutual

Likely interview questions for this role

Written from this job description, not a generic list. Each one notes what the interviewer is really checking.

About your past

Tell me about a Power BI dashboard you built that people actually used. What made it stick?

What they are checking: Whether they design for real decisions and adoption rather than for looking impressive.

Tell me about a time an ad-hoc question from a senior person turned into a bigger analysis. How did you scope it?

What they are checking: Whether they can clarify what a busy executive really needs before spending days on the wrong thing.

Which investment metric do you think is most often misunderstood, and why?

What they are checking: Whether they think critically about metrics instead of just producing them.

What would you do

An investor relations request needs data by tomorrow and you find a mismatch between eFront and the source file. What do you do?

What they are checking: Whether they protect accuracy and communicate early instead of sending numbers they can't stand behind.

Users keep entering data in eFront inconsistently. How would you improve that?

What they are checking: Whether they see data quality as a people and process problem, not only a technical one.

How would you tell a portfolio manager that their strategy underperformed in a way that's useful rather than defensive-making?

What they are checking: Whether they can deliver hard numbers with enough context that people act on them.

About the work

How would you calculate the return of a private equity investment, and why is IRR different from a time-weighted return?

What they are checking: Whether they understand that cash flow timing drives private market performance measurement.

Walk me through how you'd build a performance attribution view at the asset, strategy and portfolio level.

What they are checking: Whether they can explain what drove results, not just report what the results were.

Choosing a benchmark for a private credit portfolio is tricky. How would you approach it?

What they are checking: Whether they understand that a poor benchmark makes every performance comparison misleading.

How do you make sure data you transform stays auditable?

What they are checking: Whether they keep clear lineage and documentation so figures can be traced back and defended.

What SQL or Python work have you done to combine portfolio and benchmark data?

What they are checking: Whether they have the hands-on skills to manage and transform investment data themselves.

Practice this interview out loud.

Offer builds a real interview for this exact role at Northwestern Mutual from your resume and this job description, asks the questions one at a time, and tells you what landed. The first one is free.

Practice this out loud

The full job description

As published by Northwestern Mutual.

About the Job: • This role will focus on the data associated with NMC’s investment transaction lifecycle; including deal sourcing, due diligence, valuation, portfolio monitoring, portfolio performance, and reporting to clients. • Manage, transform, and integrate portfolio and benchmark data to support advanced quantitative analysis, ensuring information is accurate, auditable, and analytically robust. • Develop and maintain investment performance measurement frameworks, including returns, benchmarks, attribution, and performance drivers at the asset, strategy, and portfolio level. • Design and deliver custom analyses and models to answer ad‑hoc investment, portfolio management, and investor questions. • Identify, define, and refine key investment metrics and analytical views that inform investment decisions and support positive business outcomes. • Build and maintain Power BI dashboards that combine quantitative outputs and visual storytelling to support portfolio management and senior leadership. • Partner with investment, finance, and investor relations teams to support due diligence, investor requests, marketing materials, and quarterly performance reporting. • Engage users with analytically rigorous tools and datasets, creating a virtuous cycle where insights drive adoption and improved data quality. • Configure eFront and assist users with troubleshooting and best practices. • Contribute to the design and maintenance of AI‑ready datasets by optimizing and enhancing datasets for consumption by investment professionals. • Clearly document analytical methodologies, assumptions, data standards, and repeatable processes. What You'll Bring to the Role: • Bachelor’s and/or master’s degree in Finance, Economics, Statistics, Data Science, Computer Science, Financial Engineering, or a related quantitative field, or an equivalent combination of education and experience. • Two or more years of experience in a quantitative, analytics, investment, or performance measurement‑focused role. • Experience with investment performance measurement, return calculations, or portfolio analytics. • Strong data‑driven decision‑making mindset with comfort working in ambiguous, unstructured problem spaces. • Process‑oriented approach with the ability to design scalable, repeatable analytical solutions. • Intellectual curiosity and willingness to challenge assumptions, methodologies, and existing analytical approaches. • High attention to detail and a strong instinct to reconcile, validate, and pressure‑test data and results. • Experience with Snowflake, Python, dbt, and PowerBI preferred. • Strong proficiency in Python for data analysis, including pandas, numpy, and analytical workflows. • Experience building custom investment analyses, performance calculations, and repeatable analytical pipelines. • Proficiency in Power BI, including data modeling and integrating quantitative outputs into dashboards. • Advanced proficiency in Excel, including modeling and validation of analytical results. • Proficiency in Snowflake and dbt to query and build datasets. • Ability to interpret, scrub, process, and clearly explain complex quantitative results to non‑technical stakeholders Skills You Will Have: • Adaptive Communication: Formulates strategies to be used to convey complex information about services, products, systems, or processes to targeted audiences; communicates and liaises between technical and non-technical audiences. • Attention to Detail: Focuses on specific details to spot and correct errors in advance of them being found and surpass quality expectations. Performs work with thorough proofreading for presentation, content, accuracy, and overall quality. • Financial Market Monitoring: Consistently tracks and analyzes financial market data and news, evaluates trends and events that may impact investment portfolios or financial decisions, and makes informed decisions based on this information. Stays up to date on economic indicators, market news, and global events, and understands how they relate to investment opportunities and risks. • Industry Knowledge: Demonstrates extensive knowledge of common practices, regulatory considerations, market trends and the competitive landscape within a particular industry / sector to better understand and address unique client requirements, challenges, and context. • Risk Evaluation: Assesses the significance of identified risks, makes judgments about the significance of the risk in relation to the organization's objectives and assesses whether the risk is acceptable or not. Considers factors such as the organization's risk appetite, risk tolerance, and risk management resources to help decision-makers determine which risks require further action and which can be accepted or tolerated. Compensation Range: Pay Range - Start: $75,600.00 Pay Range - End: $113,400.00 Geographic Specific Pay Structure: Structure 110: $83,200.00 USD - $124,800.00 USD Structure 115: $86,960.00 USD - $130,440.00 USD We believe in fairness and transparency. It’s why we share the salary range for most of our roles. However, final salaries are based on a number of factors, including the skills and experience of the candidate; the current market; location of the candidate; and other factors uncovered in the hiring process. The standard pay structure is listed but if you’re living in California, New York City or other eligible location, geographic specific pay structures, compensation and benefits could be applicable, click here to learn more. Grow your career with a best-in-class company that puts our clients' interests at the center of all we do. Get started now! Northwestern Mutual is an equal opportunity employer that welcomes talented individuals of all backgrounds. We are committed to creating and maintaining an environment in which each employee can contribute creative ideas, seek challenges, assume leadership and continue to focus on meeting and exceeding business and personal objectives.

Apply at Northwestern Mutual