Senior Analyst, Clinical Trials and Site Contracts
Edwards Lifesciences
Workforce Planning Analyst
Drivemode
part-time
Posted on:
Location Type: Hybrid
Location: Mountain View • California • 🇺🇸 United States
Visit company websiteSalary
💰 $50 - $60 per hour
Job Level
Mid-LevelSenior
About the role
- 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).
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.
Benefits
- competitive compensation
- excellent benefits
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard skills
Advanced ExcelPivotXLOOKUPSUMIFSdynamic arraysPower Querydata reconciliationdata hygienecost-center mappingvariance analysis
Soft skills
cross-team coordinationcommunicationflexibilitystakeholder engagementproblem-solving
