Data Modeller - Data Architecture

Job Description :

We are looking for an experienced Data Modeller with strong expertise in data modeling, relational database design, and data architecture.

The role involves designing enterprise data models, supporting legacy modernization and data migration initiatives, and maintaining data governance and documentation standards across AWS-based enterprise platforms. The ideal candidate should have experience working with relational and NoSQL databases, data integration, metadata management, and cross-functional Agile teams.

Responsibilities :

- Design, develop, and maintain conceptual, logical, and physical data models aligned with business and technical requirements.

- Apply relational database design principles, normalization, and data modeling best practices across PostgreSQL, SQL Server, DynamoDB, and other database environments.

- Support legacy modernization, data migration, and transformation initiatives by assessing existing data structures and defining target-state models.

- Develop and maintain enterprise data dictionaries, data definitions, metadata, data lineage, and governance documentation.

- Model data structures for APIs, integrations, and enterprise applications.

- Collaborate with data architects, engineers, business analysts, and other stakeholders to ensure data models meet functional, performance, and scalability requirements.

- Support database design reviews, SQL optimization, and data performance assessments.

- Create and maintain ER diagrams, UML models, and information architecture documentation.

- Contribute to Agile/Scrum delivery activities and ensure data modeling standards are consistently followed.

Requirements :

- 10+ years of experience in data modeling and data architecture.

- Strong expertise in relational database design, normalization, and enterprise data modeling.

- Experience with PostgreSQL, SQL Server, DynamoDB, and/or DB2 environments.

- Hands-on experience with data modeling tools such as ERwin, ER/Studio, PowerDesigner, or equivalent.

- Experience supporting legacy modernization, data migration, and transformation initiatives.

- Familiarity with AWS-based enterprise platforms and AWS data services.

- Strong understanding of SQL, database performance concepts, API and integration data modeling, and metadata management.

- Experience with data lineage, enterprise data dictionaries, and data governance artifacts.

- Ability to create and maintain ERDs, UML diagrams, and information architecture documentation.

- Experience working in Agile/Scrum environments with strong analytical, documentation, and stakeholder collaboration skills.