At CN, we work together to move our company-and North America-forward. Be part of our Information & Technology (I&T) team, a critical piece of the engine that keeps us in motion. From enterprise architecture to operational technology, our teams use the agile methodology to automate and digitize our railroad ensuring our operations run optimally and safely and our employees can focus on value-added tasks. You will be able to develop your skills and career in our close-knit, safety-focused culture working together as ONE TEAM. The careers we offer are meaningful because the work we do matters. Join us!

Job Summary

The Specialist, Geospatial Solution and System Integration is responsible for working on complex projects such as Enhance Train Control (ETC), Positive Train Control (PTC), Energy Management and Autonomous Track Inspection Program (ATIP) where multiple solution areas as well as major components and technology are involved. The role is accountable for developing, maintaining and applying solutions to guarantee Geographic Information System (GIS) data quality, integrity, synchronization with other system and for the administration and design of all the data quality monitoring system (e.g., spatial and non-spatial) from delivery and service perspective. The incumbent develops optimal validations, data conversion and transformations scripts, communicates any issues or defects identified by the GIS data quality monitoring system and propose solution to solves and identify them as well as produces the appropriate documentation to effectively communicate with appropriate parties.

Main Responsibilities

Geospatial Data Development

Support and collaborate with Architecture and Project Management to define solution and high-level plan

Propose optimal solutions using GIS existing technology stacks that meet business requirements

Support the GIS Experts team with database and Extract, Transform, Load (ETL) development requests

Spatial Data Development Best Practice and Monitoring

Cultivate, decimate and implement functional policies, procedures and best practices

Ensure accuracy of all the spatial reports deployed to different business units

Automate the issues reports and assignments to proper data stakeholders

Support of the centralized GIS data integrity and system synchronization monitoring dashboard

Geospatial Data Development Testing

Coordinate GIS business rules test activities with the various specialists and satellite teams

Conduct unit, functional and integration testing

Prepare test cases as well as scenarios and test data

Geospatial Data Development Performance

Ensure performance and sustainability of all the spatial reports deployed to the different business units

Apply and ensure compliance with all applicable Information and Technology (I&T) standards (e.g., Code quality, Security, Architecture, Project Delivery Methodology, Sarbanes-Oxley (SOX

Active participation in various projects meeting

Working Conditions

The role has standard working conditions in an office environment with a regular workweek from Monday to Friday. Due to the nature of the role, the incumbent must be able to meet tight deadlines, handle pressure and stress.

Requirements

Experience

Minimum 10 years of experience with Oracle technology

Minimum 7 years of experience with Structured Query Language (SQL) and Procedural Language - Structured Query Language (PL-SQL)

Minimum 4 years of experience with Feature Manipulation Engine (FME)

Experience with Topological Network Modelling

Experience with GIS technical environment and configuration

Experience in geomatics, system development and optimization

Ability to develop and maintain linear reference model and GIS functionality and concepts in Oracle Spatial (e.g. Spatial Analysis, linear referencing system)

Experience in the integration of custom software solutions over full project lifecycle

Experience adhering to standard systems and data security protocols

Experience in Railroad, Transportation, and Engineering

Education/Certification/Designation

GIS or I&T Technical diploma, certification or equivalent experiences

Bachelor's Degree in Geomatics, Geodesy or Geomatics Engineering

Master's Degree in Computer Science or GIS

Any designation for these above would be considered as an asset

Competencies

Collaborates with others and shares information

Identifies potential safety and security risks

Innovates

Identifies needs and solves problems to create value for all stakeholders

Sets direction and inspires others

Communicates with impact

Demonstrates agility and drives change

Develops self and others

Technical Skills/Knowledge

Knowledge of Agile methodology

Knowledge of GIS Linear Referencing System (LRS) Development

Knowledge of GIS Network Topology Modelling and Spatial Algorithms Development

Knowledge of Engineering Assets Management System

Any knowledge for any of the above would be considered as an asset

About CN

CN is a world-class transportation leader and trade-enabler. Essential to the economy, to the customers, and to the communities it serves, CN safely transports more than 300 million tons of natural resources, manufactured products, and finished goods throughout North America every year. As the only railroad connecting Canada's Eastern and Western coasts with the Southern tip of the U.S. through a 19,500 mile rail network, CN and its affiliates have been contributing to community prosperity and sustainable trade since 1919. CN is committed to programs supporting social responsibility and environmental stewardship. At CN, we work as ONE TEAM, focused on safety, sustainability and our customers, providing operational and supply chain excellence to deliver results.

CN requires that all employees be fully vaccinated against COVID-19 and provide proof thereof as a condition of employment. The Company's vaccination mandate extends to employees of our wholly owned subsidiaries as well as CN's contractors, consultants, agents and suppliers and anyone who accesses CN properties in Canada.

CN is an employment equity employer and we encourage all qualified candidates to apply. We thank all applicants for their interest, however, only candidates under consideration will be contacted. Please monitor your email on a regular basis, as communication is primarily made through email.