Sr. Data Modeler

Ethereum Technologies LLC; Issaquah (WA); On-site; USD 120,000 - 160,000; Full time

Job summary

Ethereum Technologies is seeking a data modeling expert to design and develop enterprise data models for data warehouses and analytics platforms in a modern Snowflake-based environment. You will implement dimensional modeling, data vault concepts, and semantic data structures to support AI-enabled analytics and Cortex-powered search capabilities.

The role requires hands-on experience with ER/Dimensional/Data Vault modeling, Snowflake, and governance practices to ensure secure, reliable data

Qualifications

• Experience with Snowflake environments and Cortex AI/Search.
• Strong ability to model AI-ready and semantic data.
• Experience in developing models and master queries for AI agents.
• Hands-on with ER, Dimensional Modeling, Data Vault, and enterprise data modeling practices.
• Design and develop conceptual, logical, and physical data models for data warehouses and analytics.

Skills

Snowflake environment

Cortex AI

Cortex Search

AI-ready data & semantic modeling

AI agents modeling

ER Modeling

Dimensional Modeling

Data Vault

Enterprise Data Modeling

Data governance & security standards

Tools

Snowflake

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.