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
Artech LLC
Company details are for members
Sign up for a free job alert to see Artech LLC's profile, website and LinkedIn, and the same for every employer on Referso Jobs.