Sign In or Sign Up

System Analyst (J.O# 10934ie)

Job Opportunity Program
Toronto, Ontario

Last Day to Apply: September 14, 2018
Employment Type: Full Time





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.

We are currently seeking a Systems Analyst to work as part of the Business Intelligence and Analytics team.


  • Working as part of the Enterprise Data delivery team to develop Data Warehouse and Business Intelligence solutions
  • Formulating statements of business and system requirements, performing detailed analyses, preparing and reviewing detailed systems documentation and functional specifications
  • Designing/developing sub-systems that are part of a larger more complex system
  • Providing support in resolving operational problems and technical issues encountered in running production systems
  • Ensuring operational business intelligence solutions are supported, maintained and modified, as required throughout their lifecycle
  • Assisting in the modelling/creation of MicroStrategy dashboards and data schemas to facilitate business intelligence reporting
  • Utilizing excellent interpersonal skills to provide on-going support and occasional training to a large group of end-users
  • Maintaining existing and/or creating applications and utilities
  • Communicating/Managing and working with 3rd party vendor and acting as a liaison between vendor and end-users
  • Creating, modifying and implementing reports using Microstrategy, Business Objects Enterprise and in-house developed reporting interfaces
  • Provide front-line technical support in resolving day-to-day system issues, participate in system upgrades/updates and new system development,
  • Providing 7x24 on call production support during evening, weekends and statutory holidays to support critical transit applications, as required
  • Ability to work shift work and work outside regular business hours, as required
  • Participation in the TTC Customer Service Ambassador Program
  • Treating passengers and employees with respect and dignity and ensuring the needs of passengers and employees with disabilities are accommodated and/or addressed (if applicable and within their area of responsibility) in accordance with the Ontario Human Rights Code and Related Orders so that they can fully benefit from the TTC as a service-provider and an employer


  • A degree in Computer Science or related discipline, combined with related experience in systems development and system administration supporting and administrating Enterprise wide software systems
  • Sound knowledge and hands-on experience working with Microsoft SQL Server 2008 or later (SSIS, SSAS), Microsoft Visual Studio 2012 or later and Microsoft Team Foundation Services
  • Experience defining, creating, maintaining and enhancing solutions developed in MicroStrategy Business Intelligence tool
  • Experience working in a team delivering data warehouse and/or business intelligence solutions
  • Strong experience programming in Microsoft SQL Server T-SQL (queries, triggers, views, stored procedures, etc.)
  • Experience developing ETL solutions using Microsoft SQL Server Integration Services (SSIS)
  • Sound knowledge of relational database solutions and associated data modelling techniques
  • Strong understanding of data analytics approaches and techniques as well as data quality approaches and techniques
  • Knowledge and experience of all aspects of the software development lifecycle and the Agile methodology for software development
  • Sound judgment, excellent effective verbal and written communication skills, and strong analytical and problem-solving skills
  • Skilled in building customer rapport and confidence by providing exceptional end-user service and being end-user focused
  • You must have or rapidly acquire a comprehensive knowledge of the Ontario Human Rights Code and Related Orders including disability accommodation and accessibility requirements pertaining to passengers and employees       

Anual Salary Range: $80,007.20 - $100,027.20 (Level 9) - 35 Hour Work Week

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

At the Toronto Transit Commission (TTC), we place a high value on establishing a workplace where people are challenged and respected every day, and we keep Toronto moving with a dedication to service, safety and convenience that is unparalleled in our industry. We invite you to join our team in delivering on our commitment to creating a transit system that makes Toronto proud.

Hiring and selection preferences are not given in the employment of an employee’s relatives. Relatives of current TTC employees cannot be hired, assigned transferred or promoted into positions, where there is a potential conflict of interest due to relationship. If you are qualified for the position for which you are applying, you will be required to disclose the name, relationship, and position of any relative who is a current TTC employee at the employment interview.

The TTC is committed to fostering a positive workplace culture with a workforce that is representative of the communities it serves. Committed to the principles of diversity and inclusion, the TTC encourages applications from all qualified applicants. Accommodation is available for applicants, including those with disabilities, throughout the recruitment process. Please contact Human Resource- Employment Services at (416) 393-4570.

Do you need technical assistance with your job application? Please refer to this or .

Skip to the main content