Geospatial Solution & System Integration, Specialist

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

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 (e.g. 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.

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)

·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 Network Topology Modeling and Spatial Algorithms Development

·Engineering Assets Management System (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.

At CN, we are dedicated to building North America's safest, most inclusive and sustainable railroad, which includes reflecting the communities in which we operate. Research shows that candidates from underrepresented groups often don't apply unless they feel they fit the job posting at 100%. Even if you don't see yourself in every job requirement listed in a posting, we still encourage you to apply. If you require an accommodation for the recruitment process (including alternate formats of materials, accessible meeting rooms or other accommodations), please reach out to our team at [email protected].

As an equal employment opportunity employer, all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, protected veteran status, and other protected status as required by applicable law. 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.

FAQ
Check here for answers to your CN hiring questions.

Applying for a Job at CN Does CN offer entry-level positions?

Yes, we have many positions ranging from entry to senior levels, both in the field and in corporate and IT functions. All available positions are posted onto our Careers website.

Does CN hire students, interns, and new graduates?

Yes, Internship opportunities are posted onto our Careers website, when available.

What's the best way to apply for a position at CN?

Search and apply for a job on our Careers website. Once you've created a profile you'll be able to apply for additional openings and view the status of your application(s). We do not accept resumes by email, fax or mail.

Can I apply for more than one job at the same time?

Yes, feel free to apply to any jobs you're qualified for.

What is the rehire process for former CN employees?

The application process for a former CN employee is the same as for all other candidates.

Does CN accept foreign applicants?

CN requires that applicants be legally eligible to work in Canada or the US. This includes Citizens, Permanent Residents, or anyone in possession of a work permit with certain conditions. At this time, CN does not provide immigration assistance to foreign applicants.

My Job Application What is my application status?

To see your application status, go to our Careers website and login to your candidate profile. It may take some time before your status is updated, as we receive a high volume of applications on a daily basis. If you are being considered for a job, you will be contacted by a member of our Recruitment Team.

Can I withdraw an application?

Yes, if you change your mind about a particular job, you may withdraw your application at any time. If you've already received a job offer, you can simply decline it.

I completed an Online Assessment, what are my next steps?

The Recruitment Team will notify you by email whether or not you will be moving on to the next step of the recruitment process, based on your online assessment results. If successful, you will be invited to the next available recruitment session hosted in the location you have applied to. Keep in mind that it can take several weeks before a session becomes available.

I was unsuccessful with the online assessment - how long must I wait before I can re-apply?

You will have to wait a period of 6 months before you are eligible to re-apply to a position that requires the same testing.

I am having technical difficulties with the online assessment.

For online assessment troubleshooting and support please contact [email protected] .

I was not selected for a job and would like feedback on my application.

Due to the high number of applications we receive, we cannot provide feedback as to why each candidate was not progressed.

Using our career site How do I create a Careers profile?

Click the Create a Profile button in the upper right-hand corner of our Careers website and complete the form and captcha.

Can I edit a previously submitted cover letters, resumes, and/or documents?

No, once an application has been submitted, you cannot upload additional documents, revise questions, nor replace the existing resume or letters attached to that application.

I forgot my password.

If you forgot your password or need to create a new one, click on the Forgot Password link. Enter your User Name or User ID, and an email containing your password will be sent to you. Be sure to check your inbox, spam, and junk folders for the password recovery email. If you do not receive the password recovery email within 24hrs, contact your Talent Acquisition Advisor directly or send an email to [email protected] .

For all other technical issues

If you are experiencing technical difficulties with our Careers website, send us an email at [email protected] describing the technical issue(s) in detail and provide us with screenshots so that we can better assist you.

#J-18808-Ljbffr