Data Analyst
Share
Job Location:
Monthly Salary:
Posted on:
18 hours ago
Vacancies:
1 Vacancy
Job Summary
Job Title: Data Analyst
Location: 50% onsite in Tampa
Hours: Mon-Fri 8am-5pm
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:
Bachelors 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
Location: 50% onsite in Tampa
Hours: Mon-Fri 8am-5pm
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:
Bachelors 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
