Canadian National Railway Hiring for Analyst, SAP Data Conversion and Governance Full Time

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 Analyst, SAP Data Conversion and Governance contributes to the SAP ecosystem roadmap by planning, executing and providing expertise on data-related activities. The role is instrumental as CN is currently undertaking a large multi-year business transformation program triggered by a SAP ECC to a SAP S/4 HANA product migration.

The incumbent works within a multi-disciplinary team and participates in a variety of data activities, namely: profiling, quality assessment and cleansing of master and transactional data objects, including establishment of data cleansing strategies and their implementation; master data mapping, transformation and enrichment, to account for new SAP product data models and business transformation requirements; and data governance and management tasks on approval workflows, configurations and processes to ensure data objects maintain compliance to CN quality standards throughout their lifecycle.

The incumbent contributes to data validation runs, troubleshooting, data reconciliation and identification of corrective actions prior to production migrations.

The position helps develop skills and experience in setting up and managing best-in-class data pipelines that are becoming essential building block in industries adopting data-centric digital transformation approaches.

Main Responsibilities

Data Profiling and Cleansing – Data-Related Tasks on the “As-Is” Environment – 30%

Participates in data objects identification and business rules profiling

Performs data quality assessment and quality metrics ing

Participates in manual/automated data object cleansing strategies and their implementation

Collaborates to the iterative post-cleansing validation and implementation of corrective measures

Leverages off-the-shelf and specialized tools to carry out tasks

Data Mapping and Transformation – Data-Related Tasks on the “To-Be” Environment – 40%

Participates in identification and design of functional data mapping, transformation and enrichment activities and documentation according to the business process re-engineering efforts and new S/4 HANA data structures

Implements sandbox solutions to assess data mapping and transformation methods, including algorithms

Performs iterative validation runs and implement corrective measures on conversions

Leverages off-the-shelf and specialized tools and conversion platforms to carry out tasks

Data Governance and Management – Data-Related Tasks on the Data Lifecycle and Enhancements – 30%

Identifies, implements, and validates governance workflow and data business rules requirements for master data management, in conjunction with business owners

Takes part in data quality assessment on target systems

Implements data governance roadmap and strategy on specialized data management tools and platforms

Participates in functional designs and documentation, system configuration, and validation

Maps enterprise-level data governance requirements into SAP landscape

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

Managing and Handling Enterprise Data

Between 1 to 3 years of experience in managing and handling enterprise data

Education/Certification/Designation

Bachelor’s Degree in a technical or business field, with an interest in data management

Bachelor’s Degree in Business Analytics, Mathematics, Statistics, Data Science or Engineering*

• Any designation for these above would be considered as an asset

Competencies

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

Applies analytical thinking

Innovates through problem solving

Knows the business and stays current with industry trends to elevate expertise and work

Demonstrates organizational abilities

Collaborates with key internal stakeholders to enable higher productivity

Works independently with little supervision

Technical Skills/Knowledge

Strong interest in managing and validating data, understanding its attributes, characteristics and business value.

Hands-on experience in planning and executing general Extract-Transform-Load (ETL) data tasks*

Experience with Enterprise Resource Planning (ERP) systems, in particular SAP (SAP ECC, SAP S/4 HANA)*

Strong interest in business processes and the way data interrelates to those processes

Interest in exploring data, performing investigation and analysis, and applying resolution and validation in complex data sets

Knowledge of Excel or equivalent productivity tools

Ability and interest in developing advanced user knowledge of specialized data management platforms and tools such as Syniti Advanced Data Migration (ADM), SAP Master Data Governance (MDG), SAP Utopia, SAP Asset Information Workbench (AIW)

Ability to present and communicate results clearly

Knowledge of Structured Query Language (SQL) statements and scripting, including SQL Server Management Studio*

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

Organizational Impact

Decision Making & Impacts

The position performs data-centric tasks that are foundational to the SAP ecosystem roadmap and lifecycle

Level of Interaction/Influence

The Analyst, SAP Data Conversion and Governance interacts with business and Information and Technology (I&T) data experts, Coordinators, Data Technology Specialists, Solution Architects, enterprise-level data governance teams, as well as working closely with their business and functional counterparts in Finance, Procurement, Supply Management, Mechanical and Engineering organizations.

Employees Supervised/Organizational Structure

The Analyst, SAP Data Conversion and Governance s to the Senior Manager, SAP S/4 HANA Transformation, Data Governance and Migration, Information and Technology. The role has no supervisory responsibilities.

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 in Canada 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.

For internal candidates, note that the grade level of the position will depend on the employee’s experience.

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.