Transit Data Management and Systems Integration Specialist

ABOUT US Almost million residents call York Region home, making it one of the largest regions in Canada – and the fastest growing with a population that’s expected to grow to more than 2 million by 2041. Our geography, which is comprised of about 1,800 square kilometers over nine different municipalities, is as beautiful, interesting and diverse as our people. Local government is organized in a two-tier structure and we work together with our local municipalities to provide residents and businesses access to a broad selection of services and resources. WHAT WE OFFER Consistently named one of Canada’s Best Employers by Forbes, we offer a collaborative, progressive workplace that takes pride in our organizational culture and is committed to living The 13+ Factors of Psychological Health and Safety in the Workplace – aligned with our vision to create strong, caring and safe communities both within and outside our walls. Defined Benefit Pension Program - With the Ontario Municipality Employees Retirement System (OMERS) defined benefit pension plan, you can confidently retire knowing that you will have income for life. Eligibility from date of hire as a full-time employee and includes employer-matched contributions. Employer of Choice - Recognized as the highest-ranking government employer in Canada and fourth overall among 300 organizations. Benefits and Wellness - Employees and their loved ones have access to a comprehensive employer-paid benefits plan that includes extended health, dental and life insurance, access to a 24/7 Employee and Family Assistance Program and corporate discounts and purchase plans for day-to-day products and services. Inclusive and Diverse Workforce - We’re committed to fostering an environment that celebrates all dimensions of diversity and ensures everyone can develop to their full potential, participate freely in society and live with respect, dignity and freedom from discrimination. Our robust Inclusion, Diversity, Equity and Accessibility program continues to grow, and has been recognized by the United Nations and many other organizations for our leadership. ABOUT THE ROLE Reporting to the Program Manager, Transit Management Systems, is responsible for extracting, evaluating, analyzing and researching data generated from the various components of the Transportation Services Data Warehouse and Business Intelligence System; preparing statistical and narrative reports; collecting, analyzing, interpreting, summarizing, creating and maintaining data files to support systems software configurations as related to the Transit Management Systems and Roads Operations Systems, Corporate software and Data Warehouse & Business Intelligence; supporting the installations of hardware and software upgrades and new equipment configurations; and providing system support for the development, implementation, operation and maintenance of specialized automated systems and related applications, as required. WHAT YOU'LL BE DOING Researches new technologies, future systems, software, and hardware components related to Transit Management Systems (TMS) and other technology applications as it relates to corporate systems, databases and platforms.  Provides Data Warehouse and Business Intelligence (DWBI) system services, by analysing data requirements. Designs, develops, implements and synchronizes Transit technology applications, relational database systems and creates linkages to those technology systems. Manages projects and leads project teams, ensuring the timely delivery of products and services, and tracks project activities, time lines and project deliverables. Assists management with all technology related project invoices, work orders and change request documents. Liaises with internal staff, providing systems expertise and support to ensure consistent and effective systems performance; shares information regarding initiatives and other best practices with Branch and Departmental staff.  Gathers data relative to design and application workflow; works with Branch and Departmental staff, ITS and other stakeholders to recommend system prototypes for user consultation, and contributes to the design, development, testing, modification, documentation and implementation of systems. Performs other duties, as assigned, in accordance with Branch and Department objectives.  WHAT WE'RE LOOKING FOR Successful completion of a Community College Diploma in Information Technology, Computer Sciences or related field or approved equivalent combination of education and experience. Demonstrated knowledge of transportation technology industry and transportation related systems and applications. Demonstrated knowledge and experience of systems development life cycle processes using databases and programming languages. Experience in manipulating and analyzing data using VBA, Oracle (PL/SQL) and MSSQL (T-SQL). Experience in developing applications using development tools (MS Visual Studio, Java Developer, SQL and Oracle Application Express and Salesforce Apex). Computer literacy utilizing MS Office software applications.  Ability to research, document, and present technical information for management. Ability to analyze and resolve technical problems.  Demonstrated ability to coordinate, plan, implement and evaluate programs for customer service. Experience in project management and leading project teams. Knowledge of trends in the use of current technology as it relates to data management systems.