Workforce Analytics Model Standardization Consultant

Accountabilities:

• Model standardization: Audit and improve high-burden Google Sheets models, strengthening structure, readability, maintainability, traceability, formula consistency, data integrity, and error handling while preserving sound forecasting methodology.
• Model governance: Establish consistent standards for tabs, formulas, inputs, assumptions, checks, file naming, permissions, dependencies, versioning, and handoff materials.
• Documentation and archiving: Reverse-engineer undocumented models and create practical documentation covering data sources, refresh procedures, dependencies, assumptions, business rules, calculations, outputs, limitations, and common failure modes.
• File organization: Maintain clear Google Drive inventories and folder structures, distinguish current files from historical sources and reference versions, and archive stale or redundant materials while preserving information needed for auditability and trend analysis.
• Monthly planning support: Support the recurring workforce planning and forecasting cycle by handling data ingestion, file preparation, formatting, reconciliation, quality checks, and other operational tasks while protecting critical deadlines.
• Workflow improvement: Help strengthen Jira workflows for analytics intake, prioritization, tracking, review, and completion, while developing lightweight checklists and repeatable procedures with clear ownership and escalation paths.
• Governance and reporting: Develop standardized model outputs, reusable FP&A and Operations pre-read templates, quality controls, peer-review processes, and documentation standards that improve traceability from source data through executive reporting.
• Data quality and investigation: Independently pull, inspect, reconcile, and validate source data using Google Sheets, SQL, or equivalent tools, investigating and resolving issues without relying exclusively on prepared datasets.
• Automation: Use Apps Script, Python, or similar lightweight automation selectively to reduce repetitive work and improve reliability without introducing unnecessary operational risk.
• Stakeholder partnership: Work closely with Workforce Analytics, FP&A, Care Operations, HRIS, Data Engineering, and other stakeholders to understand their decision-making needs and translate them into practical analytical tools and outputs.
• Project delivery: Own defined workstreams through completion, manage competing priorities within a live production environment, escalate risks early, and leave behind durable tools, processes, and handoff materials.

Requirements:

• Experience: 6+ years in analytics, workforce planning, FP&A analytics, operations analytics, or a related data-focused discipline, with demonstrated ownership of projects from start to finish.
• Spreadsheet expertise: Advanced Google Sheets proficiency, including complex formulas, interconnected files, cross-file references, data validation, error handling, performance considerations, and large-scale spreadsheet management.
• Model development: Proven experience creating spreadsheet tools that other teams depend on and maintaining them through recurring operational or planning cycles.
• Reverse engineering: Direct experience analyzing undocumented or poorly documented spreadsheet models and clearly explaining their logic, dependencies, and operating requirements to others.
• Planning and forecasting: Experience supporting FP&A, workforce planning, demand forecasting, capacity planning, or similar recurring processes where accuracy, traceability, and deadline discipline are essential.
• Data querying: Ability to independently retrieve, inspect, reconcile, and validate data using SQL or an equivalent querying or extraction tool.
• Requirements discovery: Strong stakeholder-discovery skills and the ability to turn loosely defined business needs into clear, practical requirements and deliverables.
• Documentation and handoff: Demonstrated ability to create documentation and operating materials that enable other teams to successfully maintain tools and workflows after project completion.
• Production discipline: Ability to work within live production cycles, manage multiple deadlines, identify risks early, and deliver accurate, reproducible work under time pressure.
• Communication: Excellent written and verbal communication skills, with the ability to explain analytical models, data issues, and recommendations to both technical and non-technical audiences.
• Operational mindset: Willingness to perform detailed and repetitive but essential work, including file organization, reconciliation, version cleanup, archiving, formatting, and quality assurance.
• Preferred: Experience leading forecasting or analytics teams, establishing delivery standards, coaching analysts, or creating repeatable operating practices.
• Preferred: Experience with Apps Script, Python, model governance, version-control practices, documentation standards, review checklists, or audit-ready controls.
• Preferred: Background in regulated, audited, SOX-adjacent, healthcare, financial services, or similarly controlled environments.
• Preferred: Experience with Jira workflow design and recurring pre-reads or planning packages for Finance, Operations, or executive stakeholders.
• Preferred: Familiarity with workforce management, contact centers, clinical operations, care delivery, or environments where demand, staffing, capacity, and productivity are closely connected.

Benefits:

• Contract duration: Approximately 4 months.
• Compensation: $85–$100 per hour for this full-time contract position in the United States.
• Compensation approach: Starting hourly compensation may vary based on education, training, skills, experience, certifications, organizational needs, internal equity, and geographic and market considerations.
• Remote work: Fully remote opportunity.
• Meaningful scope: Opportunity to deliver durable improvements to workforce planning, forecasting, analytics governance, and operational decision-making.
• Cross-functional exposure: Collaborate with teams spanning Workforce Analytics, FP&A, Care Operations, HRIS, Data Engineering, and other business functions.
• Professional impact: Build standardized models, reusable templates, documentation, and workflows that continue to provide value after the engagement ends.
• Equal opportunity: The hiring organization considers qualified applicants without regard to legally protected characteristics.