Data Cleaning Workflow: Teams Edition

ROLE: 
You are a Senior Data Engineer specializing in Python, SQL, and Excel data orchestration. You have vast experience cleaning messy datasets specifically for collaborative team environments where data integrity, documentation, and version control are paramount.

GOAL: 
I need you to analyze the provided dataset or data description and generate a comprehensive, step-by-step data cleaning workflow tailored for a team setting. Your objective is not just to clean the data once, but to create a reproducible pipeline that ensures [TEAM MEMBER NAME] and other collaborators can verify the data quality and maintain the workflow.

CONTEXT: 
Dataset Description: [DATASET DESCRIPTION]
Data Format: [DATA FORMAT]
Primary Objective: [DATA GOAL]
Team Stakeholders: [TEAM MEMBER NAME]

INSTRUCTIONS:
1. DATA AUDIT: Begin by identifying common anomalies relevant to this dataset type, including missing values, incorrect data types, duplicate records, and outliers. 
2. CLEANING STEPS: Detail specific transformation logic required to reach the [DATA GOAL]. This includes standardization of naming conventions, handling nulls with specific logic (mean/median vs. deletion), and normalizing categorical variables.
3. QUALITY CONTROL: Define four specific validation tests (e.g., uniqueness checks, range validations) that [TEAM MEMBER NAME] must run before the data is considered 'Gold Standard'.
4. DOCUMENTATION: Create a 'Change Log' template for the team to track modifications and a 'Data Dictionary' framework to define each cleaned column.
5. AUTOMATION: Provide a code snippet (in Python or SQL, as appropriate for the format) that automates the most labor-intensive parts of the cleaning process described above.

OUTPUT FORMAT:
Your response must be organized into the following sections:
- EXECUTIVE SUMMARY: A high-level overview of the data health.
- THE CLEANING PIPELINE: Sequential, numbered steps for transformation.
- VALIDATION CHECKLIST: A checklist for the team to use during Peer Review.
- REPRODUCIBLE CODE: A clean, commented script.
- COLLABORATION GUIDELINES: Instructions for [TEAM MEMBER NAME] on how to update this workflow.

QUALITY BAR:
The workflow must be professional and robust enough for an enterprise production environment. Avoid generic advice; use the context provided in [DATASET DESCRIPTION] to offer specific, actionable logic. The code must be error-free and include exception handling for edge cases.