Workforce Planning Data Scientist - Remote

CBRE; Detroit (MI); On-site; USD 100,000 - 150,000; Full time

Job summary

CBRE is seeking a Workforce Planning Data Scientist in Detroit to turn complex workforce data into insights that guide faster business decisions. You will analyze staffing, attrition, and hiring data to identify trends and risks, develop predictive models, and create leadership dashboards.

The role emphasizes forecasting, scenario modeling, data governance, and collaboration with data engineers to deliver actionable reports for executive leaders.

Qualifications

• Bachelor's degree preferred with 5+ years of relevant experience in talent acquisition analytics, workforce planning, or people analytics.
• Demonstrated experience analyzing complex, high volume datasets.
• Strong experience developing dashboards and executive level reporting.
• Experience performing trend analysis, forecasting, and scenario modeling.
• Demonstrated ability to reconcile data across multiple systems and identify data quality issues.
• Experience translating complex analytical findings into understandable business recommendations.

Responsibilities

• Analyze workforce, recruiting, staffing, attrition, requisition, offer, start, and productivity data to identify trends, risks, and opportunities.
• Evaluate staffing performance across sites, business units, roles, and time periods.
• Analyze historical attrition patterns to identify future hiring demand.
• Develop models and recommendations to determine when and where requisitions should be opened proactively.
• Identify trends across weekly, monthly, quarterly, and historical workforce performance.
• Analyze relationships between staffing levels, attrition, hiring activity, requisition volume, recruiter productivity, and hiring outcomes.
• Conduct ad hoc analyses in response to evolving workforce priorities.

Skills

Advanced SQL

Excel (Power Query)

Power BI

Python (Pandas)

Data modeling

Forecasting

Data visualization

Forecasting methodologies

Education

Bachelor's degree (or equivalent)

Tools

SQL Server

Excel

Python

APIs

ETL/ELT

Cloud data platforms

Job description

About The Role

The Workforce Planning Data Scientist will turn complex recruiting, staffing, workforce, and operational data into clear insights that enable better and faster business decisions.

What You’ll Do

Workforce Analytics & Decision Support

• Analyze workforce, recruiting, staffing, attrition, requisition, offer, start, and productivity data to identify trends, risks, and opportunities.
• Evaluate staffing performance across sites, business units, roles, and time periods.
• Analyze historical attrition patterns to identify where future hiring demand is likely to occur.
• Develop models and recommendations that help determine when and where requisitions should be opened proactively.
• Identify trends across weekly, monthly, quarterly, and historical workforce performance.
• Analyze relationships between staffing levels, attrition, hiring activity, requisition volume, recruiter productivity, and hiring outcomes.
• Conduct ad hoc analyses in response to evolving workforce and leadership priorities.

Forecasting & Predictive Analysis

• Build workforce forecasts incorporating staffing requirements, active headcount, attrition, projected starts, hiring velocity, and historical trends.
• Identify emerging staffing risks before they materially impact operations.
• Develop scenario analyses to evaluate different hiring and attrition assumptions.
• Identify leading indicators that can improve workforce planning and recruiting decisions.
• Assess whether workforce and recruiting performance is trending toward or away from established targets.

Dashboard Development & Visualization

• Design and maintain intuitive dashboards that translate complex datasets into clear, actionable information.
• Develop reporting for staffing health, recruiter productivity, requisition aging, time to offer, hiring outcomes, attrition, projected starts, and workforce demand.
• Create leadership level views that allow users to quickly understand performance, risks, trends, and required actions.
• Continuously improve dashboards based on business needs and user feedback.

Data Management & Engineering

• Work with multiple data sources and large datasets that may contain hundreds of thousands to millions of records.
• Clean, transform, combine, and structure data for analysis and reporting.
• Understand data pipelines, relationships, joins, data models, and source/system dependencies.
• Partner with Data Engineering and BI resources on more complex data architecture and pipeline requirements.
• Automate repeatable reporting and data preparation processes when practical.
• Troubleshoot data inconsistencies and reconcile conflicting numbers across systems.

Data Quality & Governance

• Validate and reconcile workforce metrics before they are used for business decisions.
• Identify data quality issues, missing information, duplicate records, inconsistent definitions, and source/system discrepancies.
• Establish clear metric definitions and calculation logic.
• Ensure leadership reporting is consistent, repeatable, and explainable.

What You’ll Need

• Bachelor's Degree preferred with 5 plus years of relevant experience in talent acquisition analytics, workforce planning, or people analytics. In lieu of a degree, a combination of experience and education will be considered.
• Demonstrated experience analyzing complex, high volume datasets.
• Strong experience developing dashboards and executive level reporting.
• Experience performing trend analysis, forecasting, and scenario modeling.
• Demonstrated ability to reconcile data across multiple systems and identify data quality issues.
• Experience translating complex analytical findings into understandable business recommendations.Workforce planning, recruiting analytics, HR analytics, operations, or high-volume staffing experience strongly preferred.
• Advanced SQL
• Advanced Excel, including Power Query, PivotTables, XLOOKUP/INDEXMATCH, complex formulas, and large dataset management
• Power BI dashboard development experience
• Data modeling and relational database concepts
• ETL/ELT concepts
• Python, particularly Pandas and NumPy
• Familiarity with APIs and automated data ingestion
• Experience with cloud data environments or data warehouses
• Familiarity with Power Automate or similar workflow automation tools
• Experience with ATS, HRIS, workforce management, or recruiting datasets
• Experience building workforce planning or capacity models
• Understanding of basic regression, correlation, seasonality, and forecasting methodologies

Equal Employment Opportunity: CBRE is an equal opportunity employer that values diversity. We have a long-standing commitment to providing equal employment opportunity to all qualified applicants regardless of race, color, religion, national origin, sex, sexual orientation, gender identity, pregnancy, age, citizenship, marital status, disability, veteran status, political belief, or any other basis protected by applicable law.

Candidate Accommodations: CBRE values the differences of all current and prospective employees and recognizes how every employee contributes to our company’s success. CBRE provides reasonable accommodations in job application procedures for individuals with disabilities. If you require assistance due to a disability in the application or recruitment process, please submit a request via email at [e-mail] or via telephone at [phone] (U.S.) and [phone] (Canada).