About this role
# Position Summary
The Data Modeler will lead data architecture assessment, target data model design, legacy data analysis, and modernization of the Client Data platform. The role supports migration of applications to a modern cloud-native architecture hosted on AWS. The Data Modeler will work with architects, business analysts, SMEs, developers, QA teams and modernization specialists to define canonical data models, integration structures, data governance standards, and future-state information architecture.
Key Responsibilities
- Conduct current-state data architecture assessment across Data Platform modules and data structures.
- Analyse source systems and define data mappings for migration and integration initiatives.
- Create conceptual, logical and physical data models for Disclosure and Work Actions modules.
- Having hands on experience in Data vault .
- Having QNXT experience is a Plus
- Design and maintain conceptual, logical, and physical data models for enterprise applications and analytics platforms.
- Develop dimensional data models (Star Schema, Snowflake Schema) for reporting and business intelligence.
- Create and maintain data dictionaries, metadata repositories, and data lineage documentation.
- Develop workforce analytics frameworks and KPI measurement models.
- Support data modernization and cloud migration projects.
Required Experience
- 12+ years in Data Modeling and Data Architecture.
- Strong expertise in relational database design and normalization.
- Experience with PostgreSQL , Dynamo DB, SQL Server environments.
- Experience supporting legacy modernization programs.
- Hands-on experience with AWS-based enterprise platforms.
Technical Skills
- Data Modeling tools: ERwin, ER/Studio, PowerDesigner or equivalent.
- Data migration and transformation concepts.
- Metadata management and data lineage practices.
- UML, ERD and information architecture documentation.