Data Modeler

4 weeks ago

Montreal, Canada CN 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

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

    4 weeks ago

    Montreal, Canada Sekure Merchants 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 data solution architect, other data modelers and data engineers.  Job...

  • Data Modeller

    4 weeks ago

    Montreal, Canada CN Full time

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

  • Expert Data Modeler

    1 week ago

    Montreal, Quebec, 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 Modeling Specialist

    4 weeks ago

    Montreal, Quebec, Canada DELAN - IT Head Hunters 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 PRECISELYAnalyze the business needs of major clients and define modeling needsDesign modeling models on the platformWork in Agile mode, mainly with...

  • Data Modeling Specialist

    1 month ago

    Montreal, Canada DELAN - IT Head Hunters 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 define modeling needs Design modeling models on the platform Work in Agile mode,...

  • Modeller, Credit Risk

    2 weeks ago

    Montreal, Canada Desjardins 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 quantify risks and make credit decisions, develop and maintain models, and understand...

  • Data Scientist, Data valorization

    2 weeks ago

    Montreal, Canada Desjardins Full time

    As a data scientist, you provide the data needed to make business decisions, develop solutions and services adapted to business issues and understand member and client behaviour. You lead internal and external stakeholders in model development projects adapted to business needs and in complex strategic interventions in advanced analytics and artificial...

  • Data Scientist

    2 weeks ago

    Montreal, Canada IATA Consulting Full time

    Employment Type: PermanentContract 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

    Montreal, Canada IATA Consulting Full time

    Employment Type: PermanentContract 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

    Montreal, Canada IATA Consulting Full time

    Employment Type: PermanentContract 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

    5 days ago

    Montreal, Canada Desjardins Full time

    As a data scientist, you provide the data needed to make business decisions, develop solutions and services adapted to business issues and understand member and client behaviour. You lead and influence stakeholders in projects and initiatives to proactively meet cross-sector business needs, through the development of highly innovative models and complex...

  • Practice Lead Data Scientist, Data Driven Marketing

    4 weeks ago

    Montreal, Canada Cogeco Full time

    Our culture lifts you up—there is no ego in the way. Our common purpose? We all want to win for our customers. We aim to always be evolving, dynamic, and ambitious. We believe in the power of genuine connections. Each employee is a part of what makes us unique on the market: agile and dedicated. Time Type: Regular Job Description : SUMMARY ...

  • Senior Data Architect

    2 days ago

    Montreal, Canada National Bank Full time

    Being a Data Solutions Architect for the Wealth Management business line means you're at the core of our deliberations on methodologies to create value for the business line. You'll have the opportunity to represent the Bank's values and use your agency to contribute to the creation of innovative solutions that address real business challenges, reframing how...

  • Senior Data Architect

    21 hours ago

    Montreal, Canada National Bank Full time

    Being a Data Solutions Architect for the Wealth Management business line means you're at the core of our deliberations on methodologies to create value for the business line. You'll have the opportunity to represent the Bank's values and use your agency to contribute to the creation of innovative solutions that address real business challenges, reframing how...

  • Practice Lead Data Scientist, Data Driven Marketing

    1 month ago

    Montreal, Canada Cogeco Inc. Full time

    Practice Lead Data Scientist, Data Driven Marketing page is loaded Practice Lead Data Scientist, Data Driven Marketing Apply locations Montréal, QC time type Full time posted on Posted 2 Days Ago job requisition id JR7667 Our culture lifts you up—there is no ego in the way. Our common purpose? We all want to win for...

  • Practice Lead Data Scientist, Data Driven Marketing

    4 weeks ago

    Montreal, Canada Cogeco Inc. Full time

    Practice Lead Data Scientist, Data Driven Marketing page is loaded Practice Lead Data Scientist, Data Driven Marketing Apply locations Montréal, QC time type Full time posted on Posted 2 Days Ago job requisition id JR7667 Our culture lifts you up—there is no ego in the way. Our common purpose? We all want to win for...

  • Practice Lead Data Scientist, Data Driven Marketing

    4 days ago

    Montreal, Canada Cogeco Inc. Full time

    Practice Lead Data Scientist, Data Driven Marketing page is loaded Practice Lead Data Scientist, Data Driven Marketing Apply locations Montréal, QC time type Full time posted on Posted 2 Days Ago job requisition id JR7667 Our culture lifts you up—there is no ego in the way. Our common purpose? We all want to win for...

  • Practice Lead Data Scientist, Data Driven Marketing

    4 weeks ago

    Montreal, Canada Cogeco Inc. Full time

    Practice Lead Data Scientist, Data Driven Marketing page is loaded Practice Lead Data Scientist, Data Driven Marketing Apply locations Montréal, QC time type Full time posted on Posted 2 Days Ago job requisition id JR7667 Our culture lifts you up—there is no ego in the way. Our common purpose? We all want to win for...

  • Data Scientist

    21 hours ago

    Montreal, Canada NBC Full time

    Area of Interest: Risk management ...

  • Senior Data Architect

    22 hours ago

    Montreal, Canada National Bank Full time

      Being a Data Solutions Architect for the Wealth Management business line means you're at the core of our deliberations on methodologies to create value for the business line. You'll have the opportunity to represent the Bank's values and use your agency to contribute to the creation of innovative solutions that address real business challenges, reframing...