Geospatial Solution

According to the document: In complex projects such as ETC (Enhanced Train Control), PTC (Positive Train Control), and ATIP (Autonomous Track Inspection Program), where multiple solution areas, major components, and technology are involved, this role is responsible for developing, maintaining, and applying solutions to guarantee GIS data quality, integrity, and synchronization with other systems. The Geospatial Data Intelligence Developer Specialist is responsible for the administration and design of the data quality monitoring system (spatial and non-spatial) from a delivery and service perspective. This person is responsible for developing optimal validations, data conversion, and transformation scripts, communicating any issues or defects identified by the GIS data quality monitoring system, and proposing solutions to solve and identify them. The Geospatial Data Intelligence Developer Specialist produces appropriate documentation to effectively communicate with appropriate parties and acts as the glue between all the players in a complex and multi-layer project team by proposing and developing optimal solutions in collaboration with the GIS Experts team. This person must have experience in ETL & spatial ETL, SQL, and Geospatial Data integration and design, as well as a good understanding of GIS concepts.

Main Responsibilities

Geospatial Data Design & Integration: leading role

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

·Propose optimal solution using GIS existing technology stacks that meet business requirements.

·Support the GIS Experts team with datab2ase and ETL development requests.

Spatial Data Design & Integration: Best Practice & Monitoring

·Cultivate, decimate, and enforce 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 & System synchronization Monitoring Dashboard.

Geospatial Data Design & Integration: Testing

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

·Conduct unit, functional and integration testing.

·Prepare test cases/scenarios and test data.

Geospatial Data Design & Integration: Performance

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

·Apply and ensure compliance with all applicable CN (Canadian National) IT (Information & Technology) standards (Code quality, Security, Architecture, Project Delivery Methodology, SOX, etc.)

·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 manage stress.

Requirements

Experience

·Minimum 4 years' experience with FME (Feature Manipulation Engine) or other equivalent ETL.

·Minimum 4 years' experience with SQL (PL-SQL is an asset).

·Minimum 2 years' experience with Oracle Spatial technology.

·Experience with Topological Network Modeling.

·Experience with GIS technical environment and configuration, effective GIS asset management system design, operation, and maintenance.

·Experience in geomatics, system development and optimization.

·Ability to develop and maintain linear reference model (LRM and LRS) and GIS functionality and concepts in Oracle Spatial ( Spatial Analysis, linear referencing system, etc.)

·Experience in the integration of custom software solutions over full project lifecycle (architecture – design – build – integration – testing – deployment – support).

·Experience adhering to standard systems and data security protocols.

· Assess and leverage as applicable existing IT infrastructure.

·Analytical/problem solving skills

Education/Certification/Designation

·GIS/IT Technical diploma, certification, or equivalent experiences.

·Bachelor of Geomatics, geodesy, or Geomatics Engineering (asset)

·Master Level Degree in computer science, Geographical Information system (GIS) (asset)

Competencies

·Share information and demonstrate good collaboration skills

·Addresses risks in a timely manner to eliminate them

·Innovates through problem solving

·Inspires others with impactful communications and adapts to the audience through speech and writing

·Demonstrates good judgment in decision making and makes difficult and timely decisions

·Prioritize individual development and continuous learning

·Deals with pressure and change by staying calm to quickly adapt to changes

·Builds a relationship with clients and provides valuable services

Technical Skills/Knowledge

·Railroad and/or Engineering & Transportation business Experiences (Asset)

·SQL and PL-SQL Development

·Agile methodology

·Oracle Spatial Technology and Spatial Algorithms

·GIS Linear Referencing System (LRS) Development

·GIS Network Topology Modeling and Spatial Algorithms Development

·Engineering Assets Management System (Asset)