Job Type: Contract
Contract Length: 6 months
Target Start Date: ASAP
Work Location/Structure: Mountain View, CA (Hybrid)
About the Opportunity:
Our client, a leader in driving technology, is looking for a skilled Workforce Planning Analyst to join their Operations team for a 6-month engagement. This is an exciting startup environment with a vibrant culture that combines impactful work, competitive compensation, and excellent benefits. This project involves revolutionizing the way people engage with vehicles, addressing both business needs and the world's environmental challenges. This is a high-impact role that requires a self-motivated professional who can hit the ground running and deliver results quickly.
Key Responsibilities & Deliverables
This role is focused on the successful completion of specific tasks and deliverables. Your responsibilities will include:
- Build an Excel single source of truth for workforce / man-month capacity and effort by project/team.
- Consolidate Worksheets; normalize IDs/names, maintain mapping tables (project, team, cost center), and document change logs.
- Track effort and capacity by project/org on a monthly cadence and variances for management reviews.
- Build reusable templates (Power Query queries, input forms) to minimize manual work and improve repeatability.
- Define data quality rules (cut-off, naming, versioning) and reconciliation checks; escalate exceptions with clear owners and due dates.
- Partner with PMs, Engineers, Finance, and HR stakeholders across the US and Japan to drive adoption, coordinating across time zones and flexing hours for occasional late meetings (JST, with advance notice).
We are looking for someone with a proven track record of successful contract engagements. The ideal candidate will have:
- Advanced Excel skills: Pivot, XLOOKUP/SUMIFS, dynamic arrays (FILTER, UNIQUE), and Power Query (joins, fuzzy match, data types).
- Strong data reconciliation & hygiene: design checks, surface exceptions, maintain audit-ready trails.
- Working knowledge of project planning: Work Breakdown Structure, cross-team coordination, and basic scheduling.
- Allocation/financial fundamentals: cost-center mapping/tagging, variance highlights, and run-rate thinking.
- Comfort consuming Jira data (read access or CSV exports); collaborate via Slack/Teams.
- Familiarity with Jira/JQL; exposure to time/effort tools (e.g., Tempo).
- Basic Power BI/Tableau for lightweight dashboards; simple automation (Python or Power Automate).
- Experience improving Business Operations processes (templates, SOPs, review cadence) in partnership with PMO/Finance.
