Works with the AI Agents you already use
hr data inventory and quality auditor
Dirty HR data leads to broken people analytics, failed compliance audits, and reporting errors.
$2.99
hr data inventory and quality auditor
Example session with this skill installed
Audit the attached employee_extract.csv and positions.json. Authorization provided by the HRIS Director for the employee and position scopes. Use a stale_after_days parameter of 90.
- Read your context and instructions
- Compiled the hr data inventory
- Generated the data export
The HR Data Quality audit for the provided extracts is complete. The analysis identified several orphaned positions and duplicate person match keys.
HR Data Inventory and Quality Audit — Acme Corp, 2024-05-20
1. Scope, authorisation and assumptions
- Sources: E1 (employee_extract.csv), E2 (positions.json).
- Approving Role: HRIS Director.
- Purpose: Data quality profiling.
- Granted Scopes: employee, position.
2. Data inventory and ownership
| Dataset | Category | Owner | Steward | Personal data | Findings |
|---|---|---|---|---|---|
| E1 | Employee Master | HR Ops | J. Doe | Yes | Missing Lawful Basis |
| E2 | Position Mgmt | Org Design | Unassigned | No | Steward Gap |
3. Record quality profiles
| Record set | In scope | Completeness | Records with findings | Clean-record rate |
|---|---|---|---|---|
| Employees | 1250 | 0.9840 | 20 | 0.9840 |
| Positions | 1300 | 0.9500 | 65 | 0.9500 |
4. Duplicates, references and consistency
| Record set | Finding | Severity | Records | Row pointers |
|---|---|---|---|---|
| Employees | possible_duplicate_person | High | 4 | [102, 455, 890, 1102] |
| Positions | orphan_reference | Medium | 12 | [12, 45, 67, 89...] |
5. Lawful-use, retention and jurisdiction review queue
Findings indicate 15 records in E1 exceed the defined 90-day staleness parameter. Jurisdiction-specific employment and privacy law review by qualified counsel is needed.
6. Suppressed and excluded data
- Suppressed: 2 small groups (n<5) in department-level aggregates.
- Excluded: 0 records.
7. Draft actions and items for human review
- Draft: Reassign Position Steward for E2. Management decision required.
- Draft: Review possible duplicate persons in E1. Information gap — organizational validation required.
Next steps
- Review the row pointers in section 4 to identify specific duplicate records.
- Assign a Steward to the Position Management dataset.
- Validate the 15 records flagged for retention policy violations with Legal.
employee_extract.csv
CSV · data export
Example file from a real run - the skill writes it into your workspace.
Connects securely to your tools. The creator never sees your data.
About this skill
Dirty HR data leads to broken people analytics, failed compliance audits, and reporting errors. This skill provides a deterministic audit of workforce datasets and record extracts to identify gaps in ownership, documentation, and data integrity. It profiles employee and organizational records for duplicates, orphaned references, and inconsistent dates before you feed them into production systems.
What it does
- Inventory auditing checks datasets for missing owners, stewards, lawful basis documentation, and retention policies.
- Record profiling analyzes employee, position, and org-unit records for completeness and field-level accuracy.
- Integrity checking detects duplicate keys, possible duplicate persons via match keys, and reporting-line loops.
- Reference validation identifies orphaned position references and contradictions in employment history dates.
- Privacy review flags cross-border transfers lacking mechanisms and retention periods exceeding policy limits.
- Action drafting generates a review queue for data owners and legal counsel while suppressing small group sizes for privacy.
How it works
- Supply data by providing HR dataset metadata or minimal record extracts (CSV/JSON).
- Authorize scope by specifying the approving role and granting access to employee, position, organization, or history domains.
- Execute audit via a deterministic Python script that processes the
request.jsonagainst defined quality rules. - Review findings through a structured Markdown report featuring data-owner queues and draft remediation actions.
Frameworks & tools
This skill uses a self-contained Python 3 script for data processing. It operates on structured JSON input/output schemas and adheres to strict data minimization principles.
Why this beats prompting it yourself
Generic prompts often hallucinate data quality benchmarks or miss subtle reporting-line loops. This skill uses a deterministic script to ensure every count, rate, and duplicate check is mathematically exact and repeatable. It also enforces privacy through automated small-group suppression that a standard prompt would likely ignore.
Use cases
- Audit an HR data inventory before a migration or system implementation.
- Profile workforce records to find duplicate identities or orphaned positions.
- Build a legal review queue for GDPR or jurisdiction-specific data retention.
- Validate org-chart integrity and reporting lines before executive reporting.
Known limitations
Does not support supplier master data or payroll-specific financial auditing. Cannot perform record merging or automated data cleaning. Requires a minimum group size of 5 for privacy suppression.
Requires Python 3 for script execution. Minimum group size for reporting is 5 records. No support for supplier/vendor data or automated record merging.
How to use
- 1
Connect your agent to the Agensi MCP
Copy the prompt and paste it into Claude, ChatGPT, Cursor or any agent that supports MCP. It sets up the connection for you. Manual setup
- 2
Sign in to Agensi
Your agent shows a sign-in link. Sign in and click Allow.
- 3
Ask for what you need
Your agent loads this skill and uses it on your task. It always asks before any payment.
Reviews
No reviews yet
Be one of the first to try it. Every listed skill goes through the trust checks below.
Security scanned
Checked by our 8-point scan before listing
Fresh listing
Recently published to Agensi
Money-back guarantee
Doesn't do what its page promises? You get your money back.
Trust & safety
Security scan
Security scan passed 2 days ago