Business Analyst (11384)

Toronto Transit Commission (TTC); Ontario; Hybrid; CAD 87,000 - 110,000; Full time

Job summary

The Toronto Transit Commission is seeking a Business Analyst to join their Legal Team. This role involves analyzing business processes and user needs to enhance systems and support decision-making through data analytics. The successful candidate will work both independently and collaboratively, applying their expertise in business intelligence tools and data management to drive improvements across the organization. The TTC values diversity and encourages applications from all qualified candidates.

Benefits

Flexible, hybrid work approach

Comprehensive health benefits

Professional development opportunities

Defined pension plan

Qualifications

• University degree or college diploma in a related discipline.
• Extensive experience using SQL and business intelligence tools.
• Demonstrated experience in data analytics and developing dashboards.

Responsibilities

• Review, analyze, and evaluate business processes.
• Coordinate and conduct special projects.
• Perform data analytics and streamline processes.

Skills

Data analytics

Statistical knowledge

Business intelligence tools

Presentation skills

Project management

Education

University degree in Computer Information or Business Administration

Tools

SQL

MicroStrategy

Microsoft Power BI

Tableau

Job description

JOB INFORMATION

Requisition ID: 11384

Number of Vacancies: 1

Department: Legal (20000045) - Investigative Services (30000055)

Salary Information: $87,596.60 - $109,509.40

Pay Scale Group: 8SA

Employment Type: Regular

Weekly Hours: 35 Off Days: Saturday/Sunday Shift: Day

Posted On: June 24, 2025

Last Day to Apply: July 7, 2025

Reports to: Manager of Investigations

The Toronto Transit Commission (TTC), North America's third largest transit system and recognized as one of the top places to work in the GTA has introduced its new 2024-2028 TTC Corporate Plan - Moving Toronto, Connecting Communities which continues the TTC’s legacy of delivering service to hundreds of millions of customers a year. The TTC’s new vision and mission statements also help promote the many environmental, social equity and economic benefits that the TTC provides:

Vision: Moving Toronto towards a more equitable, sustainable, and prosperous future.

Mission: To serve the needs of transit riders by providing a safe, reliable, efficient, and accessible mass public transit service through a seamless integrated network to create access to opportunity for everyone.

The full Plan can be viewed on ttc.ca.

Career Opportunity

We are looking for a Business Analyst to join our Legal Team!

What You Will Do

Reporting to the Manager – Investigative Services you are responsible for reviewing, analyzing and evaluating business processes and user needs to determine system requirements. As Business Analyst, you will coordinate and conduct special projects pertaining to the section’s systems, methods, procedures and organization from initial studies through to documentation and implementation. This may involve working independently or as part of an internal implementation team, as well as with outside consultants and suppliers. You are a data-driven problem solver who will employ advanced statistical knowledge and tools to uncover hidden patterns in large sets of data and answer complex business questions. Additionally, you will review processes throughout the section and determine methods for streamlining work while maintaining or enhancing the information provided to other departments/customers.

KEY OBJECTIVES:

• Assist in the development and maintenance of sectional and/or departmental information systems
• Assist in the system administration of all sectional applications
• Conduct feasibility studies related to sectional systems
• Coordinate the implementation of recommendations:
• Perform data analytics

What Qualifications Do You Bring?

• Your educational background including completion of a university degree or college diploma in a related discipline (i.e. Computer Information or Business Administration), or a combination of education, training, and experience deemed to be equivalent is integral and will contribute to the success in this role.
• Extensive experience using business intelligence tools (e.g. MicroStrategy, Microsoft Power BI, Tableau) and using SQL languages/queries for: building connections, extracting data, and manipulating and integrating data from a variety of data warehouses/databases.
• Demonstrated experience in data analytics, and developing automated dynamic dashboards using SQL, SQL Server, SSIS, Python, R, Power BI, Excel, and MS Access.
• Sound knowledge of database management tools such as Microsoft SQL Management Studio and Oracle SQL Developer.
• Sound knowledge of business administration and practices, and applicable government legislation.
• Comprehensive knowledge of systems analysis and database design concepts and practices as applied to large and small systems.
• Knowledge of system and end user concepts and practices.
• Good understanding of project management concepts and practices.
• Knowledge of end user support functions and data security/audit principles and procedures.
• Knowledge of current office automation technology, PC hardware/software and relevant application.
• Ability to plan, conduct and co-ordinate projects associated with the development, implementation and maintenance of information and database systems.
• Good presentation skills, tact and diplomacy.
• Project management skills.
• Must have or rapidly acquire a comprehensive knowledge of specific report development software (e.g. Crystal Reports).

What We Offer

• Commitment to creating a diverse, equitable and inclusive culture that promotes a sense of belonging and represents and reflects the needs of the communities we serve.
• A flexible, hybrid work approach that allows colleagues to find balance between their professional and personal lives and making the most of the benefits of working remotely and purpose-driven in-person collaboration opportunities.
• One of the great benefits of being a full-time TTC employee is becoming a member of TTC defined pension plan.
• A comprehensive package that covers health, dental, vision and more.
• Support for professional development opportunities for all colleagues through a broad range of learning programs that include in-person and online training, leadership development, and support for colleagues’ well-being.

Our Commitment to EDI

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 LGBTQIA+ 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 Talent Management at [phone]. 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.