Data Analyst

Spectraforce Technologies; Tampa (FL); On-site; USD 55,000 - 75,000; Full time

Job summary

Spectraforce Technologies is seeking a Data Analyst to support wage type-to-GL mappings across multiple countries using ADP Celergo. The role emphasizes examining and validating payroll data, leveraging advanced Excel for reporting, and ensuring accurate payroll-to-GL posting.

The ideal candidate will have strong payroll accounting knowledge, data cleansing experience, and the ability to translate raw payroll data into actionable insights for stakeholders.

Qualifications

• Bachelor's degree or equivalent experience in accounting/finance.
• 3+ years of payroll or payroll accounting experience with wage types and GL mappings.
• Hands-on experience with ADP Celergo payroll processing or integrations.
• Advanced Excel skills for data analysis and reporting.

Responsibilities

• Own and maintain global wage type-to-GL mappings within ADP Celergo.
• Analyze, clean, and reconcile large payroll data sets and mappings.
• Create Excel-based controls, trackers, and reconciliation tools.
• Collaborate with Global Payroll, Finance, Accounting, and HR.

Skills

Advanced Excel

Payroll data analysis

Wage types & GL mappings

Data cleansing

Stakeholder communication

Education

Bachelor's degree in Accounting/Finance

Tools

ADP Celergo

Microsoft Excel

Job description

Job Title: Data Analyst

Location: 50% onsite in Tampa

Hours: Mon-Fri 8 am-5 pm

Duration: 10 Months

Summary:

We are seeking an analytical Global Payroll Wage Type & GL Mapping Data Entry Analyst to support and maintain wage type-to-general ledger (GL) mappings for global payroll operations using ADP Celergo. This role is primarily focused on ensuring accurate and consistent payroll-to-financial integrations across multiple countries and entities.

The ideal candidate has advanced Excel skills, strong payroll accounting knowledge, and experience analyzing, cleansing, and validating large data sets related to payroll wage types and GL mappings.

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

Required Qualifications:

• 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
• Advanced Excel skills, including pivot tables, XLOOKUP/VLOOKUP, formulas, data validation, and charting
• Strong experience analyzing, cleansing, and validating payroll-related data

Preferred Qualifications:

• Experience supporting global or multi‑country payroll environments
• Payroll accounting or payroll implementation experience
• Experience working with large, complex Excel‑based mapping files

Skills & Competencies

• Exceptional attention to detail and data accuracy
• Strong analytical and problem‑solving skills
• Ability to interpret payroll and financial data across different countries
• Excellent written and verbal communication skills

Position is offered by a no fee agency.