Overview
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
Required Skills
Technical Skills
Strong knowledge of:
o Data modeling techniques (ER modeling, dimensional modeling)
o Database systems (Oracle, SQL Server, PostgreSQL, Snowflake)
o SQL and query optimization
Familiarity with:
o Data warehousing concepts (star schema, snowflake schema)
o ETL/ELT processes
o Big data platforms (Hadoop, Spark)
Experience with modeling tools:
o ERwin, ER/Studio, PowerDesigner
Analytical Skills
Ability to understand complex business processes
Strong attention to detail and data accuracy
Problem-solving and critical thinking
Never miss an opportunity! Create an alert based on the job you applied for.
