Resource Planning Consultant - Remote

At Northwestern Mutual, we are strong, innovative and growing. We invest in our people. We care and make a positive difference.
Summary:
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.

Qualifications:

• 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-Remote
Compensation Range:
Pay Range - Start:
$69,720.00
Pay Range - End:
$129,480.00
Northwestern Mutual pays on a geographic-specific salary structure and placement in the salary range for this position will be determined by a number of factors including the skills, education, training, credentials and experience of the candidate; the scope, complexity as well as the cost of labor in the market; and other conditions of employment. At Northwestern Mutual, it is not typical for an individual to be hired at or near the top of the range for their role and compensation decisions are dependent on the facts and circumstances of each case. Please note that the salary range listed in the posting is the standard pay structure. Positions in certain locations (such as California) may provide an increase on the standard pay structure based on the location. Please c lick here for additional information relating to location-based pay structures.
Grow your career with a best-in-class company that puts our client's interests at the center of all we do. Get started now!
We are an equal opportunity/affirmative action employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, gender identity or expression, sexual orientation, national origin, disability, age or status as a protected veteran, or any other characteristic protected by law.
If you work or would be working in California, Colorado, New York City, Washington or outside of a Corporate location, please click here for information pertaining to compensation and benefits.
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