Data Reporting Specialist (Job 291)

Submission deadline: November 17, 2019
One-year contract with benefits

Located in Guelph, the Ontario Universities’ Application Centre (OUAC) processes applications for admission to undergraduate, law, medical, rehabilitation sciences and teacher education programs for Ontario’s universities. We provide a progressive and supportive working environment for our employees, along with a competitive salary and comprehensive benefits. Read more about the OUAC.

The OUAC is an equal opportunity employer with equitable and accessible employment practices, based on the principles specified in Ontario legislation (Human Rights Code and Accessibility for Ontarians with Disabilities Act). Accommodations for job applicants with disabilities are available upon request.

If you are willing to learn and eager to play a supporting role in helping people start a new chapter in their life, we would love to hear from you!

The OUAC is seeking a Data Reporting Specialist to create and maintain reports from different databases and/or data repositories that utilize data visualization/reporting tools to efficiently and effectively address the data and decision-making needs of our internal and external stakeholders.

Job Responsibilities:

  • Consult with stakeholders to determine data and/or reporting needs
  • Extract and integrate new and existing data sources
  • Write reports and deliver data using advanced queries/scripts in SQL
  • Maintain, report on and provide insights using the output (i.e., data) from web analytics tools that strategically informs the OUAC’s understanding of how applicants interact with our websites
  • Promote standardization across the various requests for information to ensure efficiency and quality
  • Document data processes and project details in the documentation system
  • Develop and build reports using reporting tools that deliver accurate and effective information to diverse audiences

Qualifications Sought:

  • A university degree in a related discipline
  • Minimum of 5 years of progressive work experience
  • Strong knowledge and proficient use of PS Query, SQL and complex SQL queries
  • Strong experience with web analytics tools, including working with data sets for reporting and analysis
  • Strong knowledge of and experience with data visualization/reporting tools

Abilities/Skills for the Ideal Candidate:

  • Ability to translate user needs into detailed technical specifications
  • Ability to use various tools to explore, troubleshoot and verify data
  • Ability to standardize, document and replicate data processes
  • Ability to collect, organize, analyze and disseminate significant amounts of information with attention to detail and accuracy
  • Hands-on experience working with data/reports from web analytics tools
  • Experience providing effective support and customer service to data end-users

Qualifications Considered an Asset:

  • Any programming skills, e.g., Oracle development tools, are considered an asset
  • Knowledge of the Ontario university sector is considered an asset

Qualified applicants are invited to apply to “Job 291” via email by Sunday, November 17, 2019, to: hroffice@ouac.on.ca.

Submit your cover letter and resumé as 1 file (PDF preferred).

We thank all applicants for applying; however, only candidates selected for an interview will be contacted.