Senior Data Modeler - Data Warehousing & Cloud Architecture

Robotic Technologies Automation; New York (NY); On-site; USD 120,000 - 190,000; Full time

Job summary

Robotic Technologies Automation in New York seeks an experienced Data Modeler to design, develop, and maintain enterprise data models supporting BI, analytics, and application development. The role emphasizes scalable architectures and data quality.

You will translate business needs into conceptual, logical, and physical models, collaborate with data engineers, analysts, and architects, and drive governance, metadata, and standards.

Qualifications

• 6+ years in Data Modeling or Data Architecture roles.
• 4+ years building logical and physical data models.
• Strong relational database design and normalization knowledge.
• Experience with dimensional modeling and Data Vault.
• Experience with data warehouses and cloud platforms.

Responsibilities

• Design and maintain conceptual, logical, and physical data models.
• Translate business requirements into effective database structures.
• Create ERDs, data dictionaries, and design documentation.
• Develop dimensional models using Star/Snowflake/Data Vault.
• Define entities, attributes, keys, and constraints.
• Collaborate with data architects, engineers, and analysts.
• Optimize models for performance, scalability, and storage.
• Support enterprise data warehouses and data marts.
• Establish data standards, metadata, and governance.

Skills

Data modeling

Data architecture

SQL proficiency

Dimensional modeling

Star Schema

Snowflake Schema

Data Vault

ETL/ELT

Cloud data platforms

ERwin/ER Studio/PowerDesigner

Data governance

Python scripting

Education

Bachelor's degree in Computer Science / IT / Data Engineering

Master's degree in Data Science / Data Architecture (preferred)

Data architecture or modeling certifications (advantage)

Tools

ERwin Data Modeler

ER/Studio

PowerDesigner

Oracle SQL Developer Data Modeler

Job description

Robotic Technologies Automation in New York seeks an experienced Data Modeler to design, develop, and maintain enterprise data models supporting BI, analytics, and application development. The role emphasizes scalable architectures and data quality.

You will translate business needs into conceptual, logical, and physical models, collaborate with data engineers, analysts, and architects, and drive governance, metadata, and standards.