Senior Data Modeler & Architect: Data Warehousing & Cloud

Ethereum Technologies LLC; New York (NY); On-site; USD 120,000 - 180,000; Full time

Job summary

Ethereum Technologies is seeking a Data Modeler to design and maintain enterprise data models for BI, analytics, reporting, and application development. You will translate business requirements into scalable data structures and collaborate with architects, engineers, and analysts to ensure data quality and performance.

You will contribute to dimensional modeling, data governance, and metadata management, leveraging ERwin/ER/Studio or similar tools.

Qualifications

• 6+ years in Data Modeling, Data Architecture, or related roles.
• 4+ years developing logical and physical data models.
• Strong relational database design and normalization knowledge.
• Experience with enterprise data warehouses and cloud platforms.
• Strong SQL skills and query optimization.
• Experience with ERwin, ER/Studio, or similar tools.
• Knowledge of ETL/ELT processes, data integration, and governance.
• Ability to translate complex business requirements into scalable structures.

Responsibilities

• Design and maintain conceptual, logical, and physical data models.
• Translate business requirements into effective database structures and models.
• Develop ERDs, data dictionaries, and design documentation.
• Create dimensional models using Star Schema, Snowflake Schema, and Data Vault.
• Define entities, attributes, keys, relationships, and constraints.
• Collaborate with data architects, engineers, analysts, and developers.
• Optimize data models for performance and storage efficiency.
• Support data warehouses, data marts, and analytical platforms.
• Review and improve existing data architectures.
• Establish data standards, metadata definitions, and modeling best practices.

Skills

Data modeling

Dimensional modeling

Star Schema

Snowflake Schema

Data Vault

SQL proficiency

Relational databases

Cloud data platforms

ETL/ELT tooling

Python scripting

Data governance

Education

Bachelor's degree in Computer Science / IT

Master's degree preferred

Data modeling certifications advantageous

Tools

ERwin Data Modeler

ER/Studio

PowerDesigner

Oracle SQL Developer Data Modeler

Job description

Ethereum Technologies is seeking a Data Modeler to design and maintain enterprise data models for BI, analytics, reporting, and application development. You will translate business requirements into scalable data structures and collaborate with architects, engineers, and analysts to ensure data quality and performance.

You will contribute to dimensional modeling, data governance, and metadata management, leveraging ERwin/ER/Studio or similar tools.