Resource Planning Consultant

Reposted 2 Days Ago
Be an Early Applicant
Hiring Remotely in Texas
Remote or Hybrid
70K-129K Annually
Senior level
Fintech • Insurance • Financial Services
Start-Up Vibes with The Stability of a Fortune 100 Company.
The Role
The Resource Planning Consultant will analyze operational data using statistical methods, create forecasts, drive budget planning, and recommend process improvements, while consulting with leadership on workforce needs.
Summary Generated by Built In
What's the role?
Northwestern Mutual is seeking a Resource Planning Consultant who will be responsible for conducting data analysis for operational resource and capacity planning using complex statistical analysis quantitative methods to identify trends, anomalies, and outliers.
Primary Duties & Responsibilities:
  • Conduct analysis of data using complex statistical analysis quantitative methods including linear regression, logistic regression, and methods for clustered and repeated measures data to identify trends, anomalies, and outliers.
  • Create accurate long-term forecasts for volume, average handle time and shrinkage for all supported workgroups using advanced techniques to develop comprehensive headcount plans
  • Drive budget planning cycles through effective support of operational understanding and planning to maximize the budgeting processes.
  • Develop and maintain staff models looking out 3 years that align with long term business plans, budget requirements and learning needs.
  • Integrate and interpret data from many different sources including system applications, databases, Excel extracts and databases and format to perform in depth analysis.
  • Strong understanding of business area to create a comprehensive overview and analysis of critical business data to consult leaders with solutions and options to help resolve business problems.
  • Recommend KPI's and metrics for measuring and reporting business results and workforce gaps to business leaders. Create and maintain workforce planning scorecard and dashboard.
  • Identify and recommend process improvement opportunities within the Resource Planning team and share observations on processes within the business areas supported.
  • Leverage data mining, analytics, and reporting tools.
  • Participates in cross functional projects and develop project deliverables for various enterprise scopes.

Bring your best! What this role needs:
  • Bachelor's degree in business, statistics, mathematics or a related field or an equivalent combination of professional related work experience.
  • 5+ years of workforce management experience
  • 3+ years of quantitative analysis or research experience
  • Strong understanding and experience forecasting using trend extrapolation, driver based, simple regression, econometric models, and multivariate methods.
  • Experience as primary capacity consultant for Vice President level Senior Leadership providing optimal headcount plans and hiring strategy to accomplish budget objectives
  • Experience working with SPSS or other statistical software package
  • Expert Excel skills and experience in macros, data tables, integrating Excel with other tools, evaluating and trouble-shooting complex models and optimizing Excel
  • Expertise with using Power Query, the Excel internal Data Model, Cube formulas, DAX, and Power Pivot

Preferred Qualifications:
  • Analysis experience in Customer Service or Operations preferred
  • Previous Capacity Planning experience strongly preferred
  • Experience with WFM Solutions such as Aspect, NICE IEX, and/or Verint
  • Experience with VBA programming within Excel and leveraging the Excel object model to automate workbooks

#LI-Hybrid
Compensation Range:
Pay Range - Start:
$69,720.00
Pay Range - End:
$129,480.00
Geographic Specific Pay Structure:
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 who welcomes and encourages diversity in the workforce. 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.
FIND YOUR FUTURE
We're excited about the potential people bring to Northwestern Mutual. You can grow your career here while enjoying first-class perks, benefits, and our commitment to a culture of belonging.
  • Flexible work schedules
  • Concierge service
  • Comprehensive benefits
  • Employee resource groups

Top Skills

Dax
Excel
Power Pivot
Power Query
Spss
VBA

What the Team is Saying

Chris
Chester
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: Milwaukee, WI
8,400 Employees
Year Founded: 1857

What We Do

You’ll Like It Here

At Northwestern Mutual, we believe that our lives and our work matter. And that doing what’s right is good for everyone. We follow through by designing tech that improves the community and cultivating creative ways to make finance accessible anywhere. These guiding principles have allowed our company to grow for more than 160 years.

Here, you’ll be with a team who emphasizes integrity and prioritizes security to design experiences that better everyone. You’ll work in cross functional teams to create optimal solutions that are rooted in innovative strategy and thoughtful execution. And you’re provided development tools and opportunities to become a leader all with the support of a collaborative team. You’ll be surrounded in a culture that values innovation and works to always evolve to stay ahead of trends and client needs.

We are intentional in seeking out team members who will challenge us. Our employees choose us for the career opportunities, commitment to philanthropy and desire to have a meaningful impact in the lives of our clients. You have career passions and goals. We have ambition and opportunity for you to grow your future in tech. Discover today: https://careers.northwesternmutual.com/

Why Work With Us

We invest in our people. We know careers are about choices, so we provide intentional opportunity. Here you can build creative ways to make finance accessible anywhere and revolutionize traditional processes. As a mutual company, our focus is our people — whether professional development or investments in the community. 

Gallery

Gallery
Gallery
Gallery
Gallery
Gallery
Gallery
Gallery
Gallery
Gallery
Gallery

Northwestern Mutual Teams

Team
Software Engineering
Team
Digital Product
Team
Data & Analytics
Team
Cybersecurity
About our Teams

Northwestern Mutual Offices

Hybrid Workspace

Employees engage in a combination of remote and on-site work.

We offer a flexible, hybrid approach for our employees . Teams are in the office a few days a week and work from home the others.

Typical time on-site: Flexible
Company Office Image
HQMilwaukee, WI
Company Office Image
New York, NY
Learn more

Similar Jobs

Northwestern Mutual Logo Northwestern Mutual

Consultant

Fintech • Insurance • Financial Services
Remote or Hybrid
Texas, USA
70K-129K Annually

Northwestern Mutual Logo Northwestern Mutual

Consultant

Fintech • Insurance • Financial Services
Remote or Hybrid
Texas, USA
70K-129K Annually

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account