Data Analyst

Location: Toronto, ON

*** Mention DataYoshi when applying ***

Requisition ID: 3561
Number of Vacancies: 1.00
Department: Revenue Protection (20000029) - Strategy & Planning (30000517)
Salary Information: $59,677.80 - $74,529.00
Pay Scale Group: 6SA
Employment Type: Regular
Weekly Hours: 35, Off Days: Weekends Shift: Day
Posted On: April 1, 2021
Last Day to Apply: April 8, 2021
Reports to: Business Analyst

2 Full Time positions

Revenue Protection

Special Constable Services

The Toronto Transit Commission (TTC) is North America's third largest transit system and has been recognized as one of the top places to work in the GTA. Guided by a forward-thinking strategic plan, the TTC's vision is to be a transit system that makes Toronto proud. The TTC's recruitment efforts are directly aligned to its mission of providing a reliable, efficient, and integrated bus, streetcar and subway system that draws its high standards of customer care from our rich traditions of safety, service and courtesy.

General Accountability

This position is responsible for developing reports, identifying trends, and providing strategic and analytical support to the department. The incumbent is also responsible for reporting Key Performance Indicators (KPIs) relevant to the work assigned, identifying problem areas and criteria, providing recommendations with the support of research, analysis and reporting methodologies as well as developing and creating various reports for tracking purposes. The position is responsible for the creation, maintenance and data integrity of all databases related to the work, coordinating data collection, data entry and running database audit reports.

Key Job Functions

  • Performs trend and data analysis for the department:
  • Analyzes data to identify patterns and trends, and observe anomalies or discrepancies;
  • Attends management meetings, as required, to review, discuss and make recommendations based on observations, findings, trends, and statistical data;
  • Provides statistical analysis, reports (weekly/monthly/quarterly/annually) and summaries to assist management in creating strategic plans;
  • Provides statistical data entry and analysis on general topics;
  • Receives, codes, sorts and inputs data from multiple sources, including TTC reports, fare inspection data, and Provincial Offence Notices on a timely basis;
  • Liaises with staff within the department as well as other departments at the TTC and outside agencies to discuss report findings;
  • Utilizes mapping technologies (i.e. GIS, spatial analytics, GPS, etc.) to visualize and understand the relationship of geography as it pertains to fare inspection/fare compliance and Provincial Offence Notices
  • Evaluating and monitoring trends of discrimination and systemic barriers to feed into the early warning system.
  • Develops standardized, specialized performance and analytical reports, graphs, maps, and charts for the CEO and other relevant groups (TTC Fare Evasion Project, TTC Board Reports, etc.) in accordance with procedures and standards;
  • Provides monthly KPI charts and graphs for inclusion in the CEO, safety, operational, quarterly, Inspection and compliance reports relevant to the work assignment;
  • Prepares annual reports for the department and other related areas, as assigned and responds to surveys and questionnaires received from external organizations (APTA, CUTA, government agencies, etc.) relevant to the work of the department;
  • Creates and maintains additional databases as needed and performing SQL (Structured Query Language) queries to generate reports and other duties as assigned.
  • Maintains the integrity of data through regular auditing and database monitoring, and by creating, adapting and running database queries and verification tools;
  • Reviews statistical methods and procedures used to obtain data to ensure validity, applicability, efficiency and accuracy of raw data;
  • Ensures processes and procedures for reporting are compliant with multiple standards and legislation, including Provincial, departmental and corporate standards;
  • Verifies that pertinent information is included in sources and captured in the database by liaising with internal staff as well as external contacts
  • Candidate will be required to participate in the TTC’s Customer Service Ambassador Program.


  • Create, document, and manage information and records
  • Gather information and conduct research
  • Maintain documentation and historical records
  • Apply analytical skills
  • Use office technology, software and applications

Education and Experience

Post- secondary school education in computers, business administration or other relevant field, or the equivalent, combined with prior work experience in a similar or related job.

Additional Requirements

  • Comprehensive knowledge of statistical, analytical and research methodologies including ability to identify underlying principles, reasons or facts of information by breaking down information or data into separate parts;
  • Sound knowledge of computers and software applications related to the work such as Crystal Report Writer, ArcGIS, Microstrategy, DMS Sharepoint, Microsoft Word, Excel and Access to manipulate computer databases with proven ability to manage and maintain databases including creating queries and SQL stored procedures and Access reports;
  • Ability to identify measures or indicators of database system performance and identify the actions needed to improve or correct performance, relative to the goals of the database system;
  • Detail oriented; and ability to produce quality work, meet required deadlines and work with minimal supervision;
  • Effective interpersonal, oral and written skills; and presentation and problem solving skills;
  • Sound knowledge of law enforcement principles, law enforcement terminology, the Criminal Code, municipal, provincial, and federal statutes that pertain to the work performed;
  • Must pass background investigation/security checks as required from time to time

The TTC is committed to upholding the values of equity, diversity, anti-racism and inclusion in the delivery of its services and in its workplaces. The TTC is committed to fostering a diverse workforce that is representative of the communities it serves at all levels of the organization, and supports an inclusive environment where diverse employee and community perspectives and experiences bring value to the organization. The TTC encourages applications from all applicants, including members of groups with historical and/or current barriers to equity, including but not limited to, Indigenous, Black and racialized groups, people with disabilities, women and people from the LGBTQ(IA+) community. The TTC values and supports an inclusive and barrier-free recruitment and selection process. Accommodations for applicants are available upon request throughout the recruitment and selection process, including for those who identify as having a disability. Please contact Human Resources – Talent Management at (416) 393-4570. Any information received related to an accommodation will be addressed confidentially.

The TTC’s policy prohibits relatives of current TTC employees from being hired, assigned, transferred or promoted into positions, where there is a conflict of interest due to a relationship. Should you be selected for an interview, you will be required to disclose the name, relationship and position of any relative who is a current TTC employee.

We thank all applicants for their interest but advise only those selected for an interview will be contacted.

*** Mention DataYoshi when applying ***

Offers you may like...

  • HALO Dx

    Application & Data Analyst
    Menlo Park, CA 94025
  • Marvel Marketers

    Marketing Data Analyst - Remote US, UK or Brazil. ...
    Austin, TX 78759
  • JP Systems, Inc.

    Network Data Analyst
    Clifton, VA 20124
  • Tombras

    Data Analyst
    Knoxville, TN 37902
  • SV Academy

    Senior Data Analyst