Note: The job is a remote job and is open to candidates in USA. MBO Partners is seeking an HRIS Data Analyst on contract to support its internal HR Operations team. The role maintains HR data across ADP Workforce Now and connected systems, analyzes and reconciles data, supports audits and compliance processes, and documents and improves workflows.
Responsibilities
- Execute recurring weekly and monthly HR data maintenance processes across ADP Workforce Now and connected systems
- Update employment dates and status changes, including terminations, rehires, and reactivations
- Update full-time/part-time status flags, hourly rates, and other compensation-related fields as needed
- Maintain paid sick leave eligibility plans, including new eligibility, changes, and loss of eligibility
- Update stability start dates, end dates, and eligibility dates in ADP
- Support missed premiums processing and retirement eligibility determination workflows
- Conduct minimum wage compliance reviews on a recurring basis
- Review and resolve file errors related to Fidelity and other downstream vendor systems
- Complete monthly I-9 termination processes
- Analyze large datasets across multiple systems to identify data discrepancies and determine the most accurate record
- Investigate data abnormalities and system limitations to identify root causes and develop corrective actions
- Identify patterns and trends in data issues and present recommendations for long-term resolution
- Use advanced Excel skills (including complex formulas, VLOOKUPs, pivot tables, and macros) to compare and reconcile data across platforms
- Support monthly audits of background checks and I-9 records in line with defined audit targets
- Provide additional audit support as defined by the HR Operations team
- Document process flows, system procedures, and corrective action guides for ongoing operational use
- Maintain and update process guides that outline how to navigate systems and complete data corrections
- Support automation workstream efforts through process documentation, testing, and related activities
- Recommend and help implement long-term solutions to reduce recurring manual effort and data inconsistencies
Skills
- Hands-on experience with HRIS/ADP Workforce Now, including the Core HR and Payroll modules
- Strong HR domain knowledge — this role requires genuine HR/HRIS expertise, not just data analyst skills applied to an HR context
- Advanced Microsoft Excel proficiency, including complex formulas, VLOOKUPs/XLOOKUPs, pivot tables, macros, and large dataset analysis
- Experience performing data analysis and reconciliation across multiple systems to identify discrepancies and determine accurate records
- Ability to work in a role that involves both operational execution and analytical problem-solving
- Experience researching data issues, identifying root causes, and resolving inconsistencies across integrated platforms
- Experience documenting workflows, process guides, and system procedures
- Strong attention to detail and the ability to manage recurring, high-impact deliverables with accuracy and consistency
- Ability to work independently and exercise sound judgment with sensitive employee data
- Experience supporting HR compliance processes, audits, or regulated HR documentation (I-9, background checks, etc.)
- Strong written and verbal communication skills
- Experience with benefits, eligibility or ACA-related data in ADP
- Familiarity with Fidelity integrations or similar downstream HR/payroll vendor file processes
- Experience supporting process improvement, automation, or systems enhancement initiatives
- Must be legally authorized to work in the United States
- ADP experience is highly preferred
Benefits
- Depending on employment classification and eligibility: medical, dental, and vision coverage; health savings accounts; life and AD&D insurance; long-term disability coverage; commuter benefits; and retirement plans. Eligibility for specific benefits is subject to the terms and conditions of the applicable benefit plans.
Company Overview