Data Modeler
Visionary Innovative Technology Solutions LLC
Weehawken Township, United States of America
5 days ago
Role details
Contract type
Permanent contract Employment type
Full-time (> 32 hours) Working hours
Regular working hours Languages
EnglishJob location
Weehawken Township, United States of America
Tech stack
Big Data
Databases
ETL
Data Structures
Data Warehousing
Dimensional Modeling
Entity Relationship Models
Hadoop
PostgreSQL
Microsoft SQL Server
Oracle Applications
PowerDesigner
Query Optimization
SQL Databases
Data Streaming
Snowflake
Spark
Database Performance
Star Schema
Data Management
Physical Data Models
Software Version Control
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., * 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
Requirements
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