Data Analyst - Junior

Job Title:

Data Analyst -

Analytics and Reporting Location:

Tampa, FL -

Hybrid Visa:

Citizens or Green card only (No OPT or CPT) Only on W2

Key Responsibilities:

Wage Type & GL Mapping (Global Focus) Own and maintain global wage type-to-GL mappings within ADP Celergo Review, analyze, and validate wage type mapping files across multiple countries and legal entities Ensure wage types (earnings, deductions, taxes, employer contributions) post accurately to the appropriate GL accounts Support ongoing standardization and harmonization of wage type mappings globally Data Analysis & Excel-Based Reporting Analyze, clean, and reconcile large Excel data sets related to payroll wage types and GL mappings Use advanced Excel functionality including pivot tables, XLOOKUP, VLOOKUP, formulas, and charts to identify issues and trends Validate mapping data prior to payroll processing or system updates Create and maintain Excel-based controls, trackers, and reconciliation tools Translate raw payroll data into clear, actionable insights for stakeholders Payroll Accounting & Controls Ensure payroll mappings align with accounting policies and internal controls Support configuration testing and validation related to wage type or mapping changes Cross-Functional Collaboration Act as a key liaison between Global Payroll, Finance, Accounting, and HR Communicate mapping changes and data findings clearly to non-technical stakeholders Support system enhancements, country expansions, or process improvements within ADP Celergo

MUST HAVES

Advanced Excel skills, including pivot tables, XLOOKUP/VLOOKUP, formulas, data validation, and charting Strong experience analysing, cleansing, and validating payroll-related data

Highly Preferred:

Bachelor's degree in Accounting, Finance, Human Resources, or related field (or equivalent experience) 3+ years of payroll or payroll accounting experience with direct exposure to wage types and GL mappings Hands-on experience supporting ADP Celergo payroll processing or integrations Nice to have: Experience supporting global or multi-country payroll environments Payroll accounting or payroll implementation experience Experience working with large, complex Excel-based mapping files

Pay:

$20.00 - $23.00 per hour Application Question(s): Are you comfortable to work on W2?

Work Location:

Hybrid remote in Tampa, FL 33610