Data Modeler

1 month ago

Montréal QC HB M, 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

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.

  • IT Network Services Analyst

    2 weeks ago

    Dorval, QC, H0S, Montréal, Canada Air Canada Full time

    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. Air Canada is seeking an experienced and dynamic Analyst, IT Network. This is a position within the Network...

  • Master Production Planner

    4 weeks ago

    Verdun South, QC, H4H, Montréal, Canada GoodLeaf Farms Full time

    Master Production Planner (Bilingual, French / English)Job Type: Permanent / FulltimeLocation: St-Hubert, QCWould you like to be a part of a revolution in agriculture in Canada? If so, we would love to hear from you!At GoodLeaf Farms we are a proud Canadian company at the forefront of innovation, striving to grow food security for communities from coast to...

  • Product Developer Contact Centres

    2 weeks ago

    Dorval, QC, H0S, Montréal, Canada Air Canada Full time

    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. The developer is responsible for the design and the development of the Contact Centres Application...

  • Freight Manager

    4 weeks ago

    Montréal, Québec, H2W 1S8, Montréal, Canada DLVRD Logistics Inc. Full time

    Company DescriptionWelcome to DLVRD Logistics, a Canadian medium sized business that makes shipping easy. Through our proprietary technology, we offer small parcel delivery at heavily discounted rates, as well as air, land and sea freight and warehousing. We’re looking for doers, go-getters and game changers, to join our rewarding culture. Come work with...

  • Product Manager

    2 weeks ago

    Dorval, QC, H0S, Montréal, Canada Air Canada Full time

    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. Air Canada's NDC (New Distribution Capability) program offers great benefits, new capabilities, and...

  • Data Modeler

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

  • Expert Data Modeler

    4 weeks 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 Modeller

    1 month 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

    1 month 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

    1 month 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

    1 month 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

    1 month 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

    1 month 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 Modellers

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

  • Data Scientist

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

  • Modelling/forecasting Analyst

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

  • Visual Database Modeller

    6 days ago

    Montréal, QC, Canada Soho Square Solutions Full time

    Role: Visual Database Modeller Location: St-Laurent Duration: 1 Year Bilingual: French & English Integrate all aspects of Content Creation production for products/projects in a multi-site environment ensuring specific milestones and quality standards are met and tracked. Collaborate with multi-disciplinary teams. Ability to use proprietary Content...

  • Senior Risk Data Engineer/ Risk Data Scientist

    1 week ago

    Montréal, QC, Canada Lorven Technologies Inc. Full time

    Senior Risk Data Engineer/ Risk Data Scientist Location: Montreal, QC (Onsite) Job Type: Contract 12+ Months (C2C/T4) Job Description:Experience working on projects (Agile methodologies) related to pricing/risk and Market and Credit/Counterparty data for Risk engines. • Relevant Risk experience: Modeling of different product types including Bonds, Equity,...

  • Senior Risk Data Engineer/ Risk Data Scientist

    1 week ago

    Montréal, QC, Canada Lorven Technologies Inc. Full time

    Senior Risk Data Engineer/ Risk Data Scientist Location: Montreal, QC (Onsite) Job Type: Contract 12+ Months (C2C/T4) Job Description:Experience working on projects (Agile methodologies) related to pricing/risk and Market and Credit/Counterparty data for Risk engines. • Relevant Risk experience: Modeling of different product types including Bonds, Equity,...

  • Data Scientist- Risk Model Validation and Monitoring

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

  • Practice Lead Data Scientist, Data Driven Marketing

    1 month ago

    Montréal, QC, 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 our customers. We aim to always be...

  • Lead Data Scientist

    1 week ago

    Montréal, QC, Canada Launch Potato Full time

    Launch Potato is a digital media company with a portfolio of brands and technologies. As The Discovery and Conversion Company, Launch Potato is a leading connector of advertisers to customers at all parts of the consumer journey, from awareness to consideration to purchase. The company is headquartered in vibrant downtown Delray Beach, Florida , with a...

  • Data Architect Data Analytics

    1 month ago

    Montréal, QC, Canada Accolite Full time

    Bounteous x Accolite makes the future faster for the world's most ambitious brands. Our services span Strategy, Analytics, Digital Engineering, Cloud, Data & AI, Experience Design, and Marketing. Bounteous x Accolite brings together 5000+ employees spanning North America, APAC, and EMEA, and partnerships with leading technology providers. Through advanced...

  • Data Engineer Senior

    4 weeks ago

    Montréal, QC, Canada Hour Consulting Full time

    Our client is an established growing part of the Higher Education technology industry. They are a Global SaaS Company with over 300 campus partners and 2 million students actively using their platform. They help higher education institutions better engage their students, improve the student life experience on campus, and student success. They are...

  • Data Engineer, Staff

    4 weeks ago

    Montréal, QC, Canada Stay22 Full time

    Job Description Stay22 is a fast growing and profitable Travel Tech startup in Montreal that helps content creators to better monetize their content while improving the overall experience of their end users through different innovative solutions that makes it easy to search for travel related services. Over 100 million unique users go every month through...