Senior Data Modeler: AI-Ready Data & Snowflake DW Modeling

Machine Learning Technologies, LLC; Issaquah (WA); On-site; USD 110,000 - 170,000; Full time

Job summary

Machine Learning Technologies, LLC is seeking a data modeling specialist in Washington State to build AI-ready data ecosystems and enterprise data models for analytics and AI applications.

You will work with Snowflake, Cortex AI, and Cortex Search, develop dimensional and Data Vault models, perform data profiling, and ensure governance and security standards. Collaboration with data engineers and analysts is essential to deliver scalable solutions.

Qualifications

• Experience with Snowflake environment including Cortex AI and Cortex Search.
• Strong ability to build AI-ready data and semantic data modeling.
• Experience developing models and master queries for AI agents.
• Hands-on experience in ER Modeling, Dimensional Modeling, Data Vault, and enterprise data modeling.
• Design and develop conceptual, logical, and physical data models for data warehouses and analytical solutions.
• Strong experience in Dimensional Data Modeling including Star Schema, Snowflake Schema, Fact and Dimension design.
• Conduct data profiling and source system analysis to support model design and integration efforts.
• Understanding of Data Governance, Security, reliability, compliance and data management standards
• Create source-to-target mappings and support data integration, migration, and modernization projects.

Skills

Snowflake

Cortex AI

Cortex Search

Data modeling

Dimensional modeling

Data Vault

Star Schema

Data governance

Data security

ETL/ML integration

Job description

Machine Learning Technologies, LLC is seeking a data modeling specialist in Washington State to build AI-ready data ecosystems and enterprise data models for analytics and AI applications.

You will work with Snowflake, Cortex AI, and Cortex Search, develop dimensional and Data Vault models, perform data profiling, and ensure governance and security standards. Collaboration with data engineers and analysts is essential to deliver scalable solutions.