Investment Data & Analytics Intern, Summer 2027

We need to output HTML fragment with sections for headings: About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule. Only include sections that have real specific content. No job title heading. No metadata like Job ID. Remove boilerplate, EEO, etc. Must preserve all substantive info. Let's parse the posting. Content: - Internship candidates can expect a fulltime onsite internship program, running from June 2027 through August 2027. This internship opportunity is offered in Milwaukee, WI. Candidates must be local to Milwaukee during the duration of the summer. Carefully selected from universities across the country, our interns bring distinctive ideas and perspectives to our organization. Our employees are passionate about building our emerging talent and future leaders. After application and initial screening conversation, interns are aligned interview and be hired to a specific team at NM based on their abilities and interests, providing exposure to real-world business perspectives through hands-on learning and substantial work. In addition to their day-to-day tasks, interns participate in professional development workshops, senior leadership Q&A's, volunteer initiatives, networking/social events, and more! - The Investment Data & Analytics Team ... description. - Basic Functions (list): - Assist in the creation and redesign of whole portfolio view, cross-asset investment reporting solutions - Work with end users to create highly flexible and functional dashboards - Perform ad hoc analysis and provide accurate and trusted data on the cross-asset investment portfolio - Participate in developing and implementing automated solutions to current manual processes. - Analyze data concepts, relationships, and structures to contribute to migration and validation of data in multiple environments - Qualifications: - Business major with an emphasis in finance and/or accounting. - Investment program enrollment preferred. - Proven technical aptitude working with Excel spreadsheets and data models. - Familiarity with Power BI is desirable (not a strict requirement). - Familiarity with SQL and data management is desirable (not a strict requirement). - Strong analytical, problem solving and decision-making skills, competencies in finance and mathematics. - High degree of personal initiative, demonstrated ability to work independently, excellent follow-through ability and sense of personal accountability. - Strong written and oral communication skills, ability to deal effectively and professionally with people at all levels. - Employer immigration sponsorship is not available for this role - Who We Are (company description) - maybe not needed as a section? Could be part of About the role? But we have headings: About the role, Responsibilities, Requirements, Qualifications, Skills, Benefits, Pay, Schedule. We need to map content. About the role: could include overview of internship: fulltime onsite, dates, location, selection, etc. Also maybe description of team and purpose. Responsibilities: the Basic Functions list. Requirements: maybe the eligibility: must be local to Milwaukee, must be undergraduate student? Actually "highly detailed, analytical and energetic undergraduate student". Could be part of Qualifications. But we have separate Requirements and Qualifications. Usually Requirements are like education, enrollment, location, etc. Qualifications are skills. But we can decide. Skills: maybe technical skills: Excel, Power BI, SQL, analytical, communication. Benefits: The posting mentions professional development workshops, senior leadership Q&A, volunteer initiatives, networking/social events, etc. Also maybe "Flexible work schedules, Concierge service, Comprehensive benefits, Employee resource groups" appears at end under "FIND YOUR FUTURE". Those are benefits. Also compensation range. Pay: they gave Pay Range - Start: $16.50 Pay Range - End $30.00. Also mention internship salaries determined based on academic tenure and major. So we have Pay section. Schedule: they gave fulltime onsite internship program, running from June 2027 through August 2027. Also mention must be local to Milwaukee during duration of summer. So schedule: fulltime, onsite, June-August 2027. We must not create sections with filler like "commensurate with experience". We have actual content. We must not repeat job title as heading. We must not include Job ID/requisition numbers. We must remove boilerplate: EEO, equal opportunity, scam warning, etc. Also remove navigation, cookie, legal. Also remove duplicated lines. We must preserve all substantive information. Let's extract substantive info: - Overview: Internship candidates can expect a fulltime onsite internship program, running from June 2027 through August 2027. This internship opportunity is offered in Milwaukee, WI. Candidates must be local to Milwaukee during the duration of the summer. Carefully selected from universities across the country, our interns bring distinctive ideas and perspectives to our organization. Our employees are passionate about building our emerging talent and future leaders. After application and initial screening conversation, interns are aligned interview and be hired to a specific team at NM based on their abilities and interests, providing exposure to real-world business perspectives through hands-on learning and substantial work. In addition to their day-to-day tasks, interns participate in professional development workshops, senior leadership Q&A's, volunteer initiatives, networking/social events, and more! - Team description: The Investment Data & Analytics team plays a fundamental role in ensuring that Northwestern Mutual stays financially sound, allowing the company to fulfill its promises to our policyowners when they need us the most. The team achieves this by providing accurate, trusted data and analytic research to the Northwestern Mutual Managed Investment Business partners. The team provides decision support through understandable and maintainable reporting solutions. We have an exciting opportunity for a highly detailed, analytical and energetic undergraduate student to have an impact on the cross-asset investment reporting environment. There will be many opportunities to learn more about developing reporting solutions that tell a story management can rely on and use in the investment and risk management decision making process. - Basic Functions (list) as above. - Qualifications list as above. - Who We Are: Northwestern Mutual has been helping families and businesses achieve financial security for over 160 years through a distinctive planning approach that integrates risk management with wealth accumulation, preservation, and distribution. With more than $290 billion in assets, $30 billion in revenues and more than $1.9 trillion worth of life insurance protection in force, Northwestern Mutual delivers financial security to more than 4.6 million clients. People are the power behind Northwestern Mutual, and diversity makes us better. We are committed to reflecting and serving the marketplace. We do so by attracting and improving the engagement of those who bring their outstanding perspectives, ideas, and beliefs. At Northwestern Mutual, people matter. And you’ll be working for a company that’s consistently voted among the “most admired” in the nation. We invite you to explore your career interests with us. - Compensation Range: Pay Range - Start: $16.50 Pay Range - End $30.00. We believe in fairness and transparency. It’s why we share the salary range for most of our roles. Internship salaries are determined based on academic tenure and major. The standard pay structure is listed. Build a strong career foundation with a best-in-class company that puts our clients' interests at the center of all we do. Get started now! - Benefits/Perks: Flexible work schedules, Concierge service, Comprehensive benefits, Employee resource groups. Also earlier: professional development workshops, senior leadership Q&A's, volunteer initiatives, networking/social events, and more! We need to decide sections. Potential sections:

About the role

: include overview and team description maybe.

Responsibilities

: Basic Functions list.

Requirements

: maybe eligibility: must be local to Milwaukee during summer, must be undergraduate student, must be enrolled in university, maybe investment program enrollment preferred? Actually that is qualification. Could put location and enrollment as Requirements.

Qualifications

: Business major with emphasis in finance/accounting, investment program enrollment preferred, technical aptitude Excel, familiarity Power BI desirable, SQL desirable, strong analytical etc.

Skills

: maybe combine technical and soft skills: Excel, Power BI, SQL, analytical, problem solving, communication, initiative, etc. But we already have qualifications covering many. Might be redundant. Could instead put Skills separate: technical skills (Excel, Power BI, SQL) and soft skills (communication, initiative). But we risk duplication. The instruction: Prefer a few substantive sections over many thin ones. So maybe combine Qualifications and Skills into one section? But we have headings list; we can omit sections if not substantive. We could have About the role, Responsibilities, Qualifications, Pay, Schedule, Benefits. That seems enough. Let's see if we need Requirements separate: we have location and fulltime onsite, maybe that fits in About the role or Schedule. Could put location in About the role. Requirements could be "must be local to Milwaukee during the duration of the summer" and "must be an undergraduate student". That's substantive. Could be a short Requirements section. But we also have "Carefully selected from universities across the country" - not a requirement. Thus we can have: - About the role: overview of internship, team description, maybe mention fulltime onsite, location, duration, selection, etc. - Responsibilities: Basic Functions list. - Requirements: must be local to Milwaukee during summer; must be an undergraduate student; maybe investment program enrollment preferred? Actually that is qualification. We'll keep requirement: must be local to Milwaukee during summer; must be currently enrolled as an undergraduate student. - Qualifications: list of qualifications (business major, Excel, Power BI, SQL, analytical, communication, initiative, etc). Also note employer immigration sponsorship not available. - Benefits: professional development workshops, senior leadership Q&A, volunteer initiatives, networking/social events, flexible work schedules, concierge service, comprehensive benefits, employee resource groups. - Pay: Pay range $16.50 - $30.00, note based on academic tenure and major. - Schedule: fulltime onsite, June 2027 through August 2027. We must not create sections with filler like "commensurate with experience". All sections have real content. Now we need to output HTML fragment only, no /, no markdown fences. We'll use

for each section heading. Use

• for lists. Use

  for prose. We must not repeat job title as heading. We must not include Job ID/requisition numbers. We must remove boilerplate: EEO, equal opportunity, scam warning, etc. Also remove navigation, cookie, legal. Also remove duplicated lines. Check for any duplicated lines: The posting includes "We believe in fairness and transparency. It’s why we share the salary range for most of our roles." That's okay. Now craft content. About the role paragraph(s): We can combine overview and team description into a few paragraphs. Paragraph 1: Internship candidates can expect a fulltime onsite internship program, running from June 2027 through August 2027. This internship opportunity is offered in Milwaukee, WI. Candidates must be local to Milwaukee during the duration of the summer. Carefully selected from universities across the country, our interns bring distinctive ideas and perspectives to our organization. Our employees are passionate about building our emerging talent and future leaders. After application and initial screening conversation, interns are aligned interview and be hired to a specific team at NM based on their abilities and interests, providing exposure to real-world business perspectives through hands-on learning and substantial work. In addition to their day-to-day tasks, interns participate in professional development workshops, senior leadership Q&A's, volunteer initiatives, networking/social events, and more! Paragraph 2: The Investment Data & Analytics team plays a fundamental role in ensuring that Northwestern Mutual stays financially sound, allowing the company to fulfill its promises to our policyowners when they need us the most. The team achieves this by providing accurate, trusted data and analytic research to the Northwestern Mutual Managed Investment Business partners. The team provides decision support through understandable and maintainable reporting solutions. We have an exciting opportunity for a highly detailed, analytical and energetic undergraduate student to have an impact on the cross-asset investment reporting environment. There will be many