Senior Google Sheets Analytics Architect for Workforce Planning

Included Health, Inc.; Northern (KY); Hybrid; USD 243,560,000 - 286,541,000; Full time

Job summary

Included Health, Inc. is seeking a Workforce Analytics Model Standardization Consultant to modernize Google Sheets models that support workforce planning, FP&A, and Care Operations.

This 4-month contract role requires reverse-engineering undocumented models and operating within a live monthly production cycle without disruption. You will collaborate with Workforce Analytics, FP&A, Care Operations, HRIS, Data Engineering, and other stakeholders to standardize high-burden models, document sources

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 another person’s undocumented or poorly documented spreadsheet model and explaining how it works to someone else.
• Experience supporting FP&A, workforce planning, demand forecasting, capacity planning, or a similar recurring planning process where traceability and deadline discipline matter.
• Ability to pull, inspect, and validate data independently using SQL or an equivalent querying or data‑extraction tool.
• Strong stakeholder-discovery skills, including the ability to extract requirements from partners who have not yet articulated a clean specification.
• Experience documenting and handing off work successfully, with specific 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 escalation risks before they affect monthly deliverables.
• Strong written and verbal communication skills, with the ability to explain model logic and data issues clearly to both technical and non-technical stakeholders.
• Willingness to perform detailed, repetitive, and operationally necessary work, including file organization, version cleanup, archiving, reconciliation, and formatting.

Responsibilities

• Standardize and clean Google Sheets models 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.
• 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.
• 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.
• 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.
• Apply practical quality controls, peer-review steps, versioning conventions, and documentation standards appropriate for workforce and financial planning work.

Skills

Google Sheets

SQL

Apps Script

Python

Stakeholder management

Tools

Google Sheets

SQL

Apps Script

Python

Job description

Included Health, Inc. is seeking a Workforce Analytics Model Standardization Consultant to modernize Google Sheets models that support workforce planning, FP&A, and Care Operations.

This 4-month contract role requires reverse-engineering undocumented models and operating within a live monthly production cycle without disruption. You will collaborate with Workforce Analytics, FP&A, Care Operations, HRIS, Data Engineering, and other stakeholders to standardize high-burden models, document sources