Data Analyst


Location: Toronto, Ontario, Canada 

Type: Contract (or Secondment) – 12 months with possibility of extension 

Location: Downtown Toronto location at University and Dundas, near St. Patrick Station (180 Dundas West, Suite 1902) – Hybrid work model to start 

Salary Range:  $60,000 to $70,000  

About the Employer 

Established in 2011, the Ontario Council on Articulation and Transfer (ONCAT) was created to enhance academic pathways and reduce barriers for students looking to transfer among Ontario's publicly funded colleges, universities and Indigenous institutes. As a member organization, we work with those institutions to develop transfer credit policies and practices to ease student mobility. As a non-profit organization created and funded by the Government of Ontario, ONCAT works with postsecondary education institutions to build a seamless system for transfer credit in Ontario and support student mobility.  

ONCAT staff are currently working a hybrid model (up to 3 days per week in the office) as we monitor Toronto Public Health regulations. 

About the Data Analytics Position 

ONCAT is looking for someone passionate about data analytics, drawing key insights, and building dashboards and metrics by using various post-secondary education data sources. The Data Analyst contributes to ONCAT’s strategic priorities and works cross-functionally under the supervision of ONCAT’s Senior Data Analyst. The incumbent will analyze and summarize data managed by ONCAT and other relevant data sources. They will lead metric reporting initiatives and work collaboratively with researchers and ONCAT staff to implement reports and dashboards. The Data Analyst will present preliminary metrics and dashboard prototypes to stakeholder groups and assist with other research and data related functions as needed. 

Key Responsibilities 

Jurisdictional Scans and Best Practices Research 

  • Scan relevant studies related to post-secondary education transfer student demand and outcome measures. Document and share best practices in metrics design. 

Data Preparation and Analysis 

  • Support the development of data extraction and translation programs for variety of data sources. 

  • Explore and analyze the extracted data. Identify and document data issues. Recommend solutions to address data gaps. 

  • Produce exception reports and facilitate data cleaning processes. 

Metric and Dashboard Implementation 

  • Support the design of metrics, interim measures, and develop reports for ONCAT’s strategic priorities.  

  • Collaborate with the research team in the implementation of metrics/interim measures and related reports. 

  • Support dashboard design discussion and implementation using Power BI. 

  • Prepare presentation and communicate to internal and external stakeholders. 

Education and Experience 

  • A minimum of three (3) to five (5) years of relevant data analytics and reporting experience using tools such as SAS, SPSS, Stata or R. 

  • Some experience working with post-secondary institutional data/Statistics Canada Post-secondary Student Information System (PSIS) would be an asset. 

  • Experience working with large scale data sets with both structured and un-structured data. 

  •  In-depth experience with database platforms and data manipulation tools: 

  • Relational databases (MySQL, MS SQL Server) and SQL tools, Microsoft Excel, VBA & Pivot Table, Dashboard tools such as Tableau or Power BI 

  • Proficiency in Microsoft Office Suite (Word, Excel, Access, Power point, etc.) 

  • Experience with diagram software e.g. Visio/Lucid Chart 

  • Ability to synthesize data into meaningful reports and identify trends. 

  • Strong written and verbal communication skills, with presentation experience to non-technical audience. 

  • Able to work independently, with minimal oversight, while meeting project deadlines. 

  • Familiarity with conducting literature scans for higher education transfer related topics. 

  • Undergraduate degree in Data Management, Statistics or a related field, Master’s degree may be considered an asset. 

Application Instructions 

Please email your resume and cover letter to and use the position title as your subject line.  

The deadline to apply is January 14th 11:59pm EST. Late applications will not be accepted. We thank you for your interest. Only those selected for further screening or an interview will be contacted. 

Additional testing may be required. 

ONCAT is committed to providing an inclusive and barrier free recruitment process to applicants with accessibility needs in accordance with the Ontario Human Rights Code and the Accessibility for Ontarians with Disabilities Act (AODA). If you require accommodation during this process, please inform ONCAT of your requirements. 

ONCAT welcomes qualified applications from persons with disabilities, Indigenous Peoples from North America, including First Nations, Métis and Inuit peoples, visible minorities (racialized) persons, and those who identify as women and/or 2SLGBTQ+. ONCAT supports an equitable, diverse and inclusive workplace.  

ONCAT requires all employees to be fully vaccinated against COVID-19, subject to medical and human rights exemptions, in accordance with all applicable laws and regulations.