Back to search

Data Modeler / Snowflake Data Architect

Design and develop dimensional and conceptual data models using Snowflake and Data Vault methodologies for the Travel & Transportation industry.

  • Toronto, Ontario, Canada
  • Full-time
  • Posted Nov 9, 2026

Responsibilities

  • Design and develop conceptual, logical, and physical data models
  • Build and maintain dimensional models using Star and Snowflake schemas
  • Implement Data Vault 1.0/2.0 modeling approaches
  • Design data structures aligned with the Bronze, Silver, and Gold medallion architecture
  • Leverage Snowflake capabilities to manage structured and semi-structured data
  • Optimize SQL queries, Snowflake performance, and compute/storage costs
  • Support enterprise data governance, metadata management, and data quality standards
  • Collaborate with data engineers, architects, and business stakeholders to translate requirements into scalable data models

Requirements

  • Experience in a Travel & Transportation

Nice to have: ERwin, dbt, Lucidchart, Cloud environments, Client Azure, Enterprise data governance, Metadata management, Data quality practices

Skills

Designing dimensional modelsData Vault 1.0 and 2.0 methodologiesSnowflake architectureMicro-partitionsClustering keysVARIANT data typesSemi-structured dataBronze, Silver, and Gold data layersAdvanced SQLData governanceMetadata managementPerformance tuningCost optimizationTravel & Transportation industry experienceERwindbtLucidchartAzureSnowflakeSQL

Benefits

  • Flexible working arrangements
  • Remote-first culture
  • Professional development
  • Career growth
  • Inclusive and diverse work environment

Full description

Title: Data Modeler / Snowflake Data Architect Location: Toronto, ON Duration: 12 Months Introduction Join our team in the Travel & Transportation industry as a Data Modeler / Snowflake Data Architect. We are looking for a skilled professional to help us design and optimize our data infrastructure. Required Skills & Qualifications Strong experience designing dimensional models, including Star and Snowflake schemas. Hands-on expertise in Data Vault 1.0 and 2.0 methodologies. Strong knowledge of Snowflake architecture and features, including micro-partitions, clustering keys, VARIANT data types, and semi-structured data. Experience implementing Bronze, Silver, and Gold data layers. Advanced SQL skills and experience designing conceptual, logical, and physical data models. Knowledge of data governance, metadata management, performance tuning, and cost optimization. Prior work experience in the Travel & Transportation industry. Preferred Skills & Qualifications Experience with data modeling and transformation tools such as ERwin, dbt, and Lucidchart. Experience working with cloud environments, particularly Client Azure. Experience implementing enterprise data governance, metadata management, and data quality practices. Day-to-Day Responsibilities Design and develop conceptual, logical, and physical data models. Build and maintain dimensional models using Star and Snowflake schemas. Implement Data Vault 1.0/2.0 modeling approaches. Design data structures aligned with the Bronze, Silver, and Gold medallion architecture. Leverage Snowflake capabilities to manage structured and semi-structured data. Optimize SQL queries, Snowflake performance, and compute/storage costs. Support enterprise data governance, metadata management, and data quality standards. Collaborate with data engineers, architects, and business stakeholders to translate requirements into scalable data models. Company Benefits & Culture Flexible working arrangements with a remote-first culture. Opportunities for professional development and career growth. Inclusive and diverse work environment. For immediate consideration please click APPLY to begin the screening process with Alex.

Data Modeler / Snowflake Data Architect at Artech LLC | Referso Jobs