ER Data Reconciliation Associate

Maine-Public-Employees-Retirement-System-; Augusta (ME); On-site; USD 39,000 - 42,000; Full time

Benefits offered by this job

13 paid holidays

Dental Insurance

Health Insurance Coverage 65%-95%

Vision Insurance

Pension Plan

Gym Membership Reimbursement

FSAs

Student Loan Forgiveness

Parental leave

Deferred Compensation

Job summary

Maine Public Employees Retirement System (MainePERS) is seeking a Data Reconciliation Associate to join our Employer Reporting team in Augusta, ME. The role focuses on analyzing and reconciling employer payroll data submitted to MainePERS defined benefit plans.

You will research discrepancies, prepare corrections, and maintain detailed records. Strong analytical skills and Excel proficiency are essential for accurate, timely data integrity and collaboration with auditors and employer staff.

Qualifications

• Associates degree in Accounting or Business with two years of relevant accounting experience
• Strong proficiency in Microsoft Excel at an intermediate level
• Excellent analytical, research, and problem-solving abilities; ability to learn complex systems

Responsibilities

• Analyze and reconcile employer payroll data.
• Research discrepancies, inconsistencies, missing information, and other data issues to determine causes and resolutions.
• Collaborate with employer staff, MainePERS employees, and auditors to research and resolve data issues.
• Recommend data corrections based on analysis and reconciliation.
• Maintain detailed documentation and tracking of data analysis and proposed corrections.
• Prepare information and progress reports to support management and auditors.
• May verify and approve data corrections processed by others.
• May support other team members with reconciliations of individual employer accounts as needed.

Skills

Analytical thinking

Attention to detail

Research skills

Organizational skills

Communication

Learn complex systems

MS Excel proficiency

Education

Associate’s degree in Accounting or Business

Tools

Microsoft Excel

Job description

If you are unable to complete this application due to a disability, contact this employer to ask for an accommodation or an alternative application process.

Full time ProfessionTechnical Augusta, ME, US

6 days ago Requisition ID: 1109

Salary Range: $28.15 To $30.77 Hourly

Maine Public Employees Retirement System (MainePERS) seeks a Data Reconciliation Associate to join our Employer Reporting team. This position performs essential data analysis and review of payroll information submitted by employers participating in MainePERS defined benefit plans. The Data Reconciliation Associate prepares, analyzes, and reconciles employer payroll data with information maintained in MainePERS systems, researches discrepancies, and recommends corrections to help ensure the accuracy and integrity of member data.

The position works collaboratively with employer staff, MainePERS employees, and internal and external auditors to research data issues and develop appropriate solutions. The work requires strong analytical and organizational skills, attention to detail, and sound judgment when information is missing, incomplete, or lacks sufficient detail.

What You'll Do

• Analyze and reconcile employer payroll data.
• Research discrepancies, inconsistencies, missing information, and other data issues to determine potential causes and appropriate resolutions.
• Collaborate with employer staff, MainePERS employees, and internal and external auditors to research and resolve data issues.
• Recommend data corrections based on the results of analysis and reconciliation.
• Maintain detailed documentation and tracking of data analysis, reconciliation activities, findings, and proposed corrections.
• Prepare information and progress reports to support management, employer staff, and auditors as required.
• May verify and approve data corrections processed by others.
• May support Employer Reporting Account Associates I, II, and III with reconciliations of individual employer accounts as needed.

What Helps You Succeed

• Analytical and problem-solving skills.
• Attention to detail and a commitment to accuracy.
• Strong research skills and the ability to work independently to investigate and resolve data issues.
• Sound judgment when working with incomplete or conflicting information.
• Strong organizational skills and the ability to maintain detailed records and track multiple assignments.
• Clear, professional communication skills and the ability to collaborate effectively with internal and external partners.
• Ability to learn and apply complex systems, policies, procedures, and business processes.
• Proficiency with Microsoft Excel and other Microsoft Office applications.

Why You'll Love Working at MainePERS

At MainePERS, you'll join a collaborative team whose work makes a meaningful difference for Maine's public employees and retirees. We value teamwork, continuous learning, and professional growth while fostering a supportive work environment where employees are encouraged to develop their skills and contribute to improving our services.

QUALIFICATIONS:

Minimum Qualifications:

• Associate’s degree in Accounting or Business with two years of relevant experience in accounting

-OR- any equivalent combination of relevant education and experience.

• Strong technology skills, including proficiency in Microsoft Excel at the intermediate level.

Preferred Qualifications:

• Prior experience analyzing payroll files.

The anticipated starting salary is typically near the minimum of the pay range. Initial placement within the range will be determined based on the successful candidate's relevant education, experience, skills, and other job-related qualifications.

Benefits:We offer an outstanding benefit package including:

• Work-Life Balance – MainePERS provides 13 paid holidays, 12 days of sick leave, 2 days of personal leave, and 12 days of vacation leave annually. Vacation leave accrual increases with years of service.
• Health Insurance Coverage– MainePERS pays for 65%-95% of health insurance based on the employee’s annual salary and person covered (dependent or employee)
• Health Insurance Premium Credit– Participation decreases employee-only premiums by 5%.
• Dental Insurance – MainePERS pays 100% of dental insurance premiums for employees and their dependents
• Vision Insurance – Employee paid
• Defined Benefit Pension Plan– MainePERS contributes 10.2% of pay to pension on behalf of the employee.
• Gym Membership Reimbursement– Employees may receive a wellness reimbursement of up to $300 per calendar year for individual physical fitness activities, gym membership, stress management programs, etc.
• Health and Dependent Care Flexible Spending Accounts– Set aside money pre-tax to help pay for out-of-pocket health care expenses and/or daycare expenses.
• Public Service Student Loan Forgiveness– MainePERS is a qualified employer for this federal program. For more information, visit the Federal Student Aid office.
• Parental leave - Paid parental leave for childbearing and adoption is available to an employee for up to 42 calendar days to support new parents in bonding and caring for a new child. Additionally, unpaid leave may also be available under the Family and Medical Leave Act .
• Voluntary Deferred Compensation – Save additional pre-tax funds for retirement in a 457(b) and 401(a) accounts through payroll deductions.