Sr. Data Modeler

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

• Experience in working with Snowflake environment, including Cortex AI, Cortex Search
• Strong understanding of building AI ready data and Semantic data modeling
• Experience in developing models, master queries for AI agents
• Hands-on experience in ER Modelling, Dimensional Modelling, Data Vault, and Enterprise Data Modelling techniques.
• Design and develop conceptual, logical, and physical data models for enterprise applications, data warehouses, and analytical solutions.
• Strong experience in Dimensional Data Modelling 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.

We are an equal opportunity employer. All aspects of employment including the decision to hire, promote, discipline, or discharge, will be based on merit, competence, performance, and business needs. We do not discriminate on the basis of race, color, religion, marital status, age, national origin, ancestry, physical or mental disability, medical condition, pregnancy, genetic information, gender, sexual orientation, gender identity or expression, national origin, citizenship/ immigration status, veteran status, or any other status protected under federal, state, or local law.