Data Modeler Expert

5 days ago

Montreal, Quebec, Canada CN Full time
Job Summary

We are seeking a skilled Data Modeler to lead the collection of business requirements and translate them into efficient data structures. The ideal candidate will have a strong background in data design and modeling, with experience in dimensional modeling and relational database modeling techniques.

Main Responsibilities
  • Understand and translate complex business data and analytics requirements into 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.
  • Perform profiling and data analysis using advanced SQL/Python techniques on multiple platforms.
  • 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.
Requirements
  • Bachelor's degree in Mathematics and Statistics/Computer Science/Business Analytics or related field.
  • 10+ years of 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.
  • Experience leading and participating in business workshops and business presentations.
Skills and Competencies
  • Experience with data design tools (Erwin Data Modeler 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.
Assets
  • Experience in real-time data streaming and loading.
  • Experience modeling 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.

  • Business Intelligence Developer

    2 weeks ago

    Montreal, Quebec, Canada S.i. Systems Full time

    Job OpportunityS.i. Systems is seeking an experienced Business Intelligence Developer to join our team as a data modeling expert. This is a remote position that can be worked from anywhere in Canada, but it is required to work MST hours.Key ResponsibilitiesDesign and develop business intelligence solutions using Informatica or SAP BusinessObjectsCreate and...

  • Business Intelligence Developer

    2 weeks ago

    Montreal, Quebec, Canada S.i. Systems Full time

    Job OpportunityS.i. Systems is seeking an experienced Business Intelligence Developer to join our team as a data modeling expert. This is a remote position that can be worked from anywhere in Canada, but it is required to work MST hours.Key ResponsibilitiesDesign and develop business intelligence solutions using Informatica or SAP BusinessObjectsCreate and...

  • Data Modeler

    1 week ago

    Montreal, Quebec, Canada Sekure Merchants Full time

    Job Title: Data ModelerAbout the Role:Sekure Merchants is seeking a skilled Data Modeler to join our team. As a Data Modeler, you will play a critical role in designing and developing data models that support our business intelligence and data warehousing initiatives.Key Responsibilities:Collaborate with Data Architects and stakeholders to understand...

  • Data Modeler

    1 week ago

    Montreal, Quebec, Canada Sekure Merchants Full time

    Job Title: Data ModelerAbout the Role:Sekure Merchants is seeking a skilled Data Modeler to join our team. As a Data Modeler, you will play a critical role in designing and developing data models that support our business intelligence and data warehousing initiatives.Key Responsibilities:Collaborate with Data Architects and stakeholders to understand...

  • Data Modeler

    3 days ago

    Montreal, Quebec, Canada Sekure Merchants Full time

    Job Title: Data ModelerAbout the Role:We are seeking a skilled Data Modeler to join our team at Sekure Merchants. As a Data Modeler, you will play a critical role in designing and developing data models that support our business intelligence and data warehousing initiatives.Key Responsibilities:Develop conceptual, logical, and physical data models to support...

  • Data Modeler

    3 days ago

    Montreal, Quebec, Canada Sekure Merchants Full time

    Job Title: Data ModelerAbout the Role:We are seeking a skilled Data Modeler to join our team at Sekure Merchants. As a Data Modeler, you will play a critical role in designing and developing data models that support our business intelligence and data warehousing initiatives.Key Responsibilities:Develop conceptual, logical, and physical data models to support...

  • Data Modeler

    2 days ago

    Montreal, Quebec, Canada High Tech Genesis Inc. Full time

    High Tech Genesis Inc. is seeking a skilled Data ModelerWe are looking for a highly motivated and experienced Data Modeler to join our team at High Tech Genesis Inc. The successful candidate will play a key role in developing, implementing, and continuously evolving a best-in-class data management capability.The ideal candidate will have a strong background...

  • Data Modeler

    1 day ago

    Montreal, Quebec, Canada High Tech Genesis Inc. Full time

    High Tech Genesis Inc. is seeking a skilled Data ModelerWe are looking for a highly motivated and experienced Data Modeler to join our team at High Tech Genesis Inc. The successful candidate will play a key role in developing, implementing, and continuously evolving a best-in-class data management capability.The ideal candidate will have a strong background...

  • Expert - Data Design

    2 weeks ago

    Montreal, Quebec, Canada CN Full time

    Expert Data Modeler Join our Information & Technology (I&T) team as an Expert Data Modeler and play a critical role in shaping the foundation of data-driven decision-making. As a key contributor to our center of excellence, you will design, implement, and maintain data models that serve as the backbone of our organization's data infrastructure. Main...

  • Actuarial Modeling Expert

    2 weeks ago

    Montreal, Quebec, Canada Reinsurance Group of America (RGA) Full time

    Job SummaryWe are seeking an experienced Actuarial Modeling Expert to join our team at Reinsurance Group of America (RGA). As a key member of our Corporate Pricing department, you will be responsible for developing and leading the pricing support team, promoting the Actuarial Modeling function as RGA's Center of Excellence for pricing support, and ensuring...

  • Actuarial Modeling Expert

    2 weeks ago

    Montreal, Quebec, Canada Reinsurance Group of America (RGA) Full time

    Job SummaryWe are seeking an experienced Actuarial Modeling Expert to join our team at Reinsurance Group of America (RGA). As a key member of our Corporate Pricing department, you will be responsible for developing and leading the pricing support team, promoting the Actuarial Modeling function as RGA's Center of Excellence for pricing support, and ensuring...

  • Actuarial Modeling Expert

    2 weeks ago

    Montreal, Quebec, Canada Reinsurance Group of America (RGA) Full time

    Job SummaryWe are seeking an experienced Actuarial Modeling Expert to join our team at Reinsurance Group of America (RGA). As a key member of our Corporate Pricing department, you will be responsible for developing and leading the pricing support team, promoting the Actuarial Modeling function as RGA's Center of Excellence for pricing support, and ensuring...

  • Data Design Expert

    2 weeks ago

    Montreal, Quebec, Canada CN Full time

    About the RoleCN is a world-class transportation leader and trade-enabler. As a critical component of our Information & Technology (I&T) team, we are seeking a skilled Data Design Expert to join our talented team.Key ResponsibilitiesLead the collection of business requirements to be translated into efficient data structures, ensuring data integrity and...

  • Data Design Expert

    2 weeks ago

    Montreal, Quebec, Canada CN Full time

    About the RoleCN is a world-class transportation leader and trade-enabler. As a critical component of our Information & Technology (I&T) team, we are seeking a skilled Data Design Expert to join our talented team.Key ResponsibilitiesLead the collection of business requirements to be translated into efficient data structures, ensuring data integrity and...

  • Data Design Expert

    2 weeks ago

    Montreal, Quebec, Canada CN Full time

    About the RoleCN is a world-class transportation leader and trade-enabler. As a critical component of our Information & Technology (I&T) team, we are seeking a skilled Data Design Expert to join our talented team.Key ResponsibilitiesLead the collection of business requirements to be translated into efficient data structures, ensuring data integrity and...

  • Data Design Expert

    2 weeks ago

    Montreal, Quebec, Canada CN Full time

    About the RoleWe are seeking a highly skilled Data Design Expert to join our team at CN. As a key member of our data architecture team, you will be responsible for leading the design and implementation of data models that serve as the backbone of our organization's data infrastructure.Key ResponsibilitiesTranslate complex business data and analytics...

  • Data Design Expert

    2 weeks ago

    Montreal, Quebec, Canada CN Full time

    About the RoleWe are seeking a highly skilled Data Design Expert to join our team at CN. As a key member of our data architecture team, you will be responsible for leading the design and implementation of data models that serve as the backbone of our organization's data infrastructure.Key ResponsibilitiesTranslate complex business data and analytics...

  • Data Modeler

    3 days ago

    Montreal, Quebec, Canada High Tech Genesis Full time

    Data Modeler Job DescriptionHigh Tech Genesis is seeking a skilled Data Modeler to develop, implement, and continuously evolve a best-in-class data management capability. Reporting to the BI Lead, this role will play a key part in leveraging our extensive customer and operational data sets to drive insights, support business management, and help achieve and...

  • Data Modeler

    3 days ago

    Montreal, Quebec, Canada High Tech Genesis Full time

    Data Modeler Job DescriptionHigh Tech Genesis is seeking a skilled Data Modeler to develop, implement, and continuously evolve a best-in-class data management capability. Reporting to the BI Lead, this role will play a key part in leveraging our extensive customer and operational data sets to drive insights, support business management, and help achieve and...

  • Data Modeler

    13 hours ago

    Montreal, Quebec, Canada High Tech Genesis Inc. Full time

    Job Title: Data ModelerWe are seeking a highly skilled Data Modeler to join our team at High Tech Genesis Inc. in Montreal, QC.About the Role:Develop and implement data management capabilities to drive business insights and support organizational objectives.Provide technical management of source systems, ETL processes, data stores, data warehouses, and...