JOB INFORMATION Requisition ID: 10783 Number of Vacancies: 1 Department: Business Management & Performance (20001216) - Revenue Accounting & Ridership Analytics (30000075) Salary Information: $66,339.00 - $82,846.40 Pay Scale Group: 6SA Employment Type: Regular -Hybrid Weekly Hours: 35, Off Days: Saturday & Sunday Shift: Day Posted On: February 7, 2025 Last Day to Apply: February 17, 2025 Reports to: Senior Data Analyst 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 have a great opportunity in our Finance Department. We are currently seeking a talented and experienced Data Analyst to join our team. What You Will Do You will support the development of reports, identification of trends, and provision of statistical information, in order to ensure accuracy and timeliness in capturing TTC vehicle kilometres and service hours. In this role you will coordinate data collection, data entry and the running of database audit reports; develop accurate and timely weekly, monthly, yearly reports; supports period-end activities; provides ad-hoc statistical information and analysis of TTC vehicle mileage and service hours for internal and external stakeholders; and supports the Senior Data Analyst on automation, process improvement and data analytics projects related to vehicle kilometres and service hours. You will review and analyze vehicle mileage and service hours information from divisions, payroll, and internal staff to ensure accuracy and timeliness of data. Liaise with division management to correct and improve quality of data. Review daily edits, daily uploads, weekly balances, and period end adjustments (charter, outside metro contracted services, modal time) of vehicle kilometres and service hours information. As a TTC employee, you will be responsible for promoting a respectful work and service environment that supports diversity, inclusion, and is free from harassment and discrimination. You will provide leadership in the development and implementation of inclusive and accessible policies, programs and/or services for employees and customers in accordance with TTC's commitments and obligations under the Ontario Human Rights Code (OHRC) and Related Orders, the Accessibility for Ontarians with Disabilities Act (AODA), and TTC's policies. You will also be participating in the TTC Customer Service Ambassador Program. What Qualifications Do You Bring? A University Degree, or College Diploma in a related discipline (Business Administration, Computer Science, Data Science, Economics, Mathematics, Statistics), along with relevant experience, or a combination of education, training and experience deemed to be equivalent Enrollment in or possession of a recognized accounting designation (e.g. CPA) is an asset. Strong knowledge in MS Excel, Excel VBA, PowerPoint, and Word, Strong quantitative, problem solving skills and abilities to discover interconnectivities between various sources of data and observations. Working knowledge in data manipulation, data analytics and business intelligence. Ability to develop measurable and relevant targets / benchmarks to monitor and report on organizational progress towards corporate and/or business plans, priorities & objectives. Ability to develop effective relationships both internally and externally. Excellent written and verbal communication skills, particularly in preparing reports with complex technical information for management team. Ability to manage competing priorities and demands in a rapidly changing environment. Knowledge of and experience with public sector organizations or transit agencies is an asset. Demonstrated work experience with Power BI is an asset. Demonstrated work experience with MicroStrategy is an asset. Demonstrated work experience with SQL is an asset. What Skills Do You Bring? Perform relevant mathematical calculations and statistical analyses Maintain documentation and historical records Use office technology, software and applications Apply analytical skills Demonstrate specialized expertise and knowledge in the assigned field Demonstrate appropriate and effective interpersonal communications through various media 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. You receive 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. 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 (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. Save