Mental Health Systems, Inc.
ADP Benefits & Audit Consultant
6 days ago
San Diego
Job Description At TURN our mission is Improving Lives. Our organization embraces the tenets of client-centered care, and our core values People, Culture and Growth are at the forefront of everything we do. We hire exceptional individuals seeking meaningful opportunities in a purpose-driven environment. JOB SUMMARY We are seeking a highly skilled and motivated ADP Benefits & Audit Consultant to join our dynamic team. This expert-level ADP Benefits & Audit Consultant will lead the reconciliation of our HR and payroll infrastructure, correct system errors and streamlining processes. This role will be instrumental in ensuring accurate benefit invoicing, file feeds, and payroll alignment across multiple employee groups and locations. The ideal candidate will bring deep expertise in ADP systems, Excel mapping, and benefits administration, along with a sharp eye for detail and 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: o Employee name, Location, Benefit group AND Social Security number • Data Collection: Pull from carrier invoices, eligibility snapshots (ADP WFN), deduction registers, employer credits, retro/arrears reports, COBRA & LOA lists., • Normalization & Matching: Align coverage tiers/rates, map plan codes, reconcile headcount and premiums by plan/tier/location, 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 ☐ Climbing ☒ Lifting/carrying heavy items ☐ Pushing/pulling/dragging items ☒ Standing for long periods ☐ Working outside/underground ☒ Using hands/fingers ☒ Sitting for long periods I can perform the above functions: ☐ Without accommodation ☐ With accommodation. If so, please specify: ––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––––– 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).