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 hr@xcrotek.com. Please include “Snowflake Data Modeler” in the subject line.
Apply with a one-page cover letter and CV to hr@xcrotek.com
