Data Modeller

2 months ago

Montréal, Canada Canadian National Railway 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**

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

**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

  • Data Modeler

    2 months ago

    Montréal, Canada Canadian National Railway 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...

  • Data Modeler

    2 months ago

    Montréal, Canada Canadian National Railway 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...

  • Data Modeler

    2 months ago

    Montréal, Canada Canadian National Railway 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...

  • Data Modeler

    2 months ago

    Montréal, Canada Canadian National Railway 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...

  • Data Modeler

    2 months ago

    Montréal, Canada Canadian National Railway 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...

  • Data Modeler

    2 months ago

    Montréal, QC, Canada Canadian National Railway 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...

  • Data Modeling Specialist

    20 hours ago

    Montréal, Canada National Bank of Canada Full time

    A career as a Data Modeler in the Data Exposure Expertise team within the Data Office at National Bank means acting as an expert in business data modeling (conceptual data models) to move the Bank towards its data management target. In particular, you'll be working with our IT and business partners, and supporting modeling experts in the Bank's business...

  • Expert Data Modeler

    2 months ago

    Montréal, QC, Canada Canadian National Railway 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...

  • Data Modellers

    3 weeks ago

    Montréal, QC, Canada Synechron Full time

    Role: Data Warehouse Engineer (Pyspark/ Python, Azure and Snowflake) Strong understanding or Snowflake on Azure Architecture, design, implementation and operationalization of large-scale data and analytics solutions on Snowflake Cloud Data Warehouse. Hands-on development experience with Snowflake features such as Snow SQL; Python; data sharing; Experience...

  • Analyst, Data Modeling and Architecture

    21 hours ago

    Montréal, Canada National Film Board of Canada Full time

    Posted: May 17, 2024 Closing date of the competition: May 31, 2024 **Location**: Montreal (Balmoral) **Flexibility Profile**: Mostly Remote **Salary Range**: 10 - $81,693 to $104,457 (under review) **Position Status**: Continuous - Full-time **Position Number**: 00021322 **Division**: Technologies **Department**: Information Technology & Infrastructure...

  • Data Scientist

    5 days ago

    Montréal, Canada Desjardins Full time

    At 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...

  • Advisor - Data Science and Modelling

    1 month ago

    Montréal, Canada Desjardins Full time

    At 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 weeks ago

    Montréal, Canada Desjardins Full time

    At 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

    5 days ago

    Montréal, Canada Desjardins Full time

    At 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 Collector for Ai Models French

    2 weeks ago

    Montréal, Canada RWS Full time

    **Data Collector for AI Models**: Location: Work from home (Remote, Worldwide) - **Work Location**: remote, work from home - ** Work Schedule**:part time, flexible schedule - ** Compensation**:competitive rate - **Experience**: no prior experience required - **Language Requirements**: fluent in French (Canada) and English - ** Start Date**:immediately -...

  • Modelling/forecasting Analyst

    1 month ago

    Montréal, Canada TD Bank Full time

    399965BR Enterprise Data & Analytics Montreal, QC March 6, 2023 Company Overview Department Overview The Insurance Analytics and Modelling team provides analytics and predictive models driven advice and counselling service to internal stakeholders, thereby enabling colleagues to have the right information to make business decisions impacting different...

  • Modelling/forecasting Analyst

    2 months ago

    Montréal, Canada TD Bank Full time

    **TD Description** Stay current and competitive. Carve out a career for yourself. Grow with us. **Department Overview** The Insurance Analytics and Modelling team provides analytics and predictive models driven advice and counselling service to internal stakeholders, thereby enabling colleagues to have the right information to make business decisions...

  • Adms Model Consultant

    1 month ago

    Montréal, Canada Open Systems International Full time

    Open Systems International, Inc. (OSI), An AspenTech Business, is a fast-paced, growing, high technology company, headquartered in Medina, Minnesota. As a world leader in the Operations Technology (OT) field, OSI develops and supplies state-of-the-art energy management, optimization and control software solutions to energy utility companies worldwide. The...

  • Business Modeling Specialist

    20 hours ago

    Montréal, Canada Genetec Full time

    **What your day will look like**: The Business Modeling Specialist reports to the Manager, Voice of Customer. In this role, you will be responsible for the following aspects - Lead the business process modeling efforts for the key processes of the CX organization following the ArchiMate standards to build consistent and customer-centric models, while also...

  • Data Scientist- Risk Model Validation and Monitoring

    1 month ago

    Montréal, Canada Desjardins Full time

    At 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...