Spreadsheet Model Architect for Workforce Analytics

Included Health; United States; Remote; USD 117,000 - 138,000; Full time

Job summary

Included Health is seeking a Workforce Analytics Model Standardization Consultant to modernize Google Sheets-based models used for workforce planning, forecasting, FP&A, and Care Operations. This hands-on role requires reverse-engineering undocumented work and delivering durable improvements within a live monthly cycle.

You will partner with Workforce Analytics, FP&A, Care Operations, HRIS, and Data Engineering to create standardized templates, thorough documentation, and reliable runbooks that

Qualifications

• 6+ years in analytics, workforce planning, FP&A analytics, operations analytics, or a related data-focused field, with experience owning projects end to end.
• Demonstrated experience building spreadsheet tools that other people relied on and maintaining them through real operating cycles.
• Advanced proficiency in Google Sheets, including complex formulas, interconnected files, data validation, error handling, performance considerations, and cross-file references at scale.
• Direct experience reverse-engineering undocumented or poorly documented spreadsheet models and explaining how they work to someone else.
• Experience supporting FP&A, workforce planning, demand forecasting, capacity planning, or a similar recurring planning process with traceability and deadlines.
• Ability to pull, inspect, and validate data independently using SQL or an equivalent querying or data-extraction tool.
• Strong stakeholder-discovery skills to extract requirements that may not be clearly articulated.
• Experience documenting and handing off work with examples of teams continuing to operate the tools after the consultant or analyst left.
• Ability to work inside a live production cycle, manage competing deadlines, and elevate risks before monthly deliverables.
• Strong written and verbal communication skills to explain model logic and data issues to both technical and non-technical stakeholders.
• Willingness to perform detailed, repetitive, operational work including file organization, version cleanup, archiving, reconciliation, and formatting.

Responsibilities

• Bring high-burden Google Sheets models up to team standards for structure, readability, maintainability, and traceability.
• Audit interconnected spreadsheets, identify broken dependencies, clarify inputs/outputs, and reduce unnecessary complexity without changing 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.
• Reverse-engineer undocumented models and write clear documentation explaining how they work.
• Document source data, refresh steps, dependencies, assumptions, and key calculations; create handoff materials.
• Support the recurring workforce planning and forecasting cycle and handle routine manual ingestion, formatting, and quality checks.
• Work carefully within live production processes, escalating issues early and protecting deadlines for FP&A and Operations deliverables.
• Create lightweight Jira workflow improvements and repeatable checklists for recurring analytics tasks.

Skills

Google Sheets

SQL

Stakeholder discovery

Documentation

Forecasting

Attention to detail

Tools

Apps Script

Python

Jira

Job description

Included Health is seeking a Workforce Analytics Model Standardization Consultant to modernize Google Sheets-based models used for workforce planning, forecasting, FP&A, and Care Operations. This hands-on role requires reverse-engineering undocumented work and delivering durable improvements within a live monthly cycle.

You will partner with Workforce Analytics, FP&A, Care Operations, HRIS, and Data Engineering to create standardized templates, thorough documentation, and reliable runbooks that