Expert Data Modeler

3 weeks 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 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 Modeling Specialist

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

  • Engineering Master Data Expert

    1 week ago

    Montreal, Quebec, Canada CN Rail Full time

    Job SummaryThe Engineering Master Data Expert is responsible for establishing processes and solutions for engineering master data capture to ensure the data is updated and integrated with different CN solutions. The position acts as a liaison between Engineering, Information and Technology (I&T), Transportation, Operating Practices, and internal and external...

  • Engineering Master Data Expert

    5 days ago

    Montreal, Quebec, Canada CN Full time

    At CN, everyday brings new and exciting challenges. You can expect an interesting environment where you're part of making sure our business is running optimally and safely―helping keep the economy on track. We provide the kind of paid training and opportunities that long-term careers are built on and we recognize hard workers who strive to make a...

  • Expert Solution

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

  • Expert Solution

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

  • Microsoft Data Engineering Specialist

    1 month ago

    Montreal, Quebec, Canada Larochelle Groupe Conseil Full time

    Larochelle Consulting Group is seeking a consultant who specializes in data engineering with the Microsoft stack to reach our Business Intelligence Center of Excellence in Montreal.ResponsibilitiesParticipate actively in the conception, development, deployment and optimization of dynamic data pipelines (batches, micro-batches, continuous flux) for varied...

  • Expert, Solution and System Integration

    4 days 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 Scientist in Canada with Work Permit

    5 days ago

    Montreal, Quebec, Canada NUMBERLY, MARKETING INTERACTIF INC. Full time

    Are you a talented and analytical professional in the field of data science looking for an exciting job opportunity in Canada?Are you an international data scientist seeking employment in Canada with a valid work permit?Look no furtherWe are currently hiring skilled data scientists who possess a valid work permit to join our team in Canada.Take the next step...

  • Lead Data Scientist

    1 month ago

    Montreal, Quebec, Canada Montreal | Miebach Consulting, Inc. Canada Full time

    We are seeking Data Scientists with proven experience developing models to solve business problems to join our Digital Innovation team.What's in it for you: You will drive large-scale Supply Chain decisions for significant improvements in Sales, Service, Inventory, Cost, Investments and Carbon Emissions for our customers. You will be in direct contact with...

  • Expert, Solution Architect

    4 days ago

    Montreal, Quebec, 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...

  • Expert, Solution Architect

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

  • Expert Solution Design

    5 days ago

    Montreal, Quebec, 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...

  • Expert Client Senior

    1 month ago

    Montreal, Quebec, Canada Microsoft Canada Full time

    OverviewEnglish Text to Follow Chaque minute de chaque jour, les clients misent sur l'ensemble de leur entreprise et de leur réputation sur le Microsoft Cloud. L'équipe de Azure Customer Experience (CXP) estime que lorsque nous répondons à nos normes élevées de qualité et de fiabilité, nos clients y gagnent. Si nous faiblissons, nos clients échouent...

  • Expert Client Senior

    1 month ago

    Montreal, Quebec, Canada Microsoft Canada Full time

    OverviewEnglish Text to Follow Chaque minute de chaque jour, les clients misent sur l'ensemble de leur entreprise et de leur réputation sur le Microsoft Cloud. L'équipe de Azure Customer Experience (CXP) estime que lorsque nous répondons à nos normes élevées de qualité et de fiabilité, nos clients y gagnent. Si nous faiblissons, nos clients échouent...

  • Opportunités : Expert en sinistres et Conseiller-Expert en Responsabilité civile

    5 days ago

    Montreal, Quebec, Canada Intact Full time

    Our team is all about helping people, businesses, and society thrive in good times and stay strong in rough times. By joining us, you'll be part of a community of passionate experts who bring this purpose to life.Get ready to learn, grow, and be appreciated for being yourself. Diversity is key here, and we're committed to supporting you with the tools,...

  • Senior Data Center Commissioning Project Manager

    5 days ago

    Montreal, Quebec, Canada Veolia Full time

    Company DescriptionVeolia's ambition is to be the benchmark company in ecological transformation. With nearly 230,000 employees worldwide, the group designs and implements innovative, useful and concrete solutions for water, waste and energy management. Through its three complementary businesses, Veolia contributes to developing access to resources,...

  • Data Platform Architecture Manager

    3 weeks 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 Processing Specialist

    2 weeks ago

    Montreal, Quebec, Canada FortNine Full time

    Hello We're FortNine. We are one of North America's fastest growing e-commerce stores in the powersports industry, and are looking to grow our ranksWe are currently seeking a dedicated and skilled Intermediate Data Processing Specialist with a strong focus on web scraping and python development to join our dynamic team. This role requires a deep...

  • Senior Data Center Commissioning Project Manager

    5 days ago

    Montreal, Quebec, Canada Veolia Full time

    Company DescriptionVeolia's ambition is to be the benchmark company in ecological transformation. With nearly 230,000 employees worldwide, the group designs and implements innovative, useful and concrete solutions for water, waste and energy management. Through its three complementary businesses, Veolia contributes to developing access to resources,...

  • Senior Data Analyst, marketing analytics

    2 weeks ago

    Montreal, Quebec, Canada Ubisoft Entertainment Full time

    Senior Data Analyst, marketing analytics Ubisoft's 19,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...