What are the TOP Critical Skills or Must Haves skills a candidate should have on their resume in order to be considered?
1 Advanced in Excel with demonstrated ease of use in pivot tables formulas Finance formatting combining data from multiple sources.
2 Comfort working with an ERP system extracting data and downloading reports
3 Understanding payroll results willing to train on Union specifics
4 Organized and mindful of deadlines
5 Good written communications to work with outside Union vendors
Nice to Have: Union experience within Payroll reporting
Develop prepare and analyzed Excel-based reports from SAP ECP extracts focusing on enhancing ECP reporting accuracy for union payments contributions and payroll GL reconciliations.
Prepare and support weekly and monthly reporting for Division Accounting Departments utilizing Excel for comprehensive data analysis and report creation.
Generate ad hoc reports based on SAP ECP extracts to support the payroll union and Finance team.
Support data verification and troubleshoot errors of payroll earnings and dues for employees and employer contributions.
Research and complete external Union or Union Pension/Health Plan requests for employee information or verification of payments processed.
Reconcile weekly union interface files and validate accuracy with completed union payment processes resolving discrepancies as needed.
Provide support for union audit data requests related to pension health or 401k employer contributions.
Monthly reconciliation of Union payroll balance sheet accounts.
Support calculation of adjustments for union-related deductions and contributions on ad hoc basis.
Collaborate on special projects and assist with reporting initiatives to improve the accuracy.
REQUIREMENTS - KNOWLEDGE SKILLS ABILITIES
Strong proficiency in advanced Excel functions including demonstrated ease of use in pivot tables formulas Finance formatting and combining data sheets from multiple sources.
Familiar with SAP EC Payroll desired or with a large-scale ERP desired
At least one to two years of experience in payroll reporting analysis
Experience in interpreting payroll results desired.
Must be detail-oriented with excellent analytical skills.
Comfort with working in Zoom Teams and ability to train or review work in them.
Ability to maintain strict confidentiality.
Strong organizational written and verbal communication skills Proactive with excellent follow-up skills
Ability to multi-task and work well under deadlines.
Eligibility requirements apply to some benefits and may depend on your job classification and length of employment. Benefits are subject to change and may be subject to specific elections, plan, or program terms. If eligible, the benefits available for this temporary role may include the following:
§ Medical, dental & vision
§ Critical Illness, Accident, and Hospital
§ 401(k) Retirement Plan – Pre-tax and Roth post-tax contributions available
§ Life Insurance (Voluntary Life & AD&D for the employee and dependents)
§ Short and long-term disability
§ Health Spending Account (HSA)
§ Transportation benefits
§ Employee Assistance Program
§ Time Off/Leave (PTO, Vacation or Sick Leave)
About TEKsystems:
We're partners in transformation. We help clients activate ideas and solutions to take advantage of a new world of opportunity. We are a team of 80,000 strong, working with over 6,000 clients, including 80% of the Fortune 500, across North America, Europe and Asia. As an industry leader in Full-Stack Technology Services, Talent Services, and real-world application, we work with progressive leaders to drive change. That's the power of true partnership. TEKsystems is an Allegis Group company.
The company is an equal opportunity employer and will consider all applications without regards to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.
