Junior Business Analyst – SOC Code Mapping & HR Data Remediation

Pyramid Consulting is recruiting for a confidential healthcare client. The Junior Business Analyst will research and map SOC codes, remediate and validate HR job records, prepare files for HRIS upload, track project progress, and document procedures.

Responsibilities:

• Review job records with missing or potentially inaccurate Standard Occupational Classification (SOC) codes
• Retrieve and review internal job descriptions to understand job duties, responsibilities, and occupational requirements
• Research official federal and state government resources to identify appropriate occupational classifications
• Match job responsibilities and relevant keywords to the most suitable SOC codes
• Enter and document classification results accurately in Excel-based mapping files
• Escalate ambiguous classifications or low-confidence matches to the appropriate subject matter experts
• Review and remediate approximately 1,700+ job records
• Validate existing SOC assignments and identify obvious mismatches between job responsibilities and assigned codes
• Check records for completeness, consistency, duplicate entries, and potential data errors
• Maintain accurate records of completed, pending, and escalated items
• Prepare finalized files for the applicable HR Information System (HRIS) upload process, following established procedures
• Support quality checks to minimize errors before compliance reporting deadlines
• Maintain Excel trackers and monitor outstanding job records
• Provide regular updates on completed work, pending classifications, escalations, and potential blockers
• Organize workload according to project priorities and established deadlines
• Summarize data quality issues and remediation progress for project stakeholders
• Develop clear, step-by-step desk procedures and standard operating procedures (SOPs)
• Document research sources, government websites, keyword search techniques, classification decisions, and validation steps
• Record common scenarios, decision rules, and escalation procedures
• Create practical reference materials to support consistent future maintenance of SOC classifications

Requirements:

• 3–5 years of experience in data analysis, data quality, data validation, business analysis, data remediation, research, auditing, or a related field
• Strong proficiency in Microsoft Excel for spreadsheet management, data entry, filtering, sorting, tracking, and validation
• Excellent attention to detail and the ability to maintain accuracy across a high volume of records
• Strong research and analytical skills, including the ability to interpret job descriptions and associate keywords with standardized classifications
• Experience working with structured datasets, record reconciliation, data mapping, data auditing, or data cleanup
• Strong organizational and time-management skills
• Ability to work independently, manage repetitive tasks, and meet defined deadlines
• Clear written communication skills and the ability to document processes
• Ability to provide regular progress updates and escalate questions when necessary
• Experience with SOC codes or Standard Occupational Classification systems
• Exposure to HR data, HRIS, job codes, job architecture, occupational classification, or compensation data
• Experience supporting compliance reporting, audit preparation, or regulatory data remediation
• Familiarity with government websites and standardized classification resources
• Experience creating SOPs, desk-level procedures, or process documentation
• Healthcare industry experience