Job Summary:
The Data Modeler is responsible for designing, developing, and maintaining enterprise-grade data models that support critical business initiatives, analytics, and operational systems. The role requires proficiency in industry-standard data modeling tools, particularly erwin Data Modeler, along with extensive experience in Oracle and SQL Server databases. The Data Modeler will translate complex business requirements into robust, scalable, and normalized data models while ensuring alignment with data governance, performance, and integration standards.
Key Responsibilities:
• Design and develop conceptual, logical, and physical data models using erwin Data Modeler.
• Generate, review, and optimize DDL scripts for database objects, including tables, views, indexes, constraints, and partitions.
• Perform forward and reverse engineering of data models from existing Oracle and SQL Server databases.
• Collaborate with data architects, DBAs, ETL developers, and business stakeholders to gather and refine requirements.
• Ensure data models adhere to normalization standards, data integrity, and referential integrity.
• Support dimensional modeling for data warehousing and analytics use cases.
• Conduct model reviews, impact analysis, and version control using erwin or comparable tools.
• Participate in data governance initiatives, including metadata management, naming standards, and lineage documentation.
• Optimize data models for performance, scalability, and maintainability across large-scale environments.
• Assist with database migrations, schema comparisons, and synchronization between environments.
• Assist in optimizing existing data solutions.
• Participate in design reviews and follow guidance from Data Architecture team members.
Required Qualifications:
• 3+ years of hands-on data modeling experience in enterprise environments.
• Expert proficiency with erwin Data Modeler, preferably version 9.x or higher.
• Advanced SQL skills and a deep understanding of Oracle and Microsoft SQL Server databases.
• Strong command of DDL for creating and modifying database objects.
• Solid understanding of database internals, including indexing strategies, partitioning, clustering, and query execution plans.
• Experience with data modeling best practices, including normalization, denormalization, surrogate keys, and slowly changing dimensions.
• Familiarity with version control systems and model comparison/diff tools.
• Excellent communication skills, with the ability to document data models and present information to technical and non-technical audiences.
• Self-motivated, with the ability to multitask and work effectively in a team environment.
• Ability to adapt to a fast-paced, energetic, results-driven, and solution-oriented team culture.
• Ability to deliver high-quality results on challenging projects while setting and achieving challenging yet realistic goals.
• All qualifications mentioned in the job description are required.
