Data Modeler

Data ModelerA 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 ResponsibilitiesDesign conceptual, logical, and physical data modelsDefine entities, relationships, attributes, and data flowsTranslate business requirements into data structuresCreate and maintain data dictionaries and metadataCollaborate with data engineers, DBAs, and analystsEnsure data quality, consistency, and governance standardsOptimize database performance through proper modelingSupport data warehousing and ETL processesMaintain documentation and version control of modelsRequired SkillsTechnical SkillsStrong knowledge of: Data modeling techniques (ER modeling, dimensional modeling)Database systems (Oracle, SQL Server, PostgreSQL, Snowflake)SQL and query optimizationFamiliarity with: Data warehousing concepts (star schema, snowflake schema)ETL/ELT processesBig data platforms (Hadoop, Spark)Experience with modeling tools: ERwin, ER/Studio, PowerDesignerAnalytical SkillsAbility to understand complex business processesStrong attention to detail and data accuracyProblem-solving and critical thinking