Senior Project Analyst, Risk Adjustment & Forecasting

Datavant; Lansing (MI); À distance; USD 103 000 - 121 000; Plein temps

Résumé du poste

Datavant is seeking a Senior Project Analyst to build pacing trackers, forecast capacity, and partner with Finance to optimize headcount and downtime planning. You’ll design dashboards, monitor vendor performance, and help leadership understand project health with data-driven insights.

The role requires advanced Excel, BI tools experience, and the ability to work in a remote, collaborative environment. 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.

Responsabilités

• 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, 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 “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%).

Connaissances

Advanced Excel

BI tools

Forecasting

Data analysis

Formation

Bachelor’s Degree or 5 years equivalent experience

Outils

Sigma

Tableau

Power BI

Looker

Description du poste

Datavant is seeking a Senior Project Analyst to build pacing trackers, forecast capacity, and partner with Finance to optimize headcount and downtime planning. You’ll design dashboards, monitor vendor performance, and help leadership understand project health with data-driven insights.

The role requires advanced Excel, BI tools experience, and the ability to work in a remote, collaborative environment. Travel up to 10% may be required.