Snowflake Data Modeller/DBA

Job summary

Design and maintain enterprise data models in Snowflake, implement SCD Type 2 and CDC patterns, and tune SQL for scalable analytics. Collaborate with business, engineering, BI, and integration teams to document mappings and transformation rules, establish modeling standards, and guide Snowflake warehouse and lakehouse architecture.

Job details

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 an experienced Snowflake Data Modeler/Architect to design, optimize, and implement enterprise data models that support advanced analytics and reporting needs. The ideal candidate will have strong expertise in data modeling techniques, Slowly Changing Dimensions (SCD Type 2), Change Data Capture (CDC) in Snowflake, and SQL performance tuning. This role also involves hands-on use of data modeling tools (ERWIN or similar) and the creation of detailed data mapping documents for integration teams. Key Responsibilities Design, implement, and maintain conceptual, logical, and physical data models in Snowflake. Apply advanced data modeling techniques (e.g., normalization, denormalization, star/snowflake schemas, data vault modeling). Implement and optimize SCD Type 2 and Snowflake CDC patterns for historical data tracking and incremental processing. Work closely with data engineers, BI developers, and integration teams to define data mapping documents, transformation logic, and business rules. Utilize ERWIN (or similar modeling solutions) to document and manage enterprise data models. Conduct SQL performance tuning and ensure scalable query execution on large data volumes. Collaborate with business stakeholders to translate functional requirements into technical data models. Define and enforce data modeling standards, best practices, and governance across projects. Support integration teams with clear metadata, lineage, and documentation for ETL/ELT pipelines. Provide architectural guidance for data warehouse/lakehouse solutions in Snowflake. Required Skills 1-5 years of experience in data modeling, architecture, and enterprise data warehouse design. Hands-on expertise with Snowflake (warehouses, schema design, CDC, performance tuning). Proficiency in SQL (complex queries, optimization, and debugging). Strong knowledge of SCD Type 2 implementations and change data capture methodologies. Experience with ERWIN or equivalent data modeling tools. Proven ability to create data mapping documents and transformation rules for integration teams. Deep understanding of data warehouse and dimensional modeling concepts. Strong analytical, problem-solving, and communication skills. Preferred Qualifications Experience with ETL/ELT tools (Informatica, dbt, Matillion, Talend, etc.). Exposure to cloud integration platforms (Azure Data Factory, AWS Glue, GCP Data Fusion). Familiarity with data governance, data quality, and master data management (MDM). Experience in agile delivery environments. 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 Modeller/DBA” in the subject line. Apply with a one-page cover letter and CV to hr@xcrotek.com SHARE THIS INSIGHT Copied!

What you’ll do

Design and maintain enterprise data models in Snowflake, implement SCD Type 2 and CDC patterns, and tune SQL for scalable analytics. Collaborate with business, engineering, BI, and integration teams to document mappings and transformation rules, establish modeling standards, and guide Snowflake warehouse and lakehouse architecture.

Requirements

The role requires 1–5 years of experience in data modeling, architecture, or enterprise data warehousing, with hands-on Snowflake and strong SQL expertise. Candidates should know SCD Type 2, CDC, dimensional modeling, and ERWIN or a similar tool, and be able to create data mapping documents; ETL/ELT tools and cloud integration platforms are preferred.

Listed skills

• SQL · Preferred

Other relevant skills

Identified from the job description. Confirm important requirements above.

• Snowflake
• Data Modeling
• Data Architecture
• SQL
• SCD Type 2
• Change Data Capture
• SQL Performance Tuning
• ERWIN
• Dimensional Modeling
• Data Mapping
• ETL/ELT
• Data Governance
• Data Quality
• Data Lineage
• Data Warehousing
• Data Vault Modeling

Job areas

• Data & Analytics
• Technology
• Software

More jobs from xCroTek AI