Transit Data Management and Systems Integration Specialist (Data Management Systems Integration Specialist)

ABOUT US

Almost 1.2 million residents call York Region home making it one of the largest regions in Canada and the fastest growing with a population thats expected to grow to more than 2 million by 2041. Our geography which is comprised of about 1800 square kilometers over nine different municipalities is as beautiful interesting and diverse as our 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 Canadas 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 Programand corporate discounts and purchase plans for day-to-day products and services.
• Inclusive and Diverse Workforce - Were 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.

WHAT YOULL 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 WERE 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.
• Minimum five (5) years experience providing project implementation analysis and support in data management systems data integrity and security as it relates to transportation technology systems and application development and spatial data creation.
• 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.