The City of Guelph is a vibrant community with over 120,000 people located in the heart of Southern Ontario, just one hours driving distance from Toronto.  Set in a picturesque natural setting, Guelph is known for its rich architectural heritage, growing economy and excellent quality of life – all good reasons to consider a career in this beautiful city.

Job summary

Resumes are being accepted for the position of Compensation and Data Analyst within the Human Resources department.  Reporting to the HR Manager, Total Rewards and HR Systems, the successful candidate will maintain data security, payroll compliance and system integrity.  Guided by the goals and objectives of the City of Guelph Corporate Administrative Plan and committed to the Corporate Values of integrity, excellence and wellness, the candidate will aid in the achievement of the Community Vision – to be the city that makes a difference.


  • Audit payroll processes and systems to ensure accurate calculations, documentation and authorizations of HR data, such as time and attendance, payroll, pension and benefits
  • Recommend and document leading practices, policies and procedures to achieve strong internal controls, data integrity and security in accordance with City of Guelph policies, procedures and applicable legislation
  • Administer the corporate payroll process, including processing weekly and biweekly payrolls in the absence of the Payroll and Benefits Specialist
  • Conduct account reconciliations, remittances, audits, verification of data and back up processed by other departmental staff
  • Compare actuals and accruals; make adjusting journal entries to maintain accurate financial accounting
  • Analyze and interpret complex financial and statistical HR data
  • Collect data, create ad hoc reports, as well as produce monthly, quarterly and annual reports
  • Produce year-end reporting and T4 documents
  • Ensure effectiveness of interfaces to provide accurate and efficient data processing between JD Edwards, Kronos, WAM, JBS and other systems
  • Provide functional Kronos application support within the organization
  • Administer system updates and conduct system testing to ensure employee data, including attendance, vacation, overtime and pension remittances are calculated in accordance with applicable collective agreement and legislated requirements
  • Recommend opportunities to internal stakeholders to enhance system and operational practices by streamlining business processes to drive organizational effectiveness
  • Liaise with external stakeholders, including Canada Revenue Agency, Ministry of Finance, Ministry of Labour, OMERS and benefit providers on remittances, audits, etc.
  • Create and maintain business forms, training materials, SOPs, user manuals and other documentation relating to HR processes and procedures and communicate to internal stakeholders
  • Participate in annual corporate salary budget preparation, including compensation, HR data surveys and other division projects, including job evaluation and position control management
  • Perform miscellaneous job-related duties as assigned


  • Experience related to the duties above, normally acquired through the completion of post-secondary education in Business (Accounting), Human Resources, or equivalent, completion of Certified Payroll Manager (CPM) certification and/or working toward a professional accounting designation. Candidates with an equivalent combination of education and experience may be considered.
  • Extensive experience working with a human resources information system integrated financial system and strong understanding of payroll, time, attendance and financial accounting in a complex multi-unionized organization, preferably in a municipal setting
  • Advanced time and attendance software knowledge, such as Kronos, including system upgrades, interfaces with other applications such as JD Edwards
  • Experience interpreting collective agreement language
  • Excellent communication skills; ability to communicate complex issues using plain language and communicating with tact and diplomacy while maintaining confidentiality
  • Ability to prioritize multiple tasks and meet challenging deadlines with minimal supervision
  • Excellent organizational, critical thinking, analytical and decision making skills and a keen focus on details
  • Experience with Microsoft Office, including Word, Outlook, PowerPoint and expert level Excel skills; including the ability to create complex spreadsheets using advanced formulas and features
  • Knowledge of relevant workplace and employment legislation such as: Pay Equity Act, Employment Standards Act, Income Tax Act, Pension and Benefit Act and Human Rights Act


$80,189.83 to $100,237.29 per year