Data Modeler

ScrollTab; New York (NY); On-site; USD 85,000 - 110,000; Full time

Job summary

A leading data solutions company based in New York is seeking a Data Modeler to create and maintain logical and physical data models. The ideal candidate should have a Bachelor's degree and at least 3 years of experience. Responsibilities include designing data models, collaborating with engineers and analysts, and ensuring data quality and governance standards. Proficiency in data modeling techniques and database systems is essential. This role offers an opportunity to impact data organization and analytics significantly.

Qualifications

• Bachelor's Degree with 3+ years experience in data modeling.
• Strong knowledge of data modeling techniques and database systems.
• Familiarity with ETL/ELT processes and big data platforms.

Responsibilities

• Design conceptual, logical, and physical data models.
• Translate business requirements into data structures.
• Optimize database performance through proper modeling.

Skills

Data modeling techniques (ER modeling, dimensional modeling)

Database systems (Oracle, SQL Server, PostgreSQL, Snowflake)

SQL and query optimization

Ability to understand complex business processes

Strong attention to detail and data accuracy

Problem-solving and critical thinking

Education

Bachelor's Degree

Tools

ERwin

ER/Studio

PowerDesigner

Job description

A Data Modeler creates logical and physical data models that define how data is organized within databases and data platforms. They work closely with business stakeholders, analysts, and engineers to ensure data is accurate, consistent, and scalable.

Key Responsibilities

• Design conceptual, logical, and physical data models
• Define entities, relationships, attributes, and data flows
• Translate business requirements into data structures
• Create and maintain data dictionaries and metadata
• Collaborate with data engineers, DBAs, and analysts
• Ensure data quality, consistency, and governance standards
• Optimize database performance through proper modeling
• Support data warehousing and ETL processes
• Maintain documentation and version control of models

Qualification

Bachelor's Degree with 3+ yrs experience

Technical Skills

Strong knowledge of:

• Data modeling techniques (ER modeling, dimensional modeling)
• Database systems (Oracle, SQL Server, PostgreSQL, Snowflake)
• SQL and query optimization

Familiarity with:

• Data warehousing concepts (star schema, snowflake schema)
• ETL/ELT processes
• Big data platforms (Hadoop, Spark)

Experience with modeling tools:

• ERwin, ER/Studio, PowerDesigner

Analytical Skills

• Ability to understand complex business processes
• Strong attention to detail and data accuracy
• Problem-solving and critical thinking