A consultancy firm is seeking a Mid-Senior Project Manager to manage workforce analytics and financial oversight. Responsibilities include headcount planning, cost tracking, and developing dashboards. Ideal candidates have 3-5 years of related experience and strong skills in Excel, SQL, and tools like Tableau and Power BI. A project management certification is preferred. This is a Contract position located in the United States, offering competitive pay between $60 - $65/hr.
Qualifications
3–5 years of experience in workforce analytics, financial analysis, or project management.
Advanced proficiency in Excel, SQL, and data visualization tools.
Strong analytical and problem-solving skills with attention to detail.
Responsibilities
Monitor and maintain real-time headcount data across key programs.
Design and maintain comprehensive dashboards for headcount metrics.
Calculate and track fully loaded costs per employee across projects.
Skills
Workforce analytics
Financial analysis
Project management
Excel
SQL
Data visualization tools
Analytical skills
Problem-solving skills
Communication skills
Project management software
Statistical programming
Education
PMP or similar project management certification
Tools
Tableau
Power BI
Jira
Monday.com
Job description
Project Manager
Base pay range: $60.00/hr - $65.00/hr
Key Responsibilities
Headcount Planning & Tracking – Monitor and maintain real‑time headcount data across key programs.
Create and manage headcount forecasting models for project pipeline planning.
Coordinate with project managers to anticipate staffing needs and changes.
Coordinate with FP&A teams during forecast cycles.
Analytics & Reporting – Design and maintain comprehensive dashboards for headcount metrics and trends.
Generate weekly, monthly, and quarterly headcount reports for leadership.
Identify optimization opportunities and resource allocation inefficiencies.
Create predictive models for future headcount requirements.
Financial Management – Calculate and track fully loaded costs per employee across projects.
Monitor project budgets against actual headcount expenses.
Analyze cost variances and provide explanatory reporting.
Develop cost allocation methodologies for shared resources.
Support budget planning processes with historical cost data and projections.
Process Improvement – Establish and refine headcount tracking processes and procedures.
Implement automation tools to streamline data collection and reporting.
Collaborate with HR, Finance, and Operations to ensure data accuracy.
Maintain documentation for all tracking methodologies and procedures.
Requirements
3–5 years of experience in workforce analytics, financial analysis, or project management.
Advanced proficiency in Excel, SQL, and data visualization tools (Tableau, Power BI).
Strong analytical and problem‑solving skills with attention to detail.
Experience with financial modeling and budgeting processes.
Excellent communication skills for presenting complex data to stakeholders.
Experience with project management software (Jira, Monday.com, etc.).
Knowledge of HR information systems and payroll platforms.
Background in consulting or professional services environments.
Experience with Python, R, or other statistical programming languages.