Data Analyst Lead

Northwestern Mutual Investment Services, LLC; Franklin (WI); Hybrid; USD 108,000 - 162,000; Full time

Job summary

Northwestern Mutual Investment Services, LLC seeks a senior data analyst to lead expert level quantitative and qualitative data analysis and reporting for the Claims Leadership team. You will access and analyze data from multiple sources to create forecasts and dashboards that tell a data-driven story and drive business decisions.

You will also design deliverables, mentor peers, and provide insights and recommendations to partners, developing KPI frameworks and cross-functional collaboration to

Qualifications

• Bachelor's degree in computer science, math, statistics, business or related field.
• 6+ years of professional experience.
• 5+ years building analytics models, visualizations and delivering insights.
• Ability to provide design direction.
• Ability to apply data visualization best practices to deliverables.
• 7+ years of relevant experience with proven data analysis and reporting.

Responsibilities

• Lead expert level quantitative and qualitative data analysis and reporting for Claims Leadership to drive business decisions.
• Access, gather and analyze data from multiple sources to produce forecasts and dashboards that tell a data-driven story.
• Develop high quality, value driven work and collaborate with teams for speed, agility and innovation.
• Deliver insights and recommendations to stakeholders via written, verbal, and presentations.
• Produce actionable reports showing KPIs, root cause analysis and recommended solutions.
• Understand business processes in Claims and capture refined process documents.
• Share best practices and mentor peers in core methodologies and processes.
• Design and develop deliverables based on findings and business needs on complex analytical topics.
• Provide consultation to leaders and participate in cross-functional teams.

Skills

Analytical Thinking

Data Analytics

SQL

Data Literacy

Data Visualization

Storytelling

Tableau or Power BI

Statistical Programming

Education

Bachelor's degree in CS/Math/Statistics/Business

Tools

SAS

SQL

MS Excel

SPSS

Tableau

Power BI

Job description

What You’ll Do:

• Leads expert level quantitative and qualitative data analysis and reporting of patterns, insights, and trends to Claims Leadership team in order to drive business decisions and address business questions.

• Access, gather, and analyze data from multiple internal and external sources and partners with Client Advocacy Reporting Solutions & DSA to create and produces forecasts, reports, dashboards, etc. to tell a story through data.

• Creates and is accountable for high quality, value driven work that drives business outcomes; places the user in the center of decision making; and collaborates with team for speed, agility and innovation in work

• Delivers results, insights and recommendations (written, verbal, presentations, etc) to Claims Leadership team and other business partners to support business decisions

• Produce actionable reports that show key performance indicators, identify areas of improvement into current operations, display root cause analysis of problems, and recommend solutions

• Seeks to understand business processes in the Claims department, user tasks, and as necessary, captures refined process documents

• Shares best practices on data analysis with peers through coaching and mentoring around core methodologies, patterns, standards and processes.

• Takes initiatives to design and develop deliverables based on interpretation of findings and business needs on a wide range of highly complex analytical topics

• Provides consultation to leaders and participates in cross-functional teams to address business issues

• Identifies & captures business requirements, and contributes to development of KPI frameworks

• Regularly applies new perspectives, creative problem solving, and inter-departmental connections to improve analytical capabilities

• Actively promote learning & curiosity.

• Contributes to forecasts, recommendations and strategic/tactical plans based on business data and market knowledge. Utilizes analytics and metrics to improve processes and provide data-driven forecasts that impact the business (costs, risks, etc).

• Leads value driven work that drives business outcomes; places the user in the center of decision making; and collaborates with team for speed, agility and innovation in work.

What You’ll Bring to the Role:

• Bachelors degree in computer science, math, statistics, business or related field.

• At least 6 years of professional experience

• At least 5 years of experience building analytics models, visualizations and delivering insights

• Ability to provide design direction

• Ability to apply data visualization best practices to work deliverables.

• 7+ years of relevant experience with a proven track record in research and data analysis, application of statistical research techniques, report or application development that support business decisions/outcomes.

• Expertise in development and analytical tools such as SAS, SQL, MS Excel, SPSS or other tool

• Visualization tooling like PowerBI or Tableau

Skills You Have:

Analytical Thinking (NM): Organizes and compares different aspects of a situation to identify complex underlying issues through quantitative data and analysis. Uses business acumen, problem solving, and multiple perspectives to think critically and improve processes.

Cross Functional Partnering & Planning (NM): Facilitates collaboration, communication, coordination, and planning across individuals and teams with different areas of expertise to achieve shared goals.

Data Analytics (NM): Creates business knowledge through data analysis and applies a variety of analytical techniques to support business questions, decisions, and outcomes.

SQL (NM): Uses clear, logical SQL code for small- and large-scale projects to access, organize, and manage data within a database-management system.

Data Interpretation (NM): Reviews and interprets data findings to identify patterns, develop meaningful insights, and support informed business decisions.

Data Literacy (NM): Selects and uses appropriate data for a specific purpose, thinks critically about analytical findings, applies suitable tools and methods, and recognizes when data may be misrepresented or used incorrectly.

Storytelling through Data (NM): Communicates insights and opportunities from data through clear narratives, visualizations, and analysis.

#LI-Hybrid

Compensation Range:

Pay Range - Start:

$108,160.00

Pay Range - End:

$162,240.00

Geographic Specific Pay Structure:

Structure 110:

$118,960.00 USD - $178,440.00 USD

Structure 115:

$124,400.00 USD - $186,600.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.

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.

Skills

Data Literacy (NM), Data Solutions (NM), Business Acumen (NM), Statistical Programming (Python/R) (NM), Data Analytics (NM), SQL (NM), Data Automation (NM) - Intermediate (Inactive), Business Application Solutions (NM), Collaborative Partnership & Planning (NM), Data Interpretation, Data Integration & ETL (NM), Tableau or Power BI (NM), Industry Expertise (NM) - Intermediate (Inactive), Coaching & Mentoring (NM), Engineering Expertise & Practices, Analytical Thinking (NM), Data Visualization & Storytelling (NM) - Advanced (Inactive), Collaborative Negotiation (NM), Strategic & Systems Thinking (NM), Statistical Analysis (NM), Root Cause Analysis (NM), Adaptive Communication (NM), Consulting (NM)