Jobs
>
Montréal

    Expert Data Modeler - Montréal, Canada - Canadian National Railway

    Canadian National Railway
    Canadian National Railway Montréal, Canada

    18 hours ago

    Default job background
    Technology / Internet
    Description
    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

    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.
  • National Bank of Canada

    Data Modeling Specialist

    3 days ago

    National Bank of Canada Montréal, Canada

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

  • National Film Board of Canada

    Analyst, Data Modeling and Architecture

    3 days ago

    National Film Board of Canada Montréal, Canada

    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**: **Division**: T ...

  • Air Canada

    Data Modeler, Data

    1 week ago

    Air Canada Dorval, Canada

    **Description** · **Being part of Air Canada is to become part of an iconic Canadian symbol, recently ranked the best Airline in North America. Let your career take flight by joining our diverse and vibrant team at the leading edge of passenger aviation.** · **Responsibilities**: ...

  • Desjardins

    Data Scientist- Risk Model Validation and Monitoring

    3 days ago

    Desjardins Montréal, Canada

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

  • Sekure Merchants

    Data Modeler

    1 week ago

    Sekure Merchants Montreal, Canada Full time

    Job Details · Description · Work with Data Architect and partners to understand business requirements, create data definitions, business rules, data quality requirements, and logical and physical models, then support implementation within the data platform by working with the d ...

  • Canadian National Railway

    Expert Data Modeler

    1 day ago

    Canadian National Railway Montréal, QC, Canada

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

  • CN

    Expert Data Modeler

    1 week ago

    CN Montreal, Canada

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

  • NBC

    Data Modeling Specialist

    1 week ago

    NBC Montreal, Canada Full time

    Area of Interest: Marketing 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, ...

  • National Bank

    Data Modeling Specialist

    1 week ago

    National Bank Montreal, Canada Permanent

    Attendance Hybrid Job Number 18875 Category Senior Professional Status: Permanent Type of Contract Permanent Schedule: Full-Time Full Time / Part Time? Full-Time Posting date 02-Apr-2024 Location: Montreal, Quebec City Montreal Province/State Quebec Area of Interest: Marketing A ...

  • DELAN - IT Head Hunters

    Data Modeling Specialist

    1 week ago

    DELAN - IT Head Hunters Montreal, Canada Full time

    · Tasks/Responsibilities · The Data Modeling Specialist will be responsible for ensuring that the solutions proposed and developed by the company perfectly correspond to the needs and challenges of clients. · MORE PRECISELY · Analyze the business needs of major clients and defin ...

  • Ask Locala

    Data Scientist

    3 days ago

    Ask Locala Montréal, Canada

    **Locala **is the world's leading commerce media platform, leveraging consumer insights and location data to increase brand awareness, drive consumers to store, and deliver smarter business outcomes. Our proprietary technology enables local advertising and insights at scale, all ...

  • Astek Canada

    Architecte de Données

    6 days ago

    Astek Canada Montréal, Canada

    Titre du poste : Architecte de donnéesHoraire : 40 heures par semaineMandat de 12 moisLangues :BilingueLieu : Principalement à distance depuis MontréalAstek recrute pour un de ses client un Architecte de donnéesCompétences : -Modélisation Relationnel-Modélisation Dimensionnel-Dat ...

  • Sia Partners

    Conseiller(ère) en Data Science

    4 days ago

    Sia Partners Montréal, Canada

    de l'entreprise · Sia Partners est un **leader mondial des cabinets de conseil en gestion** et **le pionnier du Consulting 4.0.** Fort d'une **équipe de plus de 2 400 conseillers** de haut niveau, nous **accompagnons nos clients dans la conduite de leurs projets de transformation ...

  • Société Générale

    Data Scientist-

    5 days ago

    Société Générale Montréal, Canada

    **Vos missions au quotidien**: · **À PROPOS DU POSTE**: · L'équipe Digital and Data Services est en processus de recrutement d'un data scientiste basé à Montréal pour travailler dans le programme de surveillance des communications dédié à la prévention des risques de non-conformi ...

  • Systématix

    Architecte Ai

    1 week ago

    Systématix Montréal, Canada

    **Architecte AI** · Date de début : · Date de la fin : · Horaire : 40 h / semaine · **Tâches** · Dans le cadre du mandat de valorisation et démocratisation des services BI et analytique de la DP · - Données et Analytique: · - Avoir la responsabilité d'améliorer l'architecture e ...

  • National Bank of Canada

    Architecte de Données

    1 week ago

    National Bank of Canada Montréal, Canada

    Une carrière en tant qu'architecte de données dans l'équipe de Livraison Numérique et Services Bancaires à la Banque Nationale c'est participer au projet d'envergure en transformation digital qui te permettra de te dépasser, tout en travaillant en étroite collaboration avec les d ...

  • Behaviour Interactive

    Data Scientist I Scientifique de Données

    1 week ago

    Behaviour Interactive Montréal, Canada

    As part of our Data Science team, you will have the opportunity to collaborate with cross-discipline teams to help us constantly improve our games and our players' experience. You will actively contribute to the game development (design, direction, live operation) by creating dat ...

  • Croix Bleue du Québec

    Analyste Intelligence D'affaire

    4 days ago

    Croix Bleue du Québec Montréal, Canada

    **Prenez part à notre transformation** · CanAssistance (filiale de Croix Bleue Canassurance) est l'une des plus importantes compagnies d'assistance au Canada. Notre mission est de fournir un accompagnement aux assurés qui sont malades ou victimes d'accident à l'étranger. Nous off ...

  • Business Development Bank of Canada

    Analyste Principal, Publicité

    3 days ago

    Business Development Bank of Canada Montréal, Canada

    Viens faire banque à part. · Choisir BDC comme employeur, c'est évoluer dans un milieu de travail sain, inclusif, riche de compétences et qui met de l'avant les meilleures conditions pour rassembler des équipes uniques où le pouvoir d'agir est réel. C'est aussi être au centre de ...

  • Alithya

    2 X Analyste en Intelligence D'affaires

    1 week ago

    Alithya Montréal, Canada

    Montréal, Québec, Canada · **Veuillez** prendre note que ce poste est en télétravail.**: · Alithya, chef de file en transformation numérique, accompagne des clients et des partenaires internes dans la recherche d'experts, de collaborateurs créatifs et ingénieux. C'est l'un des no ...