Data Modeler
2 weeks ago
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 of the Expert 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.
-
Data Modeler
3 weeks ago
Montréal, Canada Canadian National Railway Full timeAt 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...
-
Data Modeler
3 weeks ago
Montréal, Canada Canadian National Railway Full timeAt 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...
-
Data Modeler
3 weeks ago
Montréal, Canada Canadian National Railway Full timeAt 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...
-
Data Modeler
3 weeks ago
Montréal, Canada Canadian National Railway Full timeAt 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...
-
Data Modeler
3 weeks ago
Montréal, Canada Canadian National Railway Full timeAt 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...
-
Data Modeler
3 weeks ago
Montréal, Canada Canadian National Railway Full timeAt 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...
-
Data Modeler
3 weeks ago
Montréal, QC, Canada Canadian National Railway Full timeAt 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...
-
Data Modeler
3 weeks ago
Montréal, QC, Canada Canadian National Railway Full timeAt 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...
-
Data Modeler
3 weeks ago
Montréal, QC, Canada Canadian National Railway Full timeAt 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...
-
Expert Data Modeler
2 weeks ago
Montréal, QC, Canada Canadian National Railway Full timeAt 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...
-
Data Scientist
3 days ago
Montréal, Canada Desjardins Full timeAt Desjardins, we believe in equity, diversity and inclusion. We're committed to welcoming, respecting and valuing people for who they are as individuals, learning from their differences, embracing their uniqueness, and providing a positive workplace for all. At Desjardins, we have zero tolerance for discrimination of any kind. We believe our teams should...
-
Data Scientist
3 days ago
Montréal, Canada Desjardins Full timeAt Desjardins, we believe in equity, diversity and inclusion. We're committed to welcoming, respecting and valuing people for who they are as individuals, learning from their differences, embracing their uniqueness, and providing a positive workplace for all. At Desjardins, we have zero tolerance for discrimination of any kind. We believe our teams should...
-
Credit Risk Modeller
2 weeks ago
Montréal, QC, Canada Desjardins Group Full timeremote type The work arrangement for the position is hybrid work time type Full time The Credit Risk Modelling Department is responsible for developing, monitoring and maintaining the inventory of credit risk models to offer innovative financing products to our members and clients while ensuring Desjardins's long-term viability. As a modeller, you help...
-
Intermediate Hydrogeologist/groundwater Modeller
3 weeks ago
Montréal, Canada BluMetric Environmental Inc. Full time**The Opportunity**: **Key Job Responsibilities**: - Assists in the execution of hydrogeological and water resources management studies including the development of conceptual site models, geological and numerical modelling, applied to projects including proposed, active and abandoned mine sites, landfills, contaminated lands, and others. - Participation...
-
Senior Data Engineer, Data Platform
3 weeks ago
Montréal, QC, Canada Canadian National Railway Full timeBe 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. Are you passionate...
-
Senior Data Engineer, Data Platform
3 weeks ago
Montréal, QC, Canada Canadian National Railway Full timeBe 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. Are you passionate...
-
Senior Data Engineer, Data Platform
3 weeks ago
Montréal, QC, Canada Canadian National Railway Full timeBe 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. Are you passionate...
-
Senior Data Engineer, Data Platform
3 weeks ago
Montréal, QC, Canada Canadian National Railway Full timeBe 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. Are you passionate...
-
Data Scientist
7 days ago
Montréal, QC, Canada IATA Consulting Full timeEmployment Type: Permanent Contract Duration: At IATA, we speak for the airlines of theworld, serving and supporting over 300 of them across all continents. Weare passionate and knowledgeable about the aviation industry, and we strive tomake it safer, smarter, more sustainable and more inclusive. We celebratediversity and inclusion in our workforce, and...
-
Data Scientist
2 weeks ago
Montréal, Canada Ubisoft Full timeCompany Description Ubisoft’s 20,000 team members, working across more than 30 countries around the world, are bound by a common mission to enrich players’ lives with original and memorable gaming experiences. Their commitment and talent have brought to life many acclaimed franchises such as Assassin’s Creed, Far Cry, Watch Dogs, Just Dance, Rainbow...
