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

Are you passionate about shaping the foundation of data-driven decision-making? We are seeking a skilled Expert Data Modeler to join our talented team. The role oftheExpert Data Modeler is to lead the collection of business requirements to be translated into efficient data structures, while ensuring data integrity and usability. A core responsibility of this role is to design, implement, and maintain data models that serve as the backbone of our organization's data infrastructure. You will also be a key contributor of a center of excellence to set data design standards for the practice. The Expert Data Modeler brings technical expertise to ensure data integrity, quality and accuracy.

Main Responsibilities

• Understand and translate complex business data and analytics requirements to lead the hands-on creation of conceptual, logical and physical data models
• Lead the definition of source to target mappings to describe data transformations
• Assess and produce data analytics artefacts including data model, mapping, data flows, data lineage, metadata documentation and transformations, ensuring the integration in the technical architecture and the alignment with data quality and governance guidelines
• Perform profiling and data analysis using advance SQL / Python techniques on multiple platforms, including Databricks, Netezza, SQL-Server, Oracle, etc.
• Participate in the delivery and support of data quality, data consolidation and data migration initiatives
• Perform design reviews and improve the effectiveness of data design and management
• Lead the data analytics design practice by defining and maintaining standards and best practices
• Provide guidance, onboarding and mentorship to new data designers
• Lead the troubleshooting of data issues within the business and present solutions and recommendations
• Collaborate with various stakeholders including Architecture, Data Engineers, Product Management, DBAs, Infrastructure and Data Governance teams

Requirements

Education and experience

• Bachelor's degree specializing in Mathematics and Statistics / Computer Science / Business Analytics / or other quantitative field, related degree or equivalent experience
• 10 years and more overall work experience
• Minimum 5 years of data design and data modeling experience
• Strong experience in requirements gathering, process analysis and workflow modeling
• Experience performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement
• Experience in leading and participating in business workshops and business presentations

Skills and Competencies

• Experience with data design tools (Erwin Data Modeler r12.5 or similar version)
• Experience with dimensional modeling and relational database modeling techniques
• Advanced SQL skills to support data profiling, unit testing and data extraction
• Experience in a Data Lake, Data Warehouse/Business Intelligence or relevant data environment
• Proficiency working with Azure Data Lake (ADLS), Azure Data Factory and Databricks
• Experience working with DevOps CI/CD, Azure DevOps or GitHub
• Exposure to data modeling and data architecture best practices
• Expert ability to identify data gaps and assess end-to-end data requirements
• Ability to learn quickly, problem solve/troubleshoot, work independently or in a team
• Excellent verbal and written communication skills and the ability to interact professionally with a diverse group

Assets

• Experience in real time data streaming and loading
• Experience modelling data for data science projects
• Experience working with Scale Agile Methodology (SAFe)
• Experience with semi-structured and unstructured data
• Familiar with Data Lakehouse architecture

This position is posted as a grade LEVEL 7. For internal candidates, note that the grade level of the position may adjust based on the employee's experience.

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.

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

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.

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