Remote Risk Adjustment Forecasting & Capacity Lead

Datavant; Denver (CO); Remote; USD 103,000 - 121,000; Full time

Job summary

Datavant is seeking a Senior Project Analyst to build pacing trackers, forecast capacity, and collaborate with Finance, Operations, and project managers. This role develops capacity planning models, headcount plans, and dashboards to provide leadership with real-time project health and resource visibility.

You will optimize forecasting accuracy, analyze vendor throughput, and support what-if staffing scenarios while working remotely with a cross-functional team across multiple projects.

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.
• Strong analytical and problem-solving skills with high attention to detail.
• Ability to manage multiple projects and stakeholders simultaneously.
• Excellent written and oral communication skills, with the ability to present findings to leadership.
• Ability to work effectively in a remote, team environment.
• Flexibility in work schedule to meet departmental needs.
• Ability to analyze data to determine root causes of pacing, capacity, or forecasting variances.
• Must be able to follow instructions, meet deadlines, and work independently.
• Working knowledge of the business use of computer hardware and software to ensure effectiveness, quality, and security of data.
• Experience with risk adjustment methodologies preferred.
• Healthcare industry experience preferred.
• Formal project planning or project management experience/certification (PMP, CAPM, or similar) preferred.
• SQL or other data querying experience preferred.

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 closely with Finance to build capacity planning models, including headcount requirements and downtime/idle-time 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 “what-if” modeling for 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 and staffing models.
• Maintain data integrity across pacing, forecasting, and capacity planning tools and reports.
• Assist in the development of 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 related travel as needed (up to 10%).

Skills

Advanced Excel

Forecasting

BI tools

Headcount modelling

Analytical thinking

Communication

Remote work

Education

Bachelor’s Degree

5+ years experience in analytics

Tools

Sigma

Tableau

Power BI

Looker

Job description

Datavant is seeking a Senior Project Analyst to build pacing trackers, forecast capacity, and collaborate with Finance, Operations, and project managers. This role develops capacity planning models, headcount plans, and dashboards to provide leadership with real-time project health and resource visibility.

You will optimize forecasting accuracy, analyze vendor throughput, and support what-if staffing scenarios while working remotely with a cross-functional team across multiple projects.