Snowflake Data Modeler
Offre en anglaisDesign and maintain scalable conceptual, logical, and physical data models within Snowflake using star and snowflake schemas. Collaborate with cross-functional teams to optimize data structures and ensure high performance for analytics and integration pipelines.
- Télétravail
- Canada
- Publié 21 juill. 2026
- Postuler avant le 27 août 2026
- 1 poste
Résumé du poste
Job Category: Developer Job Type: Full Time Job Location: Remote Job status: Open Job Description About xCroTek xCroTek is a product- and service-based AI software company that builds innovative, AI-powered solutions to drive intelligent automation and digital transformation. We specialize in creating scalable, impactful technologies for modern businesses. Job Overview We are seeking a skilled Snowflake Data Modeler with 1–5 years of experience in data modeling, data warehousing, and cloud-based data platforms. The candidate will be responsible for designing scalable and optimized data models, ensuring data quality, and enabling efficient analytics on Snowflake. This role requires strong knowledge of dimensional modeling, SQL optimization, and integration with ETL/ELT frameworks. Key Responsibilities Design, develop, and maintain conceptual, logical, and physical data models in Snowflake. Implement star schema, snowflake schema, and data vault modeling as per business requirements. Collaborate with business analysts, data engineers, and BI teams to translate requirements into optimized data models. Ensure best practices in data modeling, performance tuning, and data governance. Optimize Snowflake data structures (tables, views, clustering keys, partitions) for high performance and scalability. Work with ETL/ELT teams to support data integration pipelines and ensure model alignment. Document data models, metadata, and lineage to support governance and compliance. Troubleshoot and resolve performance issues related to queries and data model design. Stay updated with Snowflake features, tools, and emerging trends in cloud data warehousing. Required Skills Bachelor’s degree in Computer Science, Information Systems, or related field. 4–5 years of experience in data modeling and data warehousing. Hands-on expertise with Snowflake (schemas, clustering, micro-partitioning, security, roles). Strong experience in SQL performance tuning and query optimization. Solid understanding of ETL/ELT concepts and integration with tools (Informatica, dbt, Talend, Matillion, etc.). Proficiency in dimensional modeling, normalization/denormalization, and OLAP concepts. Knowledge of cloud platforms (AWS/Azure/GCP) and their integration with Snowflake. Familiarity with data governance, metadata management, and data quality frameworks. Strong analytical, problem-solving, and communication skills. Preferred Qualifications Exposure to dbt (data build tool) or other modern transformation frameworks. Knowledge of Python or scripting for automation. Experience with data visualization tools (Tableau, Power BI, Looker). How To Apply Interested candidates should submit their resume and a brief cover letter explaining their interest in the role to [email protected]. Please include “Snowflake Data Modeler” in the subject line. Apply with a one-page cover letter and CV to [email protected] SHARE THIS INSIGHT Copied!
Ce que vous ferez
Design and maintain scalable conceptual, logical, and physical data models within Snowflake using star and snowflake schemas. Collaborate with cross-functional teams to optimize data structures and ensure high performance for analytics and integration pipelines.
Exigences
Requires a bachelor's degree and 4-5 years of experience in data modeling and warehousing with hands-on Snowflake expertise. Candidates must be proficient in SQL optimization, dimensional modeling, and familiar with ETL/ELT tools.
Autres compétences pertinentes
Relevées dans la description du poste. Confirmez les exigences importantes ci-dessus.
- Snowflake
- Data Modeling
- SQL Performance Tuning
- Dimensional Modeling
- ETL/ELT
- Data Warehousing
- Star Schema
- Snowflake Schema
- Data Vault Modeling
- Cloud Platforms
- Data Governance
- Metadata Management
Domaines d’emploi
- Data & Analytics
- Software
- Technology
- Consulting
- Engineering
Renseignements supplémentaires
- Formation minimale
- Baccalauréat
- Expérience minimale
- 2+ ans
- Postuler avant le
- 27 août 2026
- Langue de l’offre
- anglais
- Heures de travail
- 40 heures par semaine
- Niveau d’expérience
- Mid-Senior level