Workforce Analytics Model Standardization Consultant (Contractor)

Duration
This is a ~4 month contract opportunity
About Included Health
Included Health is a new kind of healthcare company, delivering integrated virtual care and navigation. We’re on a mission to raise the standard of healthcare for everyone. We break down barriers to provide high-quality care for every person in every community — no matter where they are in their health journey or what type of care they need, from acute to chronic, behavioral to physical. We offer our members care guidance, advocacy, and access to personalized virtual and in-person care for everyday and urgent care, primary care, behavioral health, and specialty care. It’s all included. Learn more at includedhealth.com .
Responsibilities
- Model Standardization & Cleanup: Bring high-burden Google Sheets models up to team standards for structure, readability, maintainability, and traceability. Audit interconnected spreadsheets, identify broken or fragile dependencies, clarify inputs and outputs, and reduce unnecessary complexity without changing sound forecasting methodology. Establish consistent conventions for tabs, formulas, input areas, assumptions, checks, file naming, permissions, and handoff materials. Review models for data integrity, formula consistency, broken links, stale inputs, hard-coded values, and other issues that could create production risk. Preserve business logic that is working while making the model understandable and operable by someone other than its original author.
- Documentation & Archiving: Reverse-engineer undocumented or lightly documented models and write clear, practical documentation explaining how they work. Document source data, refresh steps, dependencies, assumptions, business rules, key calculations, outputs, known limitations, and common failure modes. Organize Google Drive folders and model inventories so current working files, reference files, archived versions, and historical sources of truth are clearly distinguished. Identify and archive stale or redundant versions while preserving the historical files needed for auditability, trend analysis, and retrospective review. Create handoff materials that enable an analyst to run, troubleshoot, and maintain the work after the engagement ends.
- Cycle & Workflow Support: Support the recurring workforce planning and forecasting cycle, which runs roughly from the 20th through the 10th of each month. Handle routine manual ingestion, file preparation, formatting, reconciliation, and quality-check tasks so senior analysts can focus on interpretation and decision support. Work carefully within live production processes, escalating issues early and protecting deadlines for FP&A and Operations deliverables. Help clarify and improve Jira workflow structure where it supports intake, tracking, prioritization, review, and completion of analytics work. Create lightweight checklists and repeatable procedures for recurring tasks, with clear ownership and escalation paths.
- Governance Delivery: Develop standardized model outputs and reusable templates for FP&A and Operations pre-reads. Meet with stakeholders to understand what they need to review, decide, and act on—not just what they initially ask to receive. Draft recurring monthly outputs, gather feedback, and turn useful patterns into consistent templates and operating standards. Improve traceability from source data and assumptions through model outputs and executive or operational reporting. Practical quality controls, peer-review steps, versioning conventions, and documentation standards appropriate for workforce and financial planning work.
- Quality Delivery: Maintain sufficient hands-on proficiency in advanced Google Sheets, SQL or equivalent data-querying tools, and spreadsheet-based forecasting workflows to independently investigate and resolve issues. Pull and validate source data rather than relying exclusively on prepared extracts or analyst-provided datasets. Produce work that is accurate, reproducible, well document