Job Description Template Google Sheets

SOP: Standardized Job Description Lifecycle Management (Google Sheets)

1. Executive Summary & Purpose

This procedure mandates the architecture and maintenance of a centralized "Job Description Master Registry" using Google Sheets. The objective is to eliminate version sprawl, ensure cross-departmental consistency, and provide a single source of truth for all organizational roles.

2. Scope & Prerequisites

• Scope: Applies to all departments initiating new headcount or amending existing role requirements.
• Software Requirements: Google Workspace (Sheets, Drive), read/write access to the "Master-JD-Registry" file.
• Prerequisites: Hiring Manager must have a validated Budget Approval Code (BAC) prior to drafting.

3. Roles & Responsibilities (RACI)

4. Step-by-Step Procedure

Phase 1: Initiation and Initialization

• Open the Template Registry Master Sheet via the internal Intranet link.
• Execute File > Make a copy to generate a draft if creating a new requisition.
• Rename file using convention: JD_[Role_Title]_[Dept]_[Date].

Phase 2: Structural Data Entry

• Populate mandatory headers: Role Title, Level (IC/M), Department, Manager.
• Input core competencies using the pre-defined drop-down validation list (Prevents free-text variability).
• Define "Must-Have" vs. "Nice-to-Have" skills in the formatted Requirements block.

Phase 3: Review and Version Control

• Insert a new row in the Revision_Log tab detailing the specific changes made.
• Tag the HRBP via @name in a sheet comment for peer review.
• Finalize the document by locking the status cell to READ-ONLY once approval is granted.

5. Quality Assurance & Pro-Tips

• Data Integrity Tip: Always use Data > Data Validation for fields like "Location" and "Department." Never allow free-text input for core metadata.
• Conditional Formatting: Use conditional formatting rules to highlight cells that exceed word counts (e.g., >250 words per section), ensuring brevity and consistency.
• Metric Threshold: A "high-quality" JD maintains a <5% variance from established internal leveling standards. If variance >5%, the JD must undergo Comp & Benefits audit.
• Common Pitfall: Avoiding the use of "Shared Links." Always attach the file via Google Drive permissions to maintain audit trails.

6. Frequently Asked Questions (FAQ)

Q: How do I handle a role that exists in multiple geographic regions?

• A: Utilize the Region_Filter column in the Master Sheet. Duplicate the row, adjust the location-specific benefits/requirements, and append the ISO country code to the JD ID.

Q: The drop-down menu is missing a necessary skill category. How do I add it?

• A: Do not attempt to modify the validation list manually. Submit an IT-HR Service Desk ticket to have the "Master Metadata List" updated. This prevents schema drift.

End of Document. Document managed by Julian Vance, Chief Architect.