GIS Advisor

Job Summary:

The focus of this position is to design, develop, and implement data workflows to ensure that LP pipeline assets are maintained in a centralized GeoSpatial Database. The position will support LP pipeline’s development and implementation of a centralized GIS database   through the performance of data entry, data maintenance, and data quality control tasks.  This position is responsible for collaborative efforts to support pipeline asset data consumption, analysis and visualization as well as the creation of processes that may automate data operation processes.

Duties:

DATA MAINTENANCE AND SUPPORT:

• Coordinate the management of pipeline asset data within Enbridge LP pipeline data model (PODS 6.0) for all LP assets.
• Support spatialization of MS SQL Server data using ESRI’s ArcSDE.
• Responsible for quality control (QC) and management of change (MOC) processes for pipeline asset data.
• Maintain and publish pipeline database schema for project integration to improve and streamline project data collection
• Support the development of workflows to extract and integrate data to populate LP pipeline database.
• Drive continuous improvements for data, applications, and systems for LP GIS.
• Maintain pipeline linear referencing systems (both engineering and continuous).
• Derive and maintain linear referencing event tables as needed by LP GIS and stakeholders.
• Use database maintainer tools to update and modify centralized GIS database

DATA CONSUMPTION:

• Create WMS and WFS for data consumption to approved stakeholders
• Design and maintain web viewer/portals using ESRI’s ArcServer and/or Portal for GIS
• Generate maps singularly and also as series maps to publish the LP pipeline assets
• Collaborate with stakeholders on interoperability between LP pipeline database and other Enbridge systems
• Design and implement processes within the constraints of Enbridge IT protocols as well as standard industry best practices
• Perform data analysis as needed by the LP stakeholders.
• Generate alignment style sheets using either GIS or CAD technology

Qualifications:

• Bachelor’s degree in GIS, Geography, Computer Science, Statistics or a related field
• Minimum of 4 years’ experience in a GIS analyst, data modeling,  or developer position in an enterprise environment using the ESRI software suite (ArcMap, ArcServer, ArcSDE, ArcGIS online), preferred
• Minimum of 2 years of in the pipeline or transmission  industry
• At least 1 year of database management experience using MS SQL Server and ArcSDE, preferred
• Experience with the design, creation, and management of GIS web viewers using ArcServer and/or Portal for GIS
• Understanding of the PODS data model (version 4.1 or higher)
• Experience with data entry and bulk table loading either directly into an RDMS or with VAR tools
• Experience with automated alignment sheet generation in GIS or CAD
• Ability to troubleshoot and problem solve in GIS and database environments
• Knowledge of the pipeline industry’s best practices for GIS and database development
• Ability to work well independently and also in a collaborative team environment
• Ability to communicate effectively both verbally and in writing
• Ability to legally travel and work in both Canada and the US

Apply online at link included