Mental Health Systems
ADP Consultant - Benefits Implementation & Audit
Mental Health Systems, San Diego, California, United States, 92189
ADP Consultant - Benefits Implementation & Audit
We are seeking a highly skilled and motivated ADP Benefits & Audit Consultant to join our dynamic team. This expert-level role will lead the reconciliation of our HR and payroll infrastructure, correct system errors and streamline processes. The ideal candidate will bring deep expertise in ADP systems, Excel mapping, and benefits administration, with a proactive approach to problem-solving. Responsibilities
Lead end-to-end diagnostic of double deductions in ADP WFN: analyze historical payroll around open enrollment/plan-year rollover, LOA returns, retro events, and deduction start/stop rules; identify causes such as duplicate benefit events, overlapping effective dates, multiple active deduction codes per plan, arrears plus current stacking, duplicate EDI loads, and calendar misalignment. Design and implement permanent fixes: consolidate/retire duplicate codes, correct eligibility and deduction rules (pre-/post-tax, priority, arrears, net-pay protections), align payroll calendars, and adjust OE default rules; build test cases and run parallel payroll testing before release. Establish preventive controls: pre-payroll changes audit (new/changed/duplicate deductions), employees with multiple active deductions for the same plan, arrears current thresholds, and large-delta flags; post-payroll variance checks versus prior period and GL mapping validation. Create and run a Year-End/Plan-Year Rollover Checklist with freeze windows, data validation steps, and signoffs to avoid duplicate starts and retro cascades. Implement the Monthly Healthcare Billing Reconciliation Playbook (see section below), including intake, matching logic, variance reason codes, approval workflow, and month-end close timing. Stabilize and monitor EDI 834 eligibility and (where applicable) 820 remittance files: correct file timing vs. payroll cutoffs, deduplicate events, triage carrier rejects, and reconcile confirmations against WFN. Configure and QA payroll deductions for all benefit plans (medical/dental/vision, HSA/FSA/LPFSA/DCFSA, life/AD&D, disability, commuter, 401(k)/Roth). Validate caps, catch-up rules, employer credits, imputed income (e.g., GTL > $50k), domestic partner taxation, and GL cost-center splits. Build operational reporting in ADP WFN: Deduction Register, New/Changed Deductions, Employees with Duplicate Deductions, Arrears Aging, OE Progress, and Invoice Variance by plan and location. Partner with Payroll and Finance on quarter-/year-end activities: W-2 reporting impacts (Box 12 codes), dependent-care, HSA totals, imputed income, and ACA data integrity. Document SOPs and train HR/Payroll staff; transition ownership with a control matrix, metrics, and remediation runbooks. Create and manage detailed census reports using Excel, including data points such as employee name, location, benefit group, and Social Security number; data collection from carrier invoices, eligibility snapshots (ADP WFN), deduction registers, employer credits, retro/arrears reports, COBRA & LOA lists; normalization & matching to align coverage tiers/rates, map plan codes, reconcile headcount and premiums by plan/tier/location, and flag significant variances. Variance management: identify root causes (e.g., retro changes, EOI delays, rate mismatches), document fixes and timing (current vs. next cycle). Approval & Payments: establish HR → Payroll → Finance workflow with signoffs and payment controls. GL reconciliation: tie to payroll and employer costs, post journals, track open variances with ownership and deadlines. Qualifications
Bachelor’s degree in a related field. Expert level expertise with ADP Workforce Now (Benefits, HR, Payroll) including configuration, parallel testing, and production fixes. Track record resolving double-deduction or similar systemic benefit/payroll defects and standing up preventive controls. Advanced Excel (VLOOKUP/XLOOKUP, INDEX/MATCH, pivots) and strong data reconciliation skills; Power Query or scripting plus. Experience with EDI 834 eligibility (and 820 remittances where applicable), carrier billing, and invoice-to-payroll tie-outs. Knowledge of compliance: HIPAA/PHI handling, ERISA, Section 125, COBRA, ACA 6055/6056, W-2 reporting, and IRS annual limits. Clear communicator and project leader able to run discovery, build a remediation plan, manage timelines, and deliver knowledge transfer. Consulting mindset with ability to work independently in a fast-paced environment and partner with HR, Payroll, Finance, and carriers. Familiarity with employee data privacy and compliance standards (HIPAA, etc.). Excellent analytical, organizational, training, presentation and communication skills. Ability to work independently and manage multiple priorities in a fast-paced environment. Prior consulting experience preferred. Physical Requirements
These physical demands represent what must be met to successfully perform the essential functions of this position. As mentioned above, reasonable accommodation may be made for qualified disabilities. Seeing, Hearing, Speaking; Stooping/Bending, Working in cramped spaces, Moving around facility; Moving between offices/clients, Driving; Lifting/carrying heavy items; Standing for long periods; Using hands/fingers; Sitting for long periods. Other Duties
This job description isn’t a comprehensive list of activities, duties or responsibilities required for this job. Duties, responsibilities and activities may change at any time with or without notice. Employee signature constitutes an understanding of the job requirements, essential functions, and duties. TURN is an equal opportunity employer to all, regardless of age, ancestry, color, disability (mental and physical), gender, gender expression, gender identity, sexual orientation, marital status, medical condition, military or veteran status, national origin, race, religious creed, and sex (includes pregnancy, childbirth, breastfeeding, and related medical conditions). Seniority level
Mid-Senior level Employment type
Full-time Job function
Information Technology Industries
Mental Health Care
#J-18808-Ljbffr
We are seeking a highly skilled and motivated ADP Benefits & Audit Consultant to join our dynamic team. This expert-level role will lead the reconciliation of our HR and payroll infrastructure, correct system errors and streamline processes. The ideal candidate will bring deep expertise in ADP systems, Excel mapping, and benefits administration, with a proactive approach to problem-solving. Responsibilities
Lead end-to-end diagnostic of double deductions in ADP WFN: analyze historical payroll around open enrollment/plan-year rollover, LOA returns, retro events, and deduction start/stop rules; identify causes such as duplicate benefit events, overlapping effective dates, multiple active deduction codes per plan, arrears plus current stacking, duplicate EDI loads, and calendar misalignment. Design and implement permanent fixes: consolidate/retire duplicate codes, correct eligibility and deduction rules (pre-/post-tax, priority, arrears, net-pay protections), align payroll calendars, and adjust OE default rules; build test cases and run parallel payroll testing before release. Establish preventive controls: pre-payroll changes audit (new/changed/duplicate deductions), employees with multiple active deductions for the same plan, arrears current thresholds, and large-delta flags; post-payroll variance checks versus prior period and GL mapping validation. Create and run a Year-End/Plan-Year Rollover Checklist with freeze windows, data validation steps, and signoffs to avoid duplicate starts and retro cascades. Implement the Monthly Healthcare Billing Reconciliation Playbook (see section below), including intake, matching logic, variance reason codes, approval workflow, and month-end close timing. Stabilize and monitor EDI 834 eligibility and (where applicable) 820 remittance files: correct file timing vs. payroll cutoffs, deduplicate events, triage carrier rejects, and reconcile confirmations against WFN. Configure and QA payroll deductions for all benefit plans (medical/dental/vision, HSA/FSA/LPFSA/DCFSA, life/AD&D, disability, commuter, 401(k)/Roth). Validate caps, catch-up rules, employer credits, imputed income (e.g., GTL > $50k), domestic partner taxation, and GL cost-center splits. Build operational reporting in ADP WFN: Deduction Register, New/Changed Deductions, Employees with Duplicate Deductions, Arrears Aging, OE Progress, and Invoice Variance by plan and location. Partner with Payroll and Finance on quarter-/year-end activities: W-2 reporting impacts (Box 12 codes), dependent-care, HSA totals, imputed income, and ACA data integrity. Document SOPs and train HR/Payroll staff; transition ownership with a control matrix, metrics, and remediation runbooks. Create and manage detailed census reports using Excel, including data points such as employee name, location, benefit group, and Social Security number; data collection from carrier invoices, eligibility snapshots (ADP WFN), deduction registers, employer credits, retro/arrears reports, COBRA & LOA lists; normalization & matching to align coverage tiers/rates, map plan codes, reconcile headcount and premiums by plan/tier/location, and flag significant variances. Variance management: identify root causes (e.g., retro changes, EOI delays, rate mismatches), document fixes and timing (current vs. next cycle). Approval & Payments: establish HR → Payroll → Finance workflow with signoffs and payment controls. GL reconciliation: tie to payroll and employer costs, post journals, track open variances with ownership and deadlines. Qualifications
Bachelor’s degree in a related field. Expert level expertise with ADP Workforce Now (Benefits, HR, Payroll) including configuration, parallel testing, and production fixes. Track record resolving double-deduction or similar systemic benefit/payroll defects and standing up preventive controls. Advanced Excel (VLOOKUP/XLOOKUP, INDEX/MATCH, pivots) and strong data reconciliation skills; Power Query or scripting plus. Experience with EDI 834 eligibility (and 820 remittances where applicable), carrier billing, and invoice-to-payroll tie-outs. Knowledge of compliance: HIPAA/PHI handling, ERISA, Section 125, COBRA, ACA 6055/6056, W-2 reporting, and IRS annual limits. Clear communicator and project leader able to run discovery, build a remediation plan, manage timelines, and deliver knowledge transfer. Consulting mindset with ability to work independently in a fast-paced environment and partner with HR, Payroll, Finance, and carriers. Familiarity with employee data privacy and compliance standards (HIPAA, etc.). Excellent analytical, organizational, training, presentation and communication skills. Ability to work independently and manage multiple priorities in a fast-paced environment. Prior consulting experience preferred. Physical Requirements
These physical demands represent what must be met to successfully perform the essential functions of this position. As mentioned above, reasonable accommodation may be made for qualified disabilities. Seeing, Hearing, Speaking; Stooping/Bending, Working in cramped spaces, Moving around facility; Moving between offices/clients, Driving; Lifting/carrying heavy items; Standing for long periods; Using hands/fingers; Sitting for long periods. Other Duties
This job description isn’t a comprehensive list of activities, duties or responsibilities required for this job. Duties, responsibilities and activities may change at any time with or without notice. Employee signature constitutes an understanding of the job requirements, essential functions, and duties. TURN is an equal opportunity employer to all, regardless of age, ancestry, color, disability (mental and physical), gender, gender expression, gender identity, sexual orientation, marital status, medical condition, military or veteran status, national origin, race, religious creed, and sex (includes pregnancy, childbirth, breastfeeding, and related medical conditions). Seniority level
Mid-Senior level Employment type
Full-time Job function
Information Technology Industries
Mental Health Care
#J-18808-Ljbffr