Specialist, Geospatial Solution & System Integration

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.