Global Payroll Wage Type & GL Mapping Data Entry Analyst

LanceSoft Inc

Tampa, FL

Apply

JOB DETAILS

JOB TYPE

Full-time

SKILLS

ADP, Accounting, Accounting Policies, Analysis Skills, Change Control, Communication Skills, Cross-Functional, Customer Support/Service, Data Analysis, Data Entry, Data Mapping, Data Quality, Data Sets, Detail Oriented, Finance, General Ledger Accounting, Human Resources, Identify Issues, Legal, Microsoft Excel, Payroll Accounting, Payroll Administration, Pivot Tables, Presentation/Verbal Skills, Problem Solving Skills, Process Improvement, Reconciliation, Systems Maintenance, Technical Support, Trend Analysis, Validation Testing, Vlookups, Writing Skills

LOCATION

Tampa, FL

POSTED

30+ days ago

Job Title: Global Payroll Wage Type & GL Mapping Data Entry Analyst Location: 50% onsite in Tampa, FL 33607 Duration: 10 Months Hours: Mon-Fri 8am-5pm MUST HAVES: Advanced Excel skills, including pivot tables, XLOOKUP/VLOOKUP, formulas, data validation, and charting Strong experience analyzing, cleansing, and validating payroll-related data Highly Preferred: 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 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 Summary: We are seeking an analytical Global Payroll Wage Type & GL Mapping Data Entry Analyst to support and maintain wage typetogeneral 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 typetoGL 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

About the Company

LanceSoft Inc

We are a $125 Million, NMSDC-certified Minority & Woman owned Workforce Solutions Company headquartered in the DC metro area with presence across US with global presence - Canada, Mexico, India, UK, Malaysia, Indonasia, Hongkong, Singapore, UAE. We are specialized in providing Workforce Solutions, SOW project delivery, Engineering Solutions, Creative Services. We currently support 100+ Fortune companies globally and across multiple industry segments. We are currently supporting several massive programs across industry segment nationally/globally (Intel, Ally, AMD, QUALCOMM, Morgan Stanley, Kraft/ Mondelez, MNP, Amdocs, Dell, SanDisk, Medtronic, Becton Dickinson, GE, Lockheed Martin, UTC, L-3 Communications, Caterpillar, BMW, Mercedes Benz, National Grid, Dominion, Energy Future Holdings, PSEG, 3M, Fidelity, Aetna, Humana, Johnson & Johnson, Pfizer, Merck etc).

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender, identity, national origin, disability, or protected veteran status.

COMPANY SIZE

2,000 to 2,499 employees

INDUSTRY

Staffing/Employment Agencies

FOUNDED

2000

WEBSITE

http://www.lancesoft.com/

Resume Resources

Free Resume Templates Free Resume Builder