Workforce Planning Analyst at Drivemode

Mountain View, California, United States

Apply Now

Not SpecifiedCompensation

Junior (1 to 2 years)Experience Level

Part TimeJob Type

UnknownVisa

Automotive, Electric Vehicles, TechnologyIndustries

Requirements

Advanced Excel: 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

Responsibilities

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)

Skills

Excel

Pivot Tables

XLOOKUP

SUMIFS

Dynamic Arrays

FILTER

UNIQUE

Power Query

Workforce Planning

Capacity Planning

Data Normalization

Stakeholder Management

Drivemode

Enhances road safety through connected driving technology

About Drivemode

Drivemode enhances road safety and the driving experience through technology aimed at drivers who want to stay connected while on the road. The company analyzes driving trends using data science to identify improvements in safety and connectivity. Its software solutions can be integrated into any vehicle, allowing drivers to access essential apps without compromising safety. Drivemode differentiates itself by focusing on data analysis and providing insights through a dedicated team of data scientists. The goal is to make driving smarter and safer, serving individual drivers and automotive manufacturers while generating revenue through software sales and licensing agreements.

Tokyo, JapanHeadquarters

2014Year Founded

$8.9MTotal Funding

SERIES_ACompany Stage

Data & Analytics, Automotive & TransportationIndustries

11-50Employees

Benefits

Flexible Work Hours

Risks

Competition from automakers' connected platforms may reduce Drivemode's market share.

Major tech companies' advancements could overshadow Drivemode's offerings.

Privacy concerns and regulatory scrutiny may impact Drivemode's data-driven model.

Differentiation

Drivemode offers voice-to-text messaging, enhancing hands-free communication in vehicles.

The company integrates software solutions into any vehicle, ensuring broad compatibility.

Drivemode's data-driven approach improves road safety and driving experiences.

Upsides

Rising demand for voice-activated tech aligns with Drivemode's messaging focus.

EV growth creates opportunities for Drivemode's user interface solutions.

AI integration in automotive tech benefits Drivemode's adaptive driving experiences.

Land your dream remote job 3x faster with AI

Try Jobo Free