Sr. Data Modeler

Artifintech; Issaquah (WA); On-site; USD 120,000 - 180,000; Full time

Job summary

Artifintech seeks a data modeling expert to design and optimize enterprise data warehouses and analytics solutions. You will work with Snowflake environments and Cortex AI/Search to build AI-ready data foundations, craft semantic models, and develop master queries for AI agents.

Responsibilities include dimensional modeling (Star/Snowflake schemas), Data Vault techniques, data profiling, and source-to-target mappings to support migration and modernization efforts while upholding governance and

Qualifications

• Experience with Snowflake environment, Cortex AI and Cortex Search.
• Strong understanding of AI-ready data and semantic data modeling.
• Experience in 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 enterprise applications, 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

AI-ready data

Semantic modeling

Model development

ER modeling

Dimensional modeling

Data Vault

Source-to-target mapping

Data governance

Tools

Snowflake

Cortex AI

Cortex Search

Job description

US Citizen, Green Card, H-1B, OPT-EAD, CPT, Other

• 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.