Senior Risk & Capacity Planning Project Analyst

Datavant; Cheyenne (WY); Remote; USD 103,000 - 121,000; Full time

Job summary

Datavant is hiring a Senior Project Analyst to build pacing trackers, forecast volume and staffing across multiple projects, and collaborate with Finance to model capacity and headcount needs. You will design real-time dashboards, identify risks, and drive data-driven decisions in a remote team environment.

Ideal candidates have strong Excel skills, experience with BI tools, and a background in project analytics or FP&A. Travel up to 10% may be required.

Qualifications

• Bachelor’s Degree or a minimum of five years of equivalent experience in project analytics, business analytics, or a related analytical role.
• Advanced Excel skills, including complex formulas, pivot tables, and financial/operational modeling.
• Experience with BI/visualization tools such as Sigma, Tableau, Power BI, or Looker.
• Demonstrated experience building forecasting and/or capacity planning models.
• Experience partnering with Finance or FP&A teams on headcount and capacity modeling.

Responsibilities

• Build and maintain pacing trackers to monitor project progress, milestones, and timelines by vendor.
• Develop multi-platform forecasting models to project volume, timelines, and resourcing needs across concurrent projects.
• Partner with Finance to build capacity planning models, including headcount requirements and downtime planning.
• Design and maintain dashboards and reports (Excel, Sigma, or similar BI tools) that give leadership real-time visibility into project and vendor performance.
• Identify trends, bottlenecks, and risks in vendor performance and project pacing, and recommend corrective action.
• Support scenario planning and probability-based staffing and capacity decisions.
• Collaborate cross-functionally with project managers, vendor management, and finance stakeholders to align on assumptions and outputs.
• Continuously improve tracking methodologies and forecasting accuracy over time.
• Analyze vendor throughput and capacity against forecasted volume, flagging variances early.
• Maintain documentation of forecasting methodologies, data sources, and assumptions for auditability.
• Present pacing, forecasting, and capacity findings to leadership and cross-functional stakeholders.
• Support headcount and staffing plan reviews in partnership with Finance and Operations leadership.
• Monitor downtime and utilization trends, incorporating them into forecasting models.
• Maintain data integrity across pacing, forecasting, and capacity planning tools and reports.
• Assist in developing standardized reporting templates across projects and vendors.
• Support ad hoc analysis requests from Finance, Operations, and executive leadership.
• Track project risk indicators and track concerns proactively.
• Contribute to process improvement initiatives related to project tracking and forecasting.
• Business travel up to 10%.

Skills

Advanced Excel

Forecasting

Data analysis

Strong communication

Multitasking

Education

Bachelor’s Degree or 5 years equivalent experience in analytics

Tools

Sigma

Tableau

Power BI

Looker

Excel

Job description

Datavant is hiring a Senior Project Analyst to build pacing trackers, forecast volume and staffing across multiple projects, and collaborate with Finance to model capacity and headcount needs. You will design real-time dashboards, identify risks, and drive data-driven decisions in a remote team environment.

Ideal candidates have strong Excel skills, experience with BI tools, and a background in project analytics or FP&A. Travel up to 10% may be required.