Data Modeler - Erwin

Description :

Key Responsibilities :

- Design and maintain enterprise-level data models and architecture solutions

- Optimize Data Warehouse and Data Lake schemas for scalability and performance

- Collaborate with business and technical stakeholders to understand data requirements

- Manage metadata, data lineage, and governance standards

- Support ETL and enterprise data integration processes

- Ensure data quality, consistency, and compliance with governance policies

- Improve reporting, analytics, and query performance across platforms

- Work on dimensional modeling and enterprise data architecture best practices

- Support cloud-based data platforms and modernization initiatives

- Maintain technical documentation and architectural standards

Required Skills & Experience :

- 10+ years of experience in Data Modeling and Data Architecture

- Hands-on expertise with ERwin, PowerDesigner, or similar modeling tools

- Strong SQL expertise with Oracle, SQL Server, and PostgreSQL

- Experience in dimensional modeling and enterprise data warehousing

- Knowledge of ETL and enterprise integration processes

- Experience with Snowflake and Azure Synapse

- Strong understanding of data governance, metadata, and lineage management

- Strong analytical, troubleshooting, and problem-solving skills

Preferred Candidate Profile :

- Experience working on enterprise-scale data architecture projects

- Strong understanding of modern cloud data platforms and analytics ecosystems

- Ability to collaborate with cross-functional teams and stakeholders

- Strong communication and technical leadership capabilities