Data Modeler
Core
Design and develop conceptual, logical, and physical data models to support business initiatives, analytics, and operational systems.
Role type
Senior Data Modeler
Builds
Enterprise-grade data models, DDL scripts, and dimensional models for data warehousing
Domain
Data Architecture / Database Design
Required skills
Data modeling (conceptual, logical, physical), Oracle (11g, 12c, 19c, 21c), SQL, PL/SQL, erwin Data Modeler, Dimensional modeling (star, snowflake), Normalization (3NF, BCNF), DDL generation, Reverse/Forward engineering, Data dictionaries, Metadata management, Data lineage, Version control (Git), Database internals (indexing, partitioning)
Preferred skills
Snowflake, SQL Server, Model comparison tools
Technologies
ETL, Git, Oracle, SQL, Snowflake
Responsibilities
Design and develop conceptual, logical, and physical data models using erwin Data Modeler. Generate, review, and optimize DDL scripts for database objects. Perform forward and reverse engineering of data models. Work with data architects, DBAs, ETL developers, and business stakeholders to gather requirements. Ensure models follow normalization standards and maintain data integrity. Support dimensional modeling for data warehousing. Conduct model reviews and impact analyses. Manage version control using erwin or comparable tools. Contribute to data governance initiatives including metadata management. Optimize models for performance and scalability. Assist with database migrations and schema comparisons.
Seniority
Senior, hands-on IC