Data Records Analyst - Administrative Assistant 2 (AESES) (4869)

Job Posting

Data Records Analyst - Administrative Assistant 2 (AESES)
Organization:  University of Manitoba
Province:  Manitoba
Location:  Winnipeg


Data Records Analyst - Administrative Assistant 2 (AESES)
Continuing Full-Time 35 hours/week, 8:30am-4:30pm, Monday - Friday
Salary Range: $27.10 - $35.42 per hour ($49,322.00 - $64,464.40 per annum)
Proposed Start Date: May 22, 2018 Trial/Probation Period: 840.00 work hours

For more information, please contact:

Kate Plett
180 Extended Ed Complex



  • Responsible for loading the University of Manitoba interface files for each pay period and testing the file to ensure data is reasonable and accurate.
  • Reviews the interface file edit report to ensure new certificates are created. Notes the possible data errors to be reviewed once the file has been loaded into the pension administration system.
  • Ensures salary or hours worked discrepancies are followed up at the HRIS transition meeting or with the department.
  • Ensures that the records have been downloaded and no records were skipped.
  • Performs data checking using Access and Excel to ensure reasonability of data. Checks include contributions, actual pension earnings and actual pension hours.
  • Reviews any errors or inconsistencies with credited service and pensionable earnings on a monthly basis and investigates with the Pension Administrator solutions to the errors.
  • Generates scheduled reports from HRIS following the completion of each pay run.
  • Maintains a log of each pay run and its related description.
  • Prepares and check pay revisions to be sent to Payroll.
  • Runs estimates from the pension administration system for plan members, their spouses and beneficiaries as required.
  • Checks the pension administration system accuracy on enrolment, changes to beneficiary, trustee and marital status.
  • Checks files are ready for final calculation.
  • Ensures that the correct certificate number is being assigned to the correct plan in the pension administration system.
  • Reviews data from HRIS and the pension administration system to generate a list of staff members who must join the Pension Plan as specified in the Pension Benefits Act.
  • Responsible for calculating and reporting the Pension Adjustments (PA) for T4 Reporting.
  • Responsible for producing the annual statements for all the plan members from the pension administration system.
  • Responsible for making appropriate arrangements for the distribution of the statement.
  • Responsible for preparing data files from the pension administration system used by the actuary for the valuation of the Pension Plan.
  • Reconciles data to the financial records.
  • Reviews and responds to data questions from the actuary.
  • Required to work as part of the Pension Administrative Team during peak periods or due to unforeseen absences.
  • Carries out other assigned projects.
  • Works with the Pension Administrator when logic changes due to interface updates are being changed.
  • Assists in preparing documentation for the pension administration system.



  • BSc, BA or B. Comm with a major in mathematics, system administration or business administration is required.


  • Two years directly related experience on a major computerized Human Resources (HR) system is required.
  • Experience in managing and manipulating large volumes of data and managing computerized records is essential.
  • An acceptable equivalent combination of education and experience may be considered.

Skills and Abilities:

  • Comprehensive knowledge and experience in Microsoft office, data base programs are essential.
  • Good mathematical and analytical skills are required.
  • Knowledge of pension plan benefit calculations and administration is preferred.
  • Knowledge of benefits administration and/or HR management as it relates to a large unionized organization, life insurance company or benefits consulting company is preferred.
  • Familiarity with computerized pension system and/or HR system is beneficial.
  • Experience working in a complex unionized environment is beneficial.
  • High energy level is required.
  • Must be self-motivated and capable of organizing and prioritizing large volume of work.
  • Strong communication and interpersonal skills are required.
  • Must be professional, knowledgeable and articulate.
  • Must possess a philosophy consistent with a collaborative, integrated approach to business processes and principles.
  • Satisfactory work record, including satisfactory attendance and punctuality is required.